Has anyone had this problem?... I try to edit an existing query and make the
window the size I want... when I save and reopen it, it shrinks to a smaller
window.
Thanks,

Does anyone know how to do this?  I want to create a query that not only
shows me what is being done but what also shows times I'm free.  the result
should look something like this:
December 24, 2005

I have a table that is a list of results (1st to 10th) for various
events.
Each line in the table has an event code, so that they get grouped
correctly on a report (page per event)

have a query taking info from the Disk table:
Software ID
Disk ID
Disk #

Is there a way (in Access 2002) to select, say, 500 rows at random from
a dataset of several thousand using an SQL query?
I'm thinking along the lines of "order by random()" and "limit 500",
which might be one approach as expressed in MySQL for example.  I'm not

There is something wrong with following line in my SQL statement:
& " AND DATA.DATUM>=DateAdd('yyyy',-1,#" & [Forms]![weergave
patiënt]![erkdat] & "#) " _
[Forms]![weergave patiënt]![erkdat] is a date field

Hello need help with a query to get total count of all EFT and SRD and amount
for each, with the residual amount always being SRD.
DOS    CP    (EFT/SRD)    SEP         (EFT/SRD)    RESIDUAL AMOUT PAID
18-Nov-05    $100.00    EFT            $5.00

I have 2 tables that have entries for items labeld A through Z, and
where table 1's fields are a subset of the fields in Table1. I could
really use some help doing the following:
For every record that exists in table 1 and table 2, I need to copy the

I am using Access 2003 and Word 2003
I am successfully using mail merge with an access query as my data
source but I'm not sure how to include related records from other
tables and insert them in separate lines of the word document.

Hello there! I am using Access XP and have a question about using criteria to
retrieve records. In the query, there are roughly 50 fields associated with a
table. Right now I am trying to create a query that will retrieve records
based upon 2 fields called AcctNumber and AcctType ...

can i get compaq a 1000 all in one from windows 98, to work with windows xp
                                                thank you

I have a DB storing various statistics for employees (e.g., hours worked,
calls taken, average handle time), and I have a form designed to allow a user
to select which stats s/he would like to display. How would I code it so that
if the user only wanted to see, for example, hours ...

I have a database that contains a bunch of Queries.  Periodically, I will
notice that when I open a query in design view, make some changes and close
it, Access does not prompt me if I want to save the changes, it just does it
for me.  Kind of a hassle, cause I lose my original ...

Is there any way to stop the confirmation message that asks if you really
want to delete the existing table when re-running a make table query? When I
have 30 queries in a macro and you have to make 30 confirmations to delete
the tables before they are re-generated, somewhat ...

How to make/query for  field date/time with interval 5 second, such:
1/1/1990 00:00
1/1/1990 00:05
1/1/1990 00:10