hi i have access database table with accountid and datetime fields. There are more than 1 records for each account id. how should i write a query to retreive...

I have a table with approx 270K records. One colum contains an ID codes i.e. WATUA1, WAXUB0 etc. I need to change the last to letters to AA, i.e. WATUAA,...

Hello... I have a database with data that looks like this: ID_NUM STATUS 12345 O 12345 O 54321 C 54321 O 54321 O 67891 ...

I have a table in my database which has several records for each student. Each record lists each test taken in a separate record. Smith John ACT Smith John...

I am having a problem with this query. I would like to show the latest product in all the tanks based upon the latest date for that tank. Table: Tank ...

How do I do an acess query with 15 % as the discount of let say 15,378.00

How do I set-up a query in Access to review two excel spreadsheets for matching information?

Any help would be appreciated. When viewing records resulting from a multiple table query, I discovered "Duplicate" records being selected. However, all...

I am using vb-access for my application. In one report i am using between operator in SQL to fetch data from access database. the following is the query: SQL...

Hi, I am customizing the Issues Database Template (from the MS Template page) http://office.microsoft.com/en-us/templates/TC012186931033.aspx to use...

I have the following columns in my Query: Column A - Field: STR_NBR, Table: PRTHD_STRSK_INV_SSTATS, Sort: Ascending, Show: Checked Column B - Field: SKU_NBR,...

Good Day Situation: I have a query in which I am trying to create to address the following data in my table. The coding is created in two parts Changes...

I have a calculated value stored in a table, when I run a query on that table, the values in that field do not show. Why and what can I do about it?

I have generated a query from combination of a few tables. This query has data in numeric format, often with decimals. The Datasheet view shows the numeric...

Hi, I have a table with 302000 records and I need to query column A to only pull the items with 8 characters in the field. I've tried Like "********"...

Need help! I have designed a simple query to add numbers in six colums then in the forth column, I have an expression that adds them all up then divides...

When did Access 2003 allow changes to be typed into a query that subsequently change the table that they were based upon? This is a very dangerous change to...

I am trying to add a column of information based on values already in another column in the query. Specifically, I want to put a value in...

What criteria would I use to limit my results to include only records that come up a certain number of times? I'm trying to limit my results to include...

Hi, I have a simple query which I have a true/false field in. I would like to only display the true records so I ad "true" into the criteria section the...