Hello I need help adding a column to a select query that will number the selected records sequentially (1-75 for example) according to primary key number...

I have a table that I need to pull only the max date for each item. I will give an example below. Item Unit of Measure UPC Effective...

In the 2003 version, my queries were working fine. Now in the 2007 version, when I pull up one of the same queries and try to switch into Design View, the...

I have three tables, one for tools, one for signing them out and one for returning them. Trying to kill two birds here. First I have been trying to figure...

I need to measure the tallies in the "SEVERITY" column over the last six months from the date range in the "START_DATE" column. I hope that makes...

I use a query to generate individual P.O.s for ordering items. Usually each order has only one acct.#, but ocasionally there are multiple acct. #'s and I...

Hi I am looking for the definition of how to join multiple tables in queries. I normally use SQL server and the access queries seem very...

With much help, I have set up the parameters to select a date range for my query. Now I need the date range to appear on the query and subsequent...

I have a select query. However, I can't figure out a way of determining the number of records returned by that query. I want to display that number in a...

Is it possiable to have a iif function in a query where it looks at the next record. for example if I run the query which lists years and if the results in...

Problem: opening a recordset in code returns only one record when it should return two. Details: In VBA I construct a SQL string as follows: strSQL =...

I've been looking thru the posts but I havent been able to find an example for what I need: given that I have two tables: NAMES with columns NAME LAST_NAME...

I have a query question. I have a particular list of item numbers. Some items have multiple vendors. I would like a report that creates one row per item and...

Hi Thank you for taking time to help me out. I have a table containing YearNo,*,*,*, PlayerID, Initials,*,*,*,RojterCupPoints,*,*,* RojterCupPoints determin...

Following is my SQL and it is base on a query that I sort by date criteria. The problem is when I change the date and there is no data for some inspectors...

I have a cross-tab query that works fine as far it concerns the resulting data. For business reasons, I need to change the order of appearance of the row...

My data table is like this: Type Price1 Price2 Price3 Result Black 2 2 3 No Blue 2 5 6 Yes Black 0 4 5 Yes Red ...

One more question and I should be done with my first foray into Access. All of your help is greatly appreciated. From my table , I need to subtract plus ...

Hello, my problem is that i want to create an appending query that will transfer data from one horribly designed table to many other tables. tables are...

Hi, Is it possible to copy the results of a query to a table? Thanks in advance.