I'm trying to create 2 sets of invoices for a client.
We have return customers and custome/one-time customers.
The one-time customer information and the return customer information are
stored on different tables.

Everytime I try to access the table, query, or form I created a window pops
up asking me to Enter Parameter Values. What does this mean? And, what values
am I suppose to enter?

I am trying to build a query that calculates Price/EPS.
I'm creating a P/E field where the "E" is built from a complex check if all
4 quarters are available (these are the qecq1,qecq2,qecq3,qecq4).
If all 4 are not available, I have another less desirable field that I could

Hello..  I'm in need of assistance in writing a query.  My table has four
columns, id, name, default  and all connects.  How can I extract all the ids
that are connected to the same group of connects?  Need to find similar users
that share the same connects.

I have a table called Activities.  This table is filled in by the user to
identify activities of a busienss.  Its only two fields are Cycle and
Activity, both of which are set as primary keys.  I did this so I could have
duplicates of cycle or of activity, but not a duplicate of ...

I have tried the following and it does not work:
<=DateAdd("m",-6,[MONTHLY IMPORTS].[DATEENT])
I am trying to exclude any records that are older than 6 months prior to the
date of entry (DATEENT).  

I’m looking for a way to find and list all similar records across two tables.
(Both tables contain addresses that must remain separate and there is no
common field to link between them.)  After some research, I’ve discovered
this is much more difficult than I originally thought.  I ...

I have a large table from which I regularly need to extract data.  However,
if I try to extract the records by running a join query using a small table
containing my criteria - my PC hangs up.  CTRL/ALT/DEL says Access is not
responding.  However - if I hand type the data I want ...

I have a query based on 2 tables "Diagnosis Table new" and "Dx Classification"
There are several fields in teh queries, but the important fields are
"ICD_Code", "Site", and "TypeOfInjury"
There are several values that are the same for "ICD_Code" which have

I am trying to add a drop down list in a table so the employees will use only
a few options and I am really clueless can someone help me please?

Can you please help -I'm running an append query  with a problem.  Here's
the SQL in the query:  
INSERT INTO Transactions ( ItemNo, DateConsumed, LogOutBy, ItemDescription,
LogQty )

I have an append query that will add a new record and insert an itemno - I am
having trouble with the criteria.  I run it from a form that is filtered like
this:
[Requisition]![Department]=[Forms]![SelectOut]![Combo8]

I have set up an Access Database. I would like to be able to set up a query
which finds results where a particular field is empty. I tried to use
Expression Builder, but cannot seem to get it working. Can anyone give me the
correct expression for this?

I have an Ordersfrm with a subform based on a 2 table query which works fine.
Now I'm trying to add to the subform the ability to select a product serial #
if there is one for that specific product. Most products don't have one but
it's crucial the parts that do for service and ...

You help is appreciated.
I am logging out parts from inventory on a form.  Then I want to run an
update query that deducts the qty logged out from the qty on hand.  My
problem is figuring out when to run the query.  I am getting inconsistent