I have an approx. 385MB, 2.1 million record database and want to append to it
a 61MB, 373K table and receiving error "There isn't enough disk space or
memory error".
Pentium 4, 2.99 GHZ, 1 GIG of RAM

  I would like some insight on how to create a Select Query that will
run through an Access DB and give me totals for 15 particular products
for a specified date range.
Ex.

I am having trouble declaring date value in pass through sql query.
Below is what i have currently -
Declare @BegDate as datetime
Declare @EndDate as datetime

All strings are text only.

I want to create a query that prompts the user to select a type of work from
a drop down list and then runs the query.  So,
 --Prompt the user "Select a Type" from the following list:
            ---HVAC

I'm trying to produce a query that will show all quote numbers that have no
line items that were ordered. Structure is this:
Tables: Quotes & QuoteDetails, one-to-many
Field: [Ordered] Yes/No in QuoteDetails

I put this questionbefore, but I don't think I worded it very well.
I have a database which I've designed to track Employee Training.
. I have a number of  main tables each linked with junction tables.
One has employee information

Here is my problem.
I used #15-12-2003# as criteria for date field for a query. The query
retrive only 2 records, but actually table contans 25 records of same date.
Date Format given for the field as dd-mm-yyyy. My regional settings is also

If I run the following query on this table, where [JobNo] (Text),
[FeeAmount] (Currency), [Posted] (True/False):
JobNo, FeeAmount, Posted
22, £0.00 , No

i have a question.
i have 3 combo boxes.
the 2nd`s content is decideed by the first`s selection. i use a query for
that.

I am developing a database where I need to find data in a table that occurs
in every sample that is analyzed.  For example, Bug1 is in every sample
analyzed but in low numbers, while Bug2 is in some of the samples but in
great numbers when it is there.  I want to be able to pull ...

I'm trying to delete from a select query.  The query includes two tables, a
parent and child table.  The query looks like the following:
SELECT PMOC.PMOCID, PSSR.PMOCID
FROM PMOC LEFT JOIN PSSR ON PMOC.PMOCID = PSSR.PMOCID;

I have a query where one of the fields is a check box, [Select]. The criteria
comes from a subform in datasheet view
[Forms]![frmSystem]![frmSystemSub]![Select]
I the created another field in the query

I want to create a form that searches from a Table which contains many
Fields with Null Values
I've created a form and the 7 Fields want to search from are Unbound to
a control Source

Please help me for the following
SELECT Applicant.[Applicant ID], Applicant.Session, Letters.Letter,
Letters.[Letter No], Letters.[Letter Dt], *
FROM Applicant INNER JOIN Letters ON Applicant.[Applicant ID] =