Is there a way to dictate how large a window will be when a query is
run?  I have tried resizing and closing the query but to no avail.  I
get these huge windows that go clear off the screen for a query result
of 1 row and 5 fields with 10 characters each.

I have a smalldatetime field startDate, endDate.
update myTab set endDate = Datedd(mi, 12.56*60, startDate)
    WHERE (any condition)
this works fine and returns value 12.55 when a 'select' statement with

Is there an alternative way to the Not In subquery.  Naturally, I need it to
produce the same results:
So currently,
WHERE FIELD1 NOT IN (SELECT FIELD9 FROM TABLEA)

I want to transform data such as;
Col a  Col b Col c
1         13     45
1         17     670  

Merry christmas everyone,
To make things just a little bit more merrier for me i would really
appreciate some help with this one!
I have a Union query as shown below, this paragraph pulls up cheque payment

When comparing a calculated field to an imported field, I get false deltas.
Premium x Commission Rate = Commission Amount.  I then compare the
Commission Amount to an imported numeric value (the "expected" result).
The problem arises when Commission Rate is three decimals (0.055). ...

I've been using Date() to filter for various records (Completed After
Deadline Date, Before Deadline Date etc.). However, I cannot get it to filter
for records with "Deadline" = current date.
In the query criteria field for "Deadline" I put:

I have a database that records Date, Surname, FirstName, Number of Minutes
If a person is entered twice for example:
Date              Surname                    FirstName            Minutes
19/12/2005    Other                         Andrew               150

I have two tables that I want to merge. But I want a fixed number of entries
in the final result, let's say 100. I want to pull all of the entries from
the first table -- let's say there are 10. I want to pull the remaining items
randomly from the second table; in this case I ...

I have a table that contains Order information and another table that
contains Inventory information. I created one query that has 2 tables joined
showing order records from the orders table (outerjoin) and matching
inventory items to the order (showing available quantities). I ...

Designed a simple Access 2000 update query to append records from one table
to another table. Keep getting a message that the append failed because of
validation rule violations. Have matched the table definitions precisely and
see no validation conflicts, but still no appending ...

Hi;
In a medical system we store all prescriptions in 2 related tables.The
parent Tbl has Fields like:PID (or PrescriptionID that is a unique Long
Number assigned to each new Prescription,and is the table's PK and the ONE

I have recently imported tables from FoxPro into Access 2003 and am
trying to figure out how to view the pictures.  Each of the images is
listed as OLE Object. What do I need to do to display them in my
document?

Is there a limit to the number of left joins a query can have?
I'm using Access 2002 , and trying to created the equivalent of a SQL Server
View from a main table which has 26 related lookup tables.  I can design the
query in the QBE grid OK, but when I try to run it Access hangs.

I have 6 colums.  Event Date/RH/QV/GH/Aud/QVGH.
Each one is a room rental, with a yes/no answer. I want to know how many
times a month do each room be rented.  what would my formula be for this
query?