my data looks like the following
111    0    01/01/2007
111    0    02/01/2007
222    0    04/01/2007

Hi, I'm using access 2003 or 2007 and have some programming background but a
minimum knowledge about SQL, anyhow i'm making a database for my a small
company where the Invoice table has a one-tp-many relation with InvoiceLine
table.  InvoiceLine represents individual items, ...

I have a table named "Applications" that I want to append data to from
another table named "Producer Percentage". Both tables have matching
"Percentage" field names and both tables have matching autonumber fields
named "ContactID"

I am using a make-table query in my WInXP Access 2002 database in another
application (ESRI ArcView GIS). This application can only link to tables int
eh database, and not select queries.
Is there a way of updating the Make-table query when the information in the

This is probably really simple, but can anyone helps with this question?
I have a table with a field called UnitCode, in which the data is always
three letters followed by four numbers (eg ABC1234).
I want to create a query which selects records from the table based on a

I have a problem and I think the answer is probably obvious.  I have several
tables with the same exact fields (the column names are  the same), but
different data in the fields (each table represents a months worth of data).  
My goal is to create a series of queries that take ...

I was development a query and than to a messange "Unknow", and query end.
I don't know , how to solution this error.
thanks
Ademilson

i have this question..is it possible in access to create a querry so when
three check boxs are filled , to send an e-mail at a pre-defined email
adress?  
thanks

I am combining several old data items into a single Summary memo field.  I
would like to be able to add a label for the data and then have each data
item to be inserted on a newline.
Thanks for your help.

I have 2 tables with exactly the same fields and the same number of
records.
Every day those 2 tables (updated) have to match. How can I proceed to
ensure myself that there is no difference?

I am trying to set a "dynamic" criteria limit for a date field that will
limit query results to everything occuring since the January BEFORE the
current fiscal year. Our Fiscal year is April 1 to March 31.
If today's date is November 28, 2007, I want to see all results occuring

The following SQL selects 8 records from a table [Judges].
SELECT Judges.[Judge ID], Judges.[Contest ID]
FROM Judges
WHERE (((Judges.[Contest ID])=30));

Just plain brain dead ayt this point!  Access XP on Win XP
Query to find the unique value sets in a table. HAve approximately 5200
records in a table. One field is date, another is classname. How do I set the
query to only display UNIQUE date/classname combinations. I am sure I ...

I have a query in Access2007 which contains reansactions of several years. I
work in design mode and I want my query to return only transactions of a
custom defined date range that will be defined by the user at execution
time. I tried to use criteria (>StartDate <EndDate) which ...

Hi i am having two tables
1: Code (3 fields)
2. Data (4 fields)
Code-asset_value-Month_fig_refer