I'm trying to create a database that will find the most often numbers drawn
over a period of time.
Something along this format.
Numbers Drawn Week One:    01 02 03 04 05 06

Probably this has been answered somewhere else, if so, please indicate me
where I can find the notes.
This is my issue:
I have a table with users who may work in up to 3 different buildings.

Hi- I just recently moved an expression that I had in only a Form to a
Query.  The Expression runs great and I renamed the Expression to
"Retiree Age:..."  On my Form- I go to change my Control Source to
"Retiree Age" and the age no longer comes up?  I don't know why it

How would I go about displaying a count of rows that make up my pass
criteria.  For instance I create a query list of all persons that have in 'y'
in the paid field.

I have asked this before but it's come back to haunt me.  I have a
calculated value column in a query that contains some #Error values.  This
generates an error when attempting to run a query which is a sum on that
column.

I have a beginning date/time field and an end date/time field in long form in
one table. For example 5/24/2007 11:35 AM and 5/24/2007 12: 40 PM. I created
a subtraction query expression to find the difference (i.e., 1:05:00 AM)
shown in short time form. I would like to subtract ...

i have a table with
id  seq  group
1  AA    1
2  AB    1

I want to order to results of just one SELECT statement within a larger UNION
query:
SELECT first_line FROM first_query
UNION ALL (SELECT second_group_of_lines FROM second_query ORDER BY

I have had several blue screen crashes.  Now when I try to see my e-mail,
Windows asks for my name and password, but refuses to accept it.  What can I
do to get my e-mail?
                                               Norman

I can run my query with NZ function from within Access however cannot run it
via OLEDB connection even though its using Jet DB engine.
Here is my query, I tried changing it to not use NZ but nothing seems to
work the same.

Is there any way to add a record into the middle of a database without having
to add it at the end and then sort.  I need to be able to manually add
records into the database, as though you would in excell, exactly where I
want it without having to use sort since not all of the ...

I'm having trouble refreshing a listbox.  The following is are messages that
I would like some follow-up on if anyone can help.  
Thanks.
Kcrad

I have two tables, one with check data, and one with invoice data.  I
would like to combine the records from each table using the
transaction number to join records and creating a query that displays
each record type as displayed below in the output table.  Help!

I have been given the dubious task of developing reports from a db that
someone else did.  Unfortunately, there is very little (if any) table
structure to the db.  In a query that I am doing I get duplicate values if
the person's name is repeated for a difference discipline, when ...

How can I write a criteria as follow:
<100, and between 101 to 199 and between 251 to 999 and between 1000 to 5000
Cheers,
John