I need to create a query that can search between to field’s Low range & high
range and determine the correct zip Range for a store. Can anyone help me?
[Address table]       [ZipRanges]    [ZipRanges]              [ZipRanges]
Zip code                   Low zip            High zip   ...

Please...help.....My query freezes when I try to execute the following query..
..
INSERT INTO workingnew ( meter_number, prod_date_time, meas_dth, meas_mcf,
BTU )

I have a table(7 fields) which contains around 100,000 records. Within these
100,000 records, I know there are many duplicated rows. I  have sample data
of around 10,000 records.
I have wrote a query to find out how many duplication I have:

This is the SQL for a query that cannot be updated:
SELECT tblPO.*, tblVendor.*, tblPhone.Phone, tblPhone.MainPhone
FROM (tblVendor INNER JOIN tblPO ON tblVendor.VendorID = tblPO.VendorID)
INNER JOIN tblPhone ON tblVendor.VendorID = tblPhone.VendorID

I am trying to extract data from a database through an access query.
One of the fields in my query has a time-stamp date (i.e. the date
entered in the database shows dd/mm/yyyy plus the exact time)
When I run the query to extract data that has only today's date using

My set up is as follows:
tble_week
weekID (PK)
RecWk

I have a database with seven columns named CDCnum, Name, Housing, To, Reason,
Time and Date.  I need help creating an update query to compare the data in
the CDCnum, Name and Housing columns and update any data that has changed.  
My update source is a TXT file called downinfo and ...

I am using an update query to clean up really messed up data I receive. I
receive large chunks of sloppy, unformatted, date, where years of dates are
not always correct, among other problems. In table TnewData I start all data
in text fields, along with a duplicate set of empty ...

I have the following query:
SELECT [Attendance].[Attended], [Attendanceform].[AttendeeFirstName],
[Attendanceform].[AttendeeLastName], [Attendance].[AttendanceDate],
[Attendanceform].[EventName], [Attendanceform].[Daynumber],

Hi,
i have a query with two fields, IND_ID and Contact_ID, looking like this:
IND_ID   Contact_ID
1                   5

I am using MS-Access 2003.
I updated my forms and tables, with new information.
I ran a query, to find out what user was missing a chair.
The database query gave me incorrect information.

Hi and thanks for taking the time to read this.
I have a query based on three linked tables. It returns two sets of
geographical data (amongst other stuff relating to competitor organisations)
one for London Boroughs and one for English Counties where organisations

I have a personal info table. it contains fields such as name,birthdate and
their hobbies. there are 4 hobby fields in the table and they are computer,
music,sport and movie. i use integer to represent those data where "1"
indicate YES ,that person like that hobby where as "0" = No  ...

My task is to take a set of date ranges, determine how many days are
included in each span, and total them up for each client. The trick is,
there may be multiple records that span the same dates, and each day can
only be counted once. Moreover, there may be lapses in the ranges.

I currently have a table in which each record is based on a particular
attendance event (students attend a language lab at my university).  In each
record, I have the date, student, professor, time in, and time out.  In the
query, I'd like to see each student's daily, weekly and ...