I have two tables where all records should match.  One table, however, has
more records than the other and I haven't been able to determine why.  
Unfortunately, the records are such that there is no primary key and there is
no one field that has unique data.  All fields combined ...

I have a table with 2 primary keys that are in TEXT format.  Date is Primary
Key 1 in this format (e.g. "2005.08.30") and Time is  Primary Key 2 in this
format (e.g. "00:00", "06:15", "21:00").
I want to build a query that says give me the past 15 records (or what ever

I am trying to narrow a search field down by topic.  I have over 200 rows of
information, that fall into 4 topics.  For sake of arguement we will say 50
rows each.  Of those 50 rows pertaining to topic, they are fall into 4 other
catagories.  How can I query the user to pick a ...

Can a field in one table get its value automatically by referrencing the
value of another field in its record against another table?
as best I could explain it, I'm sure thats about as clear as mud so let me
explain thru example.

I'm trying to create a database that will be used for creating unique
multiple choice tests based off of a list of questions and answers.
Pretty simple concept but I want to be able to generate random question sets
based on the question grouping, and then since this is a multiple ...

I have two tables - tbltaxes and tblvoters.  The tables are
structured the following way
Tbltaxes
Field        Description

I've been looking at similar questions posed on this discussion board, but I
can't quite figure how to do what I need. I have a Guarantors table with two
fields, Loan# and Guarantor. There are multiple entries for many loan numbers
in the table.

I have a table consisting of several fields, where one is a customerID. I
would like to repeat all records for one customerID in the table, but
changing the customer ID for the new records. How can I use the query command
to complete ths task?

I am required to find a daily average balance in an access database and am
lost.  The data that is entered is not on a daily basis

I have the following code on my report:
Private Sub Report_Open(Cancel As Integer)
   Dim PONum As String
   PONum = "1276" ' Sample number for testing

Hello Access Gurus,
I have a group of empty fields attached to purchase orders I need to update
with the same number.  Right now, I am having the update query change the
value to OrderID plus 5000 if the PO value is null.  Would I need to set the

In AccessXP, I'm looking for the proper way to set up a query that takes a
number of records (rent and CAM amounts for each of several properties) and
combines them into one record for each property.
Ie: combine these records:

Hi!  Thanks for your help.  I'm using Access XP.
I've created a query that needs to pull all client/matter numbers.  The
numbers appear like this:  444444-444, client number being the first 6
digits, matter being the last 3.  They are separated by a dash.  I need to

I have a form linked to an "invoice header".
It contains a subform linked to an "invoice line" table.
On the subform, I have a couple of calculated fields eg [$ amount].
I need this field to update the invoice line table once the user exits the

In a query, I want to display the value in a field if another permission
field is yes.
Ex: I want to display the email values in a list if the permission is yes.