I created an expression in a query in access 2000.
RoadBlockHours: [SumOfNumMinsPerRdBlk]/60
I have 2 problems when I run the query.
First problem is I get a pop up window with this in it.

I have a command button in a form that runs a macro that runs several update
queries, and I can't figure out how (or where) to limit the update query to
the record I'm currently in.
Do I set it as a condition in the query? or the macro? and what syntax do I

   I have posted a question similar to this before, but I did not
understand what the responder was conveying so going to post again.
I have a Database that has 3 tables.
tblPilots

I have a table with information about my stock, 4 of the fields have my
stock quantities.. Store1, Store2, Store3, and Bulk.
I'm trying to use a query for a report to only display the records where the
stock quantity is a neg in ANY of the above 4 fields, however this isn't

I have a table (Table name : Lotto) with 23 fields (D_No, DrawDate
P1, P2,.....P21) and it has draw results from 1st Sep 2004 till date
I have another table (Table name : Check) with 15 field
(F1,F2,....F10, R6, R7, R8, R9, R10). I have few lacs combinations o

I am creating a bibilographic database, and want to have a library catalog
feel.  I want to be able to perform a query and search for items that have
certains words in there.  Is there an easier way to do it than using the
wildcard figures?  Also, can they be used in combination ...

I don't have a program that can read xlt files. Is there a way I can convert
xlt to exe? Thanks for your help.

I have tables that are linked to a SQL Server DB that stores the date in a
numeric format (example:  1092432704).  I need to convert this to a date
format.  If I paste the data into Excel and change the cell format to date,
it changes it correctly.  Anyone know the command in SQL ...

I'm trying to find duplicates within a table where a field name called
APP_KEY  is made up of 12 digits. However, I want the query to ONLY find
duplicates based on the first 9 digits: For example,
APP_KEY:

I am working on my Aviator Database and I have the query set up to show me
how many hours between two certain dates a pilot has flown.  It works great
BUT if a pilot has not flown any hours then he/she is not included in the
Query.  Is there a way to have the query list all the ...

I have a problem.  I have a query that prompts the user to enter a date range
for their report.  I'm using Between...And... date function in the query as
the parameter.  The field date is the long format e.g.,  5/20/05 7:00:00 AM
so the query returns erratic results.  If works ...

I have created a crosstab query that calculates the sum of points by dates
for employees.  I have a column heading in my crosstab query that is Date.  I
am trying to do an expression in my Criteria so I can select a date range.  I
currently have in my criteria...

Access 2000
I have a db that is causing me problems, with setting the team criteria.
I want to run a query and have [Enter Team Name], then return all results
that are for the team lifetime in the db (approx 85,000 records).

how can i list all my customers joined to their orders (left join) and have
a date filter. but i still want it to show the customers that havn't placed
any orders in that date range, i want their order fields to show null. right
now it doesn't even show the customer name if they ...

In a Query when you select Query -> Totals.. there is a total "Where" that
you can select.  What does this do?