Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ms-access-2010]

52 questions
5
votes
3 answers

Microsoft Access Export to Excel

I have an Excel spreadsheet that is filled with a ton of data which is organized by column (a column for names, a column for occupation etc.). I have recently moved all of this data into Microsoft Access 2010 to work with, but I do require to move…
CDZ
  • 51
  • 2
4
votes
1 answer

if 0 show " ", if <500 show "B", if >500 show "R"

I'm working on a query in Access 2010 and need help. If the value is =0 I want it to show as blank, if the value is <500 I want it to show as "B", if the value is >500 I want it to show as "R"
Julius
  • 43
  • 2
3
votes
3 answers

Access 2010-2016 Compatibility Error

I was just updated to Access 2016, while my users are still at Access 2010. I opened our database in MS Access 2016 once, didn't make any changes, and closed it out, and now all the users are having errors for ANY basic VBA code, including: StrConv…
pblo
  • 31
  • 1
  • 1
  • 5
2
votes
2 answers

Splitting 1 record on one table to become two records on another table

I am REALLY very new to this so please excuse my ignorance, but I could really use some help! I've got two tables: BillsFiled and Authors On BillsFiled, there are the columns: ID, Symbol, Filedate, Type, Author, Title, Summary, among others This is…
Glen Cullen
  • 21
  • 4
2
votes
1 answer

MAX and MIN for each car model

I have a problem with a query. I have a db with car and their spec, every model has a different car related to that model with its price. I want to create a query that gives me the min and max price for each models. something like…
Prof.Lidenbrock
  • 23
  • 3
2
votes
1 answer

Should I maintain relationships diagrams in the back-end and the front-end?

I’m developing an Access 2010 database application. It is split into a back-end, holding all the tables, and a front-end, holding all the queries, forms, etc. I find the Relationships tool helps provide an extremely valuable visual resource (an…
Martin F
  • 311
  • 1
  • 3
  • 15
2
votes
1 answer

Distinguishing Records with Related Fields

I'm a newer user (obviously) and would greatly appreciate question writing suggestions as well as answer suggestions: I have a lot of interrelated tables which largely depend on my Products table, which is the master list of a certain product. Much…
ZX9
  • 253
  • 1
  • 9
2
votes
0 answers

Select number of records until the sum is less than 'n' - Access SQL

I am working in Microsoft Access. My requirement is: user will give any percentage value and I have to find the number of IDs which form the percentage of the 'Value' column. For eg in the below dataset (it is sorted by descending of value column…
RanjithKumar Govarthanan
  • 251
  • 1
  • 2
  • 4
1
vote
1 answer

Access 2010 After Insert data macro to update another table

I have an Access DB with 3 tables. Table 1 Appointments Fields with Data that is not used anywhere else, but some of the information is inserted into 3 with a after insert Script. Table 2 Usage Data of Salesmen I need some of the fields from here…
Chris Bruhin
  • 11
  • 1
  • 1
  • 3
1
vote
1 answer

"No Current Record" when using COUNT() in Access 2010?

Okay, so, I'm trying to get a count of how many customers each service provider has billed for over the last year or two. Our database's data is slightly imperfect, so I'm trying to kludge together a solution. Basically, we have a number of service…
Michael Gmirkin
  • 21
  • 2
1
vote
1 answer

Access Value between ranges

I'd like the following population logic built in an Access database: I have two tables. The first, Table1 contains a set of buckets, with a starting and ending value: Start End Bucket 0.00 0.08 1 0.08 0.16 2 …
granady
  • 11
  • 1
  • 3
1
vote
0 answers

Why is Microsoft Access ADP file claiming my query is misspelled, with a 1 at the end of the query?

I have a Microsoft Access 2010 database file of type ADP (which can be compiled to an ADE file). This front-end application interacts with a Microsoft SQL Server in the backend. This application works fine in the current environment, but is having…
DRVr40Go
  • 11
  • 2
1
vote
2 answers

Are there alternatives to Microsoft Access?

In my office, we often use MS Access for many applications (eg creating reports, data analysis and data processing) because it is convenient to use (easy data import, fast query building, easy automatization with VBA) Unfortunately, it starts to be…
Rico
  • 19
  • 3
1
vote
0 answers

UPSIZING ACCESS 2010 to SQL Server 2014

When I run the upsizing module it goes through the motions but the report at the end says "table was skipped or export failed" for each of the tables. I can't find a solution for this. I can't figure out why this is?
Deana
  • 11
  • 1
  • 1
  • 5
1
vote
1 answer

MS Access 2000 Application - SQL Server

I have an old MS Access 2000 application which connects to a SQL Server 2000 database. I need to migrate this database and application to a new server with SQL Server 2012. The Access application is running locally on my user's workstation. …
EASTBAY_DBA
  • 11
  • 3
1
2 3 4