Hi, I am trying to copy a large database from one computer to another
location, but when i have done this the files which are located on the new
computer are saying that the "path" is incorrect and the tables, queries
cannot be found. Please advise how i can do this successfully. ...

I want to be able to run a query so that it shows the last 12 months data by
month.
Any ideas?

I want to make the following into a conditional statement. Please let me know
exactly how it should look. The basic formula is as follows:
Balance (column name): IIF ([field name1]>$0.00, then [field name2]-[field
name1] OR

I have a select query in ACCESS 2003. It contains a DATE field that is
necessary but I do not want to GROUP by it.  It causes problems in the
resulting report when it groups by the date.  If I take GROUP BY off the DATE
field and just leave it blank I get an error (something ...

I am working on a query that I need to return a certain range of dates in a
date field.  I would all records that contain a date that is at least 60 days
from today's date (in the past) but must be 12/28/07 or greater.
What can I use in a query that will return only the records in ...

Can anyone help? I have a table with the following columns: ID, Diagnosis1,
Diagnosis2, Diagnosis3, Factor1, Factor2 and Factor3.
What I would need to have is a table with 3 rows for each ID and only two
other columns: Diagnosis and Factor. Like this:

I am attempting to create a query in where any field that does not contain
data in relation to the criteria specified will not be shown in the results.
I am aware of the show box however this will not show the field whether it
contains data or not. Please help.

Is there a way to align dates using SQL in Access?  My problem is as follows:
I have a table that only shows the start date of a particular contract for
each record(no column for end date).  I want to query the table so that if a
record has a second (third, fourth, etc) start date ...

I have the folowing task to do but do not really understand how to do this?  
as below
Open the qryStudioMovies query and show the StudioName in rows and the
MovieTitle in columns. Save and close the query

We have a database table (in Access 97) which needs a new row added each
month but only a handful of the fields change regularly, the rest almost
always stay the same.
What is the easiest way to ask for a few inputs from the user and

I need to fill the blank fields with the value of the same field of the
previous record.
For example : 3 fields in the tableA,  4 records.
FIELD1, FIELD2, FIELD3

I have the following query (see below).  My primary field is TECH_Id (alias
CAPId) - and I want to return just one row per CAPId value.  However, I have
found that on occasions I am being returned 2 or more rows per CAPId.  This
is because the query is returning multiple values ...

SELECT Performances.Perf_Key, Performances.Perf_Date, Performances.Perf_Dancers
FROM Performances
WHERE (((Performances.Perf_Dancers) Like [Enter Search Criteria For Dancers]))
ORDER BY Performances.Perf_Dancers;

Can anyone tell me what is wrong with this SQL for a UNION ALL.  What I end
up with is a query that only shows the fields from the very First table in
the list.  I also get input boxes asking for parameter value for STORE, MILK
GAL, MILK PINT.

I am trying to bring data across records together. Not sure if this can be
done in Access.
CompanyName   Products
Test1                 Cups