I have 4 tables in my database. I perform a series of joins to end up with a
table which is my finished product. For example i join 2 tables together to
make another table. Then join this table to another table and so forth. Is
there anyway that I cane perform all my joins in one ...

i got this error message while opening a querie,i am the one that built the
querie,what's wrong?
"Could not read definitions; no read definitions permission for table or
query <name>. (Error 3110)"

I have a datawarehouse application that updates "linked tables" into
MS-Access, so users can make SQL queries using MS-Access as a Proxy.
In deploying some Cognos applications, I would like to take a selection
of MS-Access queries and export the SQL statements into a file.

I know this can be done by tabbing into a field or double-clicking (carefully)
, but my users are going to be frequently selecting text to copy/paste - it
would be nice if the could click a button to select all the text in the field
- I know send keys doesn't work real well, but it ...

I have been on this site and have read and reread and tired all the queries I
have seen to calculate the age.....None are working and I just need some
help.  I knwo this question has been asked and I am sorry I am replicating,
but someone please help me.  

I am having a problem sorting records in a query.  I have about 5, 00
entries in a table and when I build my query based on certain fields
the numbers in certain columns are not in order although I use th
sorting feature. ( e.g.) I have 5 columns with numbering data containe

I'm using a query that has a field date()+2 to give me a flag date 2 days
ahead of today. This is fine for a Monday, Tuesday or Wednesday where the
flag date is therefore Wednesday, Thursday or Friday. However, I need the
flag date when run on a Thursday to return the date of the ...

I must be missing something, because I'm trying to get Access 2000 to compare
to sets of records and tell me if any rows from one set do not appear in
another.
Let me expand, I've written a fairly simple (I'm not  a programmer) database

Currently I am using a  report to show details of Orders that have been paid
for in any specific period, the SQL is as follows
SELECT tblOrders.CustomerID, tblCustomers.Company_Name, tblOrders.OrderID,
tblOrders.Order_Date, tblOrders.Date_Paid, tblOrders.Invoice_Paid,

I would like to (have been trying to) design a parameter query to build
a report.
The report will show ProductID, ProductName, UnitsInStock,
SumQuantityOnOrder along with a text box holding an IIf statement. This

How can I write a query that will return a list of random records from a
table?
The table has an autonumber value and I want it get a random set of
auto-generated numbers with each query.

I have a mental block!
I have a table with 2 fields.
A location field (text 4)
A date/time stamp field (Date/Time)

Am trying to execute a delete query but it prompts to enter a parameter, the
where clause. SQL is as follows:
DELETE tblTBBeg.AccountTitle, *
FROM tblTBBeg

I have a delete query that i want to have run from a button on my mai
switchboard.
When in the design mode for my switchboard i choose the command butto
from the toolbox and select Run Query it shows all my queries except m

I'm using the following parameter query with a form, it works for the first
few times and then doesn't bring back any records at all. To get it working
again I need to rewrite the whole query! Whats happening?? Please help!
SELECT Details.[Customer Name], Details.[Address 1], ...