i am working on an append query, it seems to return the data i want to get in
the table, however, when i attempt to run it, i get an error message says
"Could not find file 'C:\.......\My Documents...'"
Where it is looking is not where i have the database. The database is in its

I need to write two seperate statements. One returns the max value from a
table and the other returns the 2nd highest value. Any help?

I have a form that i use to book vehicles in to our workshop for work
required, along with various fields, ie customer, make, model etc there is a
field called regnumber, there will be multiple instances of regnumber,
depending on how often the vehicle comes in for work. I have put ...

I learned a while back that one can create temporary/global variables which
are referred to as such:  [TempVars]![myglobalvariable].  I have used these
in fairly innocuous situations quite nicely.  However, I have a situation
where the temp variable will be used in a number of ...

I am having problems with an outer join in a query. Not sure where it is
coming from. What I have is a SQLBase server made by Unify company. I am
trying to make an Access 2003 report. 2 tables Purchase_Order and
Purc_Order_Line. There are times when the purchasing dept starts a ...

I am using Access 2003. I wrote a query with a parameter. The query
uses a dialog form in which I had placed a Combo Box for the
parameter. Yet, when I run the query, the dialog form is displayed
with a Text Box instead of a Combo Box.

I have an issue with a SELECT query I have built. The query generates 25
fields from 3 of different tables/queries. The problem I have is with the 1
extra field I want to add to the end!
The majority of the query is sourced from 1 table (tbMRAInput). This table

Hello, I am looking into buying access 2007 but I am unsure if it will be
able to compare two tables and to highlight what data has changed. More
details:
Every day I need to compare a newly imported table of about 200,000 records

I have two tables that link on a common field and I need to find records that
exist in one of the tables but not in the other.  I'm not sure how to write
my query to do that.

How do I restrict a query from updating. i.e. it is only a snapshot. The
query in question is retrieving data from 3 tables. I only want to see the
data and not update it.
The background is that I have a form with one combo box and a subform based

I am struggling with a DSum calculation...this is what I am asking for:
total time in minutes: DSum([time in minutes],"schedule report new","order
<= " & [order] & "")
and this is the output that I am getting:

I have the following table shown below:
Piece_Operations:
PieceID  OperationID Operation StartTime StopTime
=================================================

I am setting up a database that will take fuel log records and
calculate daily mileage, usage, gas mileage, etc. The record will have
Date-Truck#-Mileage(at time of fueling)-Amounts(Gallons)-Fuel Price.
In order to Query the database to find miles driven in a day for a

I have inserted 2 lines of data from a TimePro timeclock database.  The first
line reflects the 1st half of an employee's shift.  The 2nd line reflects the
2nd half of the shift.  The time between the 2 shifts equates to a meal
break.  

Using MSACCESS  
I know this has to be simple and I am just missing it.
In my database I have:
Customer number 1234