I am trying to show the previous quarters information using the Dateserial
function.
Currently I have a report that shows the Current quarter and I use:
Between DateSerial(Year(Date()),Int((Month(Date())-1)/3)*3+1,1)-1 And

Good Day All,
    I have a qryupdateinventory that I update on close of my invoice form.
I have a field within my tblinventory called "LastUpdateOn". What I would
like to do is when the qryupdateinventory is run on close of the frminvoice,

I need guidance on what to do with this problem.
I have a turnaround time dbase with which I need to calculate total time
between steps, and then total time for all steps in the process.  
My steps:  

Hi.  I have a yes/no field for Coordinator.  Each program has one
coordinator.  I'm trying to figure out a query to find programs that have no
coordinator, but because I used yes/no, I can't seem to get what I want.  If
I use "no" in the query, I get EVERYONE who isn't a ...

I need to add more criteria to a query that I am currently using... I've
figure out the logic, but can't create a single SQL statement that does what
I need.
The current SQL statement is:

I have a query that has over 200,000 records and I need to export all the
records to a text file.  Problem is I can only export 65,000 records at a
time.  How do I tell the query to run the first 65,000 records , then get it
to run the next 65,000, etc.?  Thanks in advance.

Is there a way to format the below field data so it will sort in numerical
order? i.e. PO 1, PO 2, PO3, etc.
PO 1
PO 12

I need a query to show records in table1 that are not in table2.
e.g.
     table1.person_pk  not found in table2.person_pk

Have problem trying to INSERT to Access 2003 database. Don't think it's
permissions as can add records to this tables using FrontPage forms but want
to be able to add own code.
Can select and update on Customer table but not insert, e.g. this works:

I am trying to figure out if I can make the default view for numbers to be
1,234,567.89 rather than 1234567.89

I currently have 5 tables which have been turned into 5 queries.
Each query records details for work to be carried out at different Areas
(ie. Central, East, West, All & Schools)
I generally merge the records from Access into Excel in 5 seperate

I have a form where NextDueDate is calculated from, =dateadd(“m”,3,
[CompletedDate]), CompletedDate but I want to delete past entries of
NextDueDate  whenever a new NextDueDate is calculated I know this has to be a
simple fix.

Access query fails saying out of temp space
running a query that will create an Excel spreadsheet of 17,000 lines or so.
However, after about 20 minutes, it fails saying that there is not enough
space on the temp disk.with over 20 gig of free space and 2 gig of physical

I am creating a database for a very large delivery of furniture which all
has to be taken to different rooms of a building.  Not every room has every
piece of furniture but there are over 50 types of furniture.  I am trying to
create a list for each room of the pieces of ...

I have this difficult query to write. I know it will end up as a crosstab
query but its way too complex for the wizard. 5 tables are involved:
tblPackages, tblPackageTypes, tblPackageDateTypes, tblPackageTypeDates,
tblPackageDates.