I have an audit table set up from which I want to extract the latest version
of a record. Records are marked as Insert, Delete, EditFrom and EditTo. The
setup is a master form with a subform on which these records are entered.
Each record on the subform has a unique ID, but in ...

I'm trying to combine the string of two previously separate queries.
1) called qMembershipSelect
Was as simple as this: (and it is always rebuilt with different parameters)
Select * FROM Membership Where [MemName] like 'Jones*'

Using Access 2000 sorting in a query to eliminate blank text fields.
Criteria "Is Not Null" does not eliminate blank fields. Why?

I'm having trouble with creating an Update Query.
I'm trying to find where De is in the query and then change it to de.
The values in the field are like this
Santos De Lama

HOW DO I SET PARAMETERS FOR A BIRTHDAY QUERY.  I NEED IT TO PULL OUT
ALL STAFF THAT HAVE A BIRTHDAY IN JANUARY, FOR EXAMPLE.  SOMETIMES I
HAVE TO HAVE A TWO MONTH REPORT.  CAN A PARAMETER WORK FOR THIS TYPE OF
INFORMATION.  THE FIELD IS THE STAFF'S DATE OF BIRTH

Can I use multiple fields for the Not In Subquery. For example:
WHERE FIELD1, FIELD2, FIELD3 NOT IN (SELECT FIELD4, FIELD5, FIELD6 FROM
TABLEA).
What I want is the combination of Field1, Field2, Field3 to not be in the

I have a query that I want to execute and then reference in VBA.  I have the
following code:
docmd.openquery "qryPAYMENTtotals",acNORMAL,acREADONLY)
pmttotals=query!PAYMENTtotals!paymenttotals

I am using a Append Query to add data to a table. I want the Field in the
query to add the current date and a time value of 08:00:00 AM. Basically the
query is going to be used on Holiday's to automatically punch in an employee.
I can add a date but cant seem to get it to write ...

This is my second attempt to resolve this issue.
I have a DB that runs several differnt queries.  I want to create a macro
that allows me to select the query that I want to output (as a .XLS file).
What I'td really like is to be able to Browse the different queries that I

How can I convert a Date Field in to a String as follows:
"YYYYMMDD"

I've posted this in two groups since i don't know if my problem should be
solved by code or can be done by a query.
Situation:
I have this publicity-thingie running, where people can gain points when

In my query none of the functions related to current date is working. Can
someone help me fix it. thanks.
purnima

I have an existing database but the entries are old. Can i clear the contents
and start again?

I need to create a calculated field in a query that looks at the 'Complete
Date' and returns the quarter the deal completed.  Example, if the complete
date is 2/15/05, then it completed in Q1 and the query should return 1 in
that record.  Similarly if the date is 6/3/05, then 2 ...

HOW DO YOU SORT A DATE SO THAT THE [DOB] SORTS IN BIRTHDAY ORDER FOR
THE YEAR.  ANOTHER WORDS, I WANT ALL BIRTHDAYS FOR EACH MONTH TO BE IN
PROPER ORDER BY DATE, DONT CARE  ABOUT AGE.  THE FIELD IS A PERSONS
DATE OF BIRTH