This line of code takes 20 seconds. Can anyone provide faster code? The
underline query has a calculated field Minutes:[TimeOut]-[TimeIn]. It links
to SQL server which has 30,000 records. Thanks.
=Int(Sum([minutes])/60)

I am trying to add numbers in different columns  in a query and display the
result in a new column [total score] as follows  total score: [cvs]+[cns]
The results that I am getting are as follow 2+2= 22 not 4
How can I change this please?

Please kindly help .  I am trying to report the latest 6 records for a
particular query example below based on the date. In my report I should only
display records from Apr 4 to Apr 10.  Please help to assist.
Category A

Dear Collegue:
I need to be able to do the following:
What I have: I have a table with 1658 records. Basically it is a list of
every instructor of the college that has taught in a period of 7 years. Each

I have a statement in a query like:
ALTER TABLE EXP ADD COLUMN first_name TEXT(75);
If I wanted to add 5 columns in one shot, how would I do this?  Trying
to save this for repeatitive execution when I remove and recreate the

this might be a simple one to many, but I am struck in this Query.
Problem:
I want to insert into a table some records which i need to fetch from
select statement.

i am doing homework, have to use design view to create query,ok did that then
had to select salery field >35000, ok that is working, but when I try putting
in BonusQuota field value between 40And 50 I get the mismatch data error.
according to the Access comparison operators table ...

I have a bunch of data in a table say:
id,myname,grouped
1,joe,123
2,joe,123

I have a DateWkd field in my Database query and would like to
calculate the hours worked for this year from the 1st July 2006 to the
30th June 2007 if I filter for 2007 in the date field, and like wise
if I filter for 2006, the year would be 1st July 2005 to 30th June

from the column of total
thanks.

I have two similar queries that updates 2 different fields of the same
tables.  How do I combine them into one statement?
I have a macro that runs a query to update a field in my Access table from a
linked table from another database:

My contact list contains fields including first name, last name, company
name.  When input data leaves all three blank, I would like to do an update
query making the first name Any and the last name Employee.  How do I do
this?  My attempts have failed producing a result set of ...

I want to pre-compute the sum of some values and store it on a table.
The query is:
UPDATE tblMachacas AS t1 SET Participacion = (SELECT Sum([Valor]) FROM
tblDefsTurno INNER JOIN tblTurnos ON tblDefsTurno.IdDefTurno =

First of all thank you for taking the time to read my question. I am
having a problem running a query on a simple table. Trying to run a
query on a table with a field called ENCOUNTERS and a field called
CODES. What I'm trying to ask get out of the query is this: Every time

I am novice access developer and have the following issue:
My access database is designed to help me track my business prospects. Each
time I contact a prospect I enter the date of contact made, a follow-up date
and a memo of what has been discussed etc.