Access 2000.  I need to keep track of point totals for sick time for
employees for the last 12 weeks.  I have my totals query totaling up
correctly.  The glitch is, each employees time starts on the first date they
call in.  Is this criteria below going to return the last 12 ...

having followed the advice from 'Microsoft help' I can successfully run a
query when the database is opened. The query updates a table.
In the design view of the macro I have chosen 'OpenQuery'  as the 'Action'.
In 'Action Arguments at the bottom, there has to be an entry in the ...

NooB posting, so forgive me if I don't get everything correct.
I am trying to run a query that calls the TOP 25 in access 2003.
The query calls two fields, SumOfTotal and strDescription.
SELECT TOP 25 Query2.SumOfTotal, Query2.strDescription

I have a database with a "Company" table.  A combo box on a "company" form
lists the company names.  A lookup query filters the table according to the
selection in the combo box.  I want to have an option in the combo box that
will list all the companies in the table rather than ...

The following is the first subquery I’ve ever used.  It’s coming very close
to what I want, except if there is a tie in the TimeResult field.  What I'd
like is to assign a unique number (Rank) to each record in the group based on
TimeResult (ascending).  If there is a tie in ...

A project that I am doing requires collecting large amounts of contact data
and working with the phone numbers.  My job would be a lot easier if the
formatting on the phone numbers were deleted.  For example, the left and
right parentheses, Slashes, dashes and spaces cause some ...

I have a single table that my query is built from:
clients_tbl
   id
   clientname

In Access, I have a query that will update a 'linked' excel spreadsheet. The
query used to work perfectly fine, but now I only get an error message Error
3113. Per my IT department, they are suggesting that the message seems to be
attributed to something that changed in Service ...

Hi,  I have a table or names for a mailshot, with a sequentially ordered
Autonumber field (LeisureID). If I put that in my query with the name fields,
what do I need to enter into the LeisureID filed to return every 7th record?I
know this is possible but, don't know how and I'm ...

How would one make a calculated field in a query display a blank when the
result = 0?

I have created a menu for my db. On this menu there is a button where users
click on to search the db by county. Then they have to enter the county, but
instead I would like to know how to create a drop down list for the user (so
they can just select the county).

I have a table that look like this:
ID     Opcode    Date
123   Align        01/jan/06
       Oil

I would like to create a query that would detect the most recent month and
would list those records as well as records with dates from the previous 2
months.  All dates are end-of-month values.    01/31/07, 12/31/06, 11/30/06,
10/31/06 etc.

SID is the field of underline query of a form (have many duplicates). I want
to count number of uniq SID and assign the result to TotalStudent control on
the form. Please help. Thanks
- Song

I have a history table that has ID, Stage, and Date. I'm trying to figure out
how to calculate the date diff from records that are between one stage and
another. For example,
ECO#    STAGE    DATE