I'm relatively new at access so I'm hoping someone might be able to give me
an efficient way to perform the following;
I'm trying to retrieve historical records as of a specific date from a
table.  For example, I need to retrieve the status of a group of employees as

I wonder if anybody may be able to help me out with a problem I am having. I
am using Access 2003. I was given a massively huge table (over 1,000,000
entries) and asked to figure out a way we may be able to find duplicates. We
get data from several different sources, and often ...

id like to ask if there are any tips on how to speed up query calculations...?
??  
what are some of the practices shud i follow??
i actually have this query

I have two tables i.e Bills, Payments. I issue bills to clients based on
table bills. When I receive payments from clients, I enter data using
Payments table. What I want is to create a third table say ledger based on
two table. I want this table updated whenever I issue bill. And ...

I have a table that I need to divide into several smaller tables based
on the region that each record belongs to (the region information for
each record is in the table). I'd like to create a table for each
region. Ultimately each table will be exported into excel for use by

I have a field that contains either 5 or 6 digits. I need an expression for a
query that looks at the number of digits in the field. If it has 5 or 6
digits it is fine and should leave the same number, but if it has 4 digits I
would like a 0 to be placed in front of the 4 digits.

My apologies if this is a duplicate - I don't think the previous one I
wrote was mailed.
Here's the issue:
I'm trying to create a query that displays all of the properties in

In the database I am working on, I would like to be able to create a
report with a list of all the properties in the database, accompianed
by the date of when the property was inspected. Some properties have
never been inspected, and therefore do not have an inspection date -

I am trying to build a query in Access 2007 that will display all
records that fall within a certain week, based on a week ending date.
The week ending date needs to be a variable. Here is what I have so
far, but I'm trying to simplify it.

Is there a way to automatically add sequential numbers to a query where
there are multiple records for each primary key?
For example:
                  Table Fields

I am trying to run a query to create shipping labels.  What I am currently
doing is grouping on the order_ID and creating one shipping label per order.  
However, I would like to have another shipping label print out upon every
break at 25 of item_qty, so if I had 30 items, I ...

New to Access, I want to post the result of a querey onto a control on a form
A is it possible?
2 How is it done?
thanks

I've tried to search out this answer in previous posts, but couldn't seem to
find anything that fit.  My apologies if I missed something out there...
I have a table of evaluation results; there is an auto-number pkey for each
evaluation and a slew of fields to represent each ...

I want to take the following module, and have the info added to a
table when the user opens the database, and removes the user from the
table when it's closed. I have to maintain this database and need to
be able to see who's in it at the time. It's practically used 23 hours

In my query I keep receiving a compiling error.  The error message says
"Compile Error in Query Expression..." and then the query expression is
given, as follows:
BldgName: IIf(IsNull([ParkName]),[AddressNum] & " " &