I hope I can say this half way intelligently.  I have a record set with 2
date fields (One in date and One out date)  I have a query to select the
records between a specific date range (no problem) now problem: I need to
also select the earliest date in at the same time.  So thus ...

I am working on an old database where the area code was not a part of the
phone number. Of course, now there is a new record that has an entirely
different area code.
Is there a query I can use to add the area code to the 700+ records already

I have a database that has several tables in it. Each table contains each
years information. I want to be able to search all the tables for one certain
record. This record is a unquie number, but is not in numeric order. I want
to be able to put in the number, and have it search ...

I have a table of product registrations. All entries have a product
number. Some entries have a single serial number, and some have a
range of serial numbers. I would like to remove all records containing
a range and replace them with multiple records, one per number in the

Hello.  I need to prompt users to enter data into the address field of a form
before moving on to the rest of the form.  I believe that a parameter query,
with its associated dialogue box, is the cleanest method to create the prompt.
While the MS Access 2003 help profile indicates ...

They scare me! I do have a copy of the db.
Here's what I'm trying to say:
Find Contacts who are Board Members and make them Gala Members as well.
Here's my query to find Board Members:

Here is my calcuation
Vac:
Sum(nz([XXSUBqrySubstituteLeaveStatusVac!decVacHours],0+NZ([XXSUBqrySubstituteLeaveStatusVacADJ!decVacHours],0)))
And the SQL View

I am using Access to write reports for our SQL database using ODBC
connections. Currently I am working on a complex query to summarize
conference registration data that is stored in a single table, in individual
rows identified by the Person ID and Item ID.

Ok, I have a slight brain twister here and wondering if anyone could help
shed some light on this. :)
Im in the midst of creating a database that will hopefully replace a
paper-based system of storing 'shift runsheets' from a 24/7 office. There is

I am fairly new to access and am currently working on a project that
pulls live data from excel every minute or so and stores it into an
access table.  There is data for about 26 columns (call them A-Z) and
each minute a new line is added to the access table containing the

I have salary data that I need to age by a specific percentage.  I know I can
do this in Excel with the following formula.
=(A1^B1)+C1
(where A1 is the percent to age by, and B1 is the value representing the

In a query, how can I include zeros in a query? For example, I am
returning records for a the number of complaints I have for a given
department. I want to be able to include zeros in my query.
Plant Code      Source Department     Complaints

I have a table of Shipment Detail. containing: doc no. , item no. , qty.
I need to make a query :

carton count is 1 to [qty]

I need help to write a Query to do the following... I am stumped.
I have a Table called tblStatuses where I want to only pull 1 record per
Proposal Number that has a Status of "New" and is the latest entry meaning
has the latest StatusDate & StatusTime

I have a query problem.  I have a field that does a calculation in the form
that I have.  When I open the form it calculates the numbers of days to
maturity based on today date.  I use the following "formula" in the form
field: =[LeaseMaturityDate]-Now() . The form field is a ...