I have to create a query that will have three fields; MonthYear, MonthSales,
Previous12MonthSaleTotal.  Any ideas how I can generate the  
Previous12MonthSaleTotal sum amount?   For instance:
The MonthYear field values would be like "JAN 06", the MonthSales is the

Thanks for taking the time to read my question.
I have a product list that has an ID for every product. Each product has a
name and a size.  I have a combo box on one form where size doesn't matter
(ha ha ha) but I need to limit the combo box list to only 1 of each product.  

I'm a SQL 2000 developer and I'm used to simple, straight forward queries
whenever I have to relate more than five tables throught INNER JOINS.
Now, I have to make an application easy enough so that the user by just
selecting certain criteria from options control boxes that ...

I've got a pivot table query that in all but one case is running fine.
It sums up hours by user/Project across Dates. It is used to view users
time for a given period.
The table the hours is pulled from limits the time to 2 decimal places.

I would like to append to a table just the new records;
So if today I appended 1 and 2; and tomorrow the result of the query is 1,2
and 3, I want to append just the 3 one.
How do I do that?

I have a query with a basic prompt, but sometimes when I run it, after
entering a value, the prompt reappears and will not accept any value I
enter.  Sometimes the query and the prompt work just fine, sometimes it
just repeats the prompt until I escape out.

I'm using query builder to look for all records in a column that contain the
word "free"
I'm using *free* in the criteria line which returns records containing
"free" but also "freedom" "freely" etc.

I have two seperate customer tables and the only way we can identify overlap
is where First Name ( first 3 characters using LEFT([First Name], 3) ), Last
Name and Zip are all equal. The tables are designed as:
Account Number (seperate naming conventions)

I want to split field in two before and after a carat (^). Problem is, I
can't use Left or Right trim because num of characters is always diff. Any
ideas? Perhaps Mid?
22451^Jones Incorporated

The query is called client query. This query has  two tables in it, they
are Clients, and Vehicles tables.
The Client table has
ClientID - primary Key

First let me say thanks to all the MVPs out there.  Reading through the
various postings in these newsgroups has been an invaluable education!
Here's an interesting one.  
1) Having to select the Min and Max Date Range on Hotel Registrations.  I

I really need help on this:
I want to search for a certain text or number on a table
for example in this query:
SELECT *

We've been handed a dump from a database from an external source.  The
tables are Customer, Address and Contact Number.
We're trying to produce a report displaying all customers.  We only want a
single contact number on the list however when we use MAX function it removes

I am using Access 2003 and Windows XP Pro.
My database is sales oriented.
On my form, the following information is contained:
Order ID

Please help.  I've created many db's in '95.  Creating new
db in 2000 and trying to use command button wizard.  I
can't seem to get any command button working with the
wizard creating an event procedure.  I end up creating