I have a table with dates of birth, I wish to have a report tell me how old
the person will be by years on a specific day.  Example:  DOB = 2/5/1995 on
2/1/2005 the person will be  9.   I have only come close by using DateDiff
and deviding the answer by 365.25.  That is the ...

I have a query which displays all staff whos training will expire within a
period I enter into the criteria field.  It works fine, however I want this
query to become a parameter query so that i can specify any period I would
like to see.

Updating a Master price list from a Data.  Made tables for both and made the
query below, but it updates my Data table from my Master  Help  What I'm I
missing?
UPDATE Data, Master SET Data.Jobber = [Master].[Jobber]

My query starts out like this:
SELECT Dlookup(Table) AS SITE, ...
My TOP value is also stored in the same table as the SITE Dlookup.  How do I
use the TOP protocol in the query?

hi,
i have been working on this query forever.  looks like u cant use dlookup
functions within a query.  is that right?  i have:
SELECT Tbl_archive.[Loan Acct #], Tbl_archive.PopEnterDt,

I have a bunch of queries, most of which need to be assigned to a
Fiscal Month/year. I have a separate table with all the dates as
individual records with the relevant Fiscal month attached.
unfortunately, when i join the tables together by DATE and try to query

I have a query as a data source into a Datasheet Form.
I am trying to have a field in one source of my query, that source being a
query, become the column heading or field label of a field in my other source
of the query, which is a table.

I have a CSV file that has 1,286,881 records on it.  I need to put them in
an
Excel file.  Excel will only take 65553 records.  So, I imported the CSV into
Access just fine, but how do I run a  query that will transfer a 65,000

Using a MS Access query, I would like to write a formula that will give
me only the first 3 items in a field separated by semi-colons.  For
example, of the data in the field including:
horses;cats;dogs;parrots;mice;elephants,

Alrighty then.  I have a table that has a mass of individual mailing
addresses, and I want them to be grouped by household.
For Instance:
Transform This:

i wanted to use the data from a control field (eg. textbox) in a query to
generate a select statement, not using a prompt.. could someone help me?.. i
need this asap..

The company I work for has a customer table and in the customer name filed
they have the customer name along with the store number.  Example: "central
pipe #123" or "central pipe #12345".  I would like to grab just the store
number so I need to know how to search the string for ...

I'm connecting to an Access Database with Excel using ADODB and would like to
sum up the
total values for a Date/Time field called Duration.  
The SQL I'm using to get this is:  "SELECT SUM(Duration) FROM 3_REPORT;"

Table1 stores issues and a Rec_Date and Clo_Date.
Table2 has stores fiscal weeks and the dates Satruday-Friday associated with
the fiscal week for the entire year (example below):
FW        |  Sat          |         Sun  |         Mon  |        Tues  |    

I have several tables that my query is pulling from.  Each night, the data in
these tables will be updated.  These tables only contain 7 days at a time.  I
have a query (EARLY_OUT_FINAL) set up that will append the data I need into
another table for permanent storage and use.  I ...