I have two tables, table1 and table2.
Table1 contains fields named "BTN", "product", "sale_date", "product_type"
There are various products in the product table with a date for each sale.
The sales field contains 1 of 4 values that desccribe the catagory of each

I have a query that acesses linked tables.  When I use a parameter criteria
(Date or Job Number) I get record deleted and the query aborts.  If I enter a
date or Job Number the query runs and returns the expected data.
I can't figure the logic on this.  Anyone got any adeas how to ...

I have 2 tables holding address details.  Once details have been input into
table 1  I wish to update table 2 with the same data where 'Yes' is chosen  
in the  'Update Address'  field.  Would this be done by using an append
query? Or an update query? and if so, how?

I am a small business IT guy going to cal poly full time and working
close to 30 hrs a week at this company.  I am the only programmer
there, but there is another IT guy that handles leads and stuff in our
dialer.  The management here is completely scatterbrained and changes

I am looking for MS ACCESS programmers using Visual Basic and C++ in India
or off shore.  Anyone out there interested in work?
Experience with MS Word, WinFax Pro, Windows XP Fax Solution, and Outlook
2003, is required.

I have a table with integer data as follows:
book  pen  bag   month cyear
10     20     30     1           2004
15     20     5        2          2005

My delete query is asking "which table to delete records from?"
I used the asterick of the table from which I want the records deleted.
Can't figure it out.

I have created a form named frmcommbysource with 3 controls.  First control
is a combo box named cbosource that has two fields, ID and name.  The other
two controls are both date/time picker controls called dtstart and dtend
respectively.  I then created the first of 3 queries ...

Using Access 2003: have a query which calculates the total number of days
using 2 date fields (admit date and discharge date).  If the discharge date
is null, I would like to use todays date in its place.  My guess is an IIF
statement would be used, but I have no idea as how to ...

I am trying to reformat a date/time field to export it without the time.  
Article 291245 gives a suggestion (Method 1), but I can not figure out how to
implement the suggestion.  Can not figure out how to do a new calculated
field with the suggested format.

I'm not sure what I am doing wrong. I have a crosstab query, nothing fancy,
but I keep getting an "overflow" or "property not found" error. I can't find
the error in the help files, nor does it give me any explaination of the
error. Has anyone else had this error?

I am using the following query:
SELECT Year([ClosingDate]) AS [Year], Month([ClosingDate]) AS [Month],
Count(File_Tracking.FileNumber) AS Files
FROM File_Tracking

I have several tables, each with the same structure, one for each month.  I
prefer to keep them separated by month, as they are very large, and a single
table with all months would be several million records long.
I need to be able to use a query to search through the previous ...

I'd like to create a query using a start and ending date but I don't want the
Query to group-by the date giving me info from every date input into the
system. Instead, I'd like the query to just recognized the data range and
give me a one line resolution of the data requested and ...

I have a table that has a text field that contains a list of names separated
by commas.
Table 1
    Cause Effect ID