Hi everyone, thanks for all the help you've given me so far.  I now have a
new problem I haven't been able to wrap my head around.
I have a table of updates with a record for each update for each computer.  
So rigth now I have five records for each computer in my Updates table.  ...

Ok, I am having major issues here..I think I might be working too
much..haha
Anyway..My problem is that my query wont filter my Column LastResult. I
need any record under that column that says "NONE" or "Voice Connect" to

I have a form that shows all fields for a single record.  On this form is a
textbox named "Find Record".  In this text box I want the user to type in a
candidate name to bring up that record, OR they can type in a ssn# to bring
up a record on the same form.

FYI:  I'm new to Access, but have some knowledge of SQL and VBA.  I'm using
Access 2000.
I have a form which allows users to supply one or more criteria to subset a
recordset.  The "Execute" button on the form kicks off VBA which builds and

I have a query that runs off the account number entered in a form field. I
need the results of this query to show up in the subform on this form. The
subform is an entry form for entering account comments. The subform adds the
date to the record and allows the user to put in ...

I am thinking if I can set up a default in Access to automatically generate
a query into excel each day.  For example my query is set up to be group by
todays date: date()
But at the end of the day I want it to automatically export into excel files

I'm using DISTINCT to retreive unique records from a table with call data
(caller, date, support technician, stated problem).  Each week the data will
be imported to Access and we're going to randomly pick callers to survey
about our service.

Greetings again all,
   I think I figured out where I need to go with the Date thing.  In my
table tblPilot the Pilots Birthday is listed.  His/Her Age is irrelevant,
but we track their hours flown in two six month increments.  The increments

The following SQL statement works to extract the records I need and uses a
Max statement to extract the maximum value from the Amndt No field:
SELECT tblFAR25AmndtZero.Tencount, Max(tblFAR25AmndtList.[Amndt No]) AS
[MaxOfAmndt No], tblFAR25AmndtList.strFAR25para, tblFAR25AmndtZero ...

I have an append query that adds a date field then appends it to a table.  It
works fine for every month except Jan.  In Feb., when I ran the query, it
added Jan/2005 instead of Jan/2004.  Do you know what I'm doing wrong?  Thanks
Date: Format(DateSerial(Year(Date()) ...

I have an expression in a queryas followsStaleflag:
IIf([DealMaster]![TransStatus]=1 Or
[DealMaster]![TransStatus]=2,IIf(Now()-[DealMaster]![DateLastUpdated]>16,"Stale","Current"),"Current")
This works fine returning either a status of "Stale or "Current".  In the

I have a table of information that I extracted out of our company database
and need to retrieve the latest date for a Purchase Order.
My table consist of CMI#, PO#, Effective Date & Price.
Sample data:

Access 2000
Is there a way for me to set a query and base a report on it which will
allow the following:
Prompt for

I need a query to convert the julian date of 726488 to a real date 1/21/1990
i don't seem to get the right answer I believe I need to use the gregorian
calendar to do so but I can't figure out the formula.

I will appreciate somebody can help on the following
I have two tabled called Visit and VisitDetail - Master and Child
VisitDetail Table Fileds - CustomerID,VisitID,VisitDate, Item, Price
I wanted to get the latest  VisitDate for partiuclar customer and I wanted