I'd like to run a query where the query grabs information current month to
date, 1 month previous, 2 months previous all the way to 5 months previous.
Example:
Units Sold    June      May   April  March  Feb  Jan

Hi, I have problem in query and I am not sure if it is possible.
My query has a column for
Branch,DateProcessed,OpeningBalance,Payments,Collections&
ClosingBalance. On the first entry all data will enter manually

Good Morning Everyone:
I just realized that my queries are not calculating from the date I
input, but instead today's date.  I had a parameter set up that
specified that date that I wanted put it.  I noticed this b/c I was

I have a tabel that has VendorID, InvNo, PayKey.
The vendor can have duplicate invoices if the paykey is the the same.
The vendor cannot have duplcate invoices if the payke is not the same.
EXAMPLE:

I've been writing a query which is subsequently used as a source in an
update query (so it has to be updateable).
When I run the (slow, ~10 minute) query, I get the wrong number of
records returned (e.g. 1687 instead of 1688).  After determining which

I hope someone can help.
I have a small inventory database, and I want to make a form where a user
can specify upto five different criteria to search by. I tried using this in
the Criteria box on the design grid: = forms!SearchForm!category and so on

SELECT [Truck rates].CODE, [Truck rates].PAY_CONTRACT_CODE, [Truck
rates].RATE, [Truck rates].EFFECTIVE_DATE, [Truck rates].DESTINATION_CODE,
[Truck rates].PAY_ACTIVITY_CODE, [Truck rates].BLOCK_CODE
FROM [Truck rates]

I am working with access 2003 and I would like to update one field in table
A. The value of this field I get from a select.
The query I would like to build is like this:
UPDATE Table_1 AS T1 SET T1.Field_1 = (select field_2 from Table_2 AS T2

I need to create a report based on the total amount of records there
are in about 8 different queries.  I don't need any of the information
except the total amount of records that there are.  Any help would be
appreciated.

I am planning a database that tracks certain data that comes in as a monthly
total.  So I have a figure for Jan-07, Feb-07, etc.  I plan a field for the
total and a field for the month/year.
In queries I will want to be able to select data that might include a range,

Hello  I have a question concerning unmatched queries.   I have two
tables.  There is no unique identifier.  I quess the whole row can be
considered a unique identifier.  I want to pull out the data from one
table that does not match the data in the other table.  There are some

I have 25,000+ lines of sanitized medical claims data in an excel file.   I
have imported into an access table, and can do a lot of what I need, but not
all.
Many mbr ID’s (bogus, for security) have many, many claims, but with

How do you get a report to open with the exact data based off of a form? I
have a form with approx 8 fields. I want to have a button that will a report
based off the exact data I am looking at on my form. How is this done. I can
get as far as putting a button on my form to open a ...

I have a query that pulls 6 columns out of a table.  These columns are:
Record #, Date Issued, Part #, Qty Rejected, Comments, DMR Complete.  In the
table, the DMR Complete field is a text field with either 1(yes) or 0(no).  I
am wanting to have a report that only shows the ...

I would like to know if there is an Access queries that allows me to take a
table that has two columns and combined them into one.