I have a database that uses 3 linked tables - one which give the addresses of
clients address, one that shows all the people at that address and one that
shows various mailing lists they belong to.  I am asking the query to show
all people that belong to two different lists but ...

I have a large database of students. The system should create a a new field
"Assigned" to assign the students numers to a certain maximum, say 12.
The first 12 on the list will asume 1, 2, ...., 12
The next 12 will assume 13, 14, ...., 24

I want to run a query to determine all items on the "First Floor". In the
table I am running the query on, "First Floor" appears in a column titled
"Area". when completing the table a pulldown list appears to choose the floor
(First Floor, Second Floor, etc.). These floor names ...

I have a simple append query where I CDate([DOB]) into an existing
table.  Coming in DOB is TEXT.  Values coming in are 10/10/1990 etc.
When I look at DOB coming in using IsDate it evaluates to -1 (True)
When I create a new table and use CDate([DOB]) it correctly creates a

Hi everyone, and thanks for all the good tips.  This is an awesome community
for Access developers.  My question:
Is it possible, within the "CREATE TABLE" SQL syntax in Access (Jet 3.5 or
4.0), to define a default value for a field?

Is there a way to disable the 'web' menu bar from appearing at all?
On the first time where the user clicks on a hyperlink, the menu is not
displayed
on the 'OnClick' event of the textbox, I've used:

I have an update query that uses criteria in the id field.  It is a long
variable set in one of the forms and is called DeleteID.  In the query I set
the criteria field to:
=DeleteID but it changes it to "DeleteID".  I run the query from the form

i have a query that selects records from the USER table, which returns, among
other fields, the password of the users. i'd like to mask the contents of the
password field with asterisk (*) for each character of the password in the
resulting query.

How do I use the value in a combo or list box limit a query or report query?  
I have tried two options with no success.  They are as follows:
Option 1: Set up a query with the criteria pointing to the combo or list box
value.  The criteria reads  =[Forms]![Form1]![Combo0]

I am a newbie trying to make a time saving change in a query that has been
setup for me. My Query lists attendance reasons which are one of 3:
Present
Excused Absence

I'm trying to copy and paste a five paragraph MS Word document into an update
query memo field.  I keep getting the error message, "The text is too long to
edit."  I can copy about 890 characters of the document into the query but no
more.  I'm clearly doing or not doing ...

I have a table contain of 3 field like this (All data is number)
ID   Ind     Adj
1      I1      A1
2      I2      A2

I would like to know how i can get a query/macro to enable me to count the
number of duplicate records in one table and put one copy of the duplicated
information into another table along with the total number of duplicated
records

Help!!  I've got a database table that has monthly sales, as well as utility
and rental payment information for 150 stores.  I want to create a query that
will show monthly sales for each store for a 12 month period based on a lease
start date field in the table.  Example:

Hi again,
I am starting a new thread because the query turned out to be wrong.
Now i am getting the "data mismatch" error on the following part:
-------------------------------------------------------------------