Sounds easy, but here it comes.
I have following tables:
tbl1
code    sub code    total

I am designing a Flight-Hour tracking program for pilots.  One of the queries
that I am trying to design involves calculating the sum of flight hours
during a six month period based on the user's birthmonth.  If the user's
birthmonth is November, I would like to be able to show ...

I am importing data from Excel into an Access 2003 table. I want to check for
duplicates and delete them if found. I've followed the procedure to do this
from the Microsoft Access Assistance paper on "Find, eliminate, or hide
duplicate records in Access". The totals query ...

I am trying to send out an auto email to the supervisors to remind them to
conduct feedbacks prior to thier suspense dates.  So if the suspense date is
30 Jan 05, I would like a reminder sent out on 7 Jan 05, and 15 Jan 05.  What
I am ending up with are dates that are in the ...

I am trying to have my query calculate a date from "Training" date add 12
months or 1 year to get my "Annual Training" date. Example one individual
received "training" on 5 Feb 05 I need the query to add one year and place it
in "Annual Training" to give me an answer of 5 Feb 06.

I need a column in my query to display a list of values returned from a
subquery.  No problem if the subquery only returns a single value, or if I
alter it to return an aggregate value like COUNT.  But I get the message "At
most one record can be returned by this subquery" when I ...

I need help with a query that will look for the first record and a last
record of a group.  I tried the DFirst and DLast.  Is this what I should use?
and if so can someone show me some examples.
the table has "TimeIn" and I need a First & Last For each individual

Is the following possible (where it will correctly execute)?  If so, how?
DoCmd.OpenQuery "qryPAYMENTTOTALS"
PaymentTotal = query!qryPAYMENTTOTALS!PaymentAmount
THanks,

I have a query that is ran by selecting the beginning date and ending date:

Say I enter start date: 12/27/2005 and end date: 12/31/2005 my query selects
all records between those date but also pulls up ...

I imported a FoxPro db file (don't know what version - came as a dbf & cdx)
using ODBC driver into Access 2003. The table contains a text field that
often contains more than 1 space within the text string. Queries on this data
returns nothing. If I edit a record to contain only ...

Good evening all,
This is my situation:
I have a db that keeps track of machine settings.  Occasionally, settings
change due to a variety of factors.  Usually only one or 2 small fields

I am trying to add the total music length in minutes for a soundtrack. My
table has fields for [hrs], [min], and [sec] for each record.
To obtain a sum of total length of time IN MINUTES for all records in a
subset, my formula in the query is:

I have a query where the users enter in a specific criteria and get one
result from the table. This query is linked to a mail merge letter.
In office 2000 it works.
However, I am using office XP and the mail merge does not allow me to use

Can anyone aid me please?
I want to retrieve (query) items that have a date that falls within the last
12 months ending the end of last month. For example... we are in Jan 06, I
want to retrieve between 1/1/05 and 12/31/05 -- only and inclusively.  My

I am trying to create a debtors aged analysis, where a customer can make
payments for multiple invoices (eg Cheque 001 for $66 pays for invoices of
$30, $29 and $11, implying a short payment on one of the invoices).
Can anybody assist?