strSQL = "INSERT INTO tblLog (Username,logDate) VALUES ('" & txtUserName &
"', #" & txtLogDate & "#);"
I used the above code to update my tblLog. my problem is if the date is a
single digit, it inserts the date in reverse order. E.g. 03-Sep-2005, this

I am using Office97
I have a table in Access with an integer field with values ranging from zero
upwards.
What expression do I use in a query so that the output for this field is

I have a query that seperates the fields by "square boxes".  I am pretty sure
that these are from an unknown character, but how can I find out what it is?  
Here is an example of what I want:
Michael S Parrill

I've developed an Access DB using Office 2003 (in 2000 file format), WinXP.  
I then copied this DB to a Win98 computer using Office 2000.  Only 1/2 of my
queries show up.  Yet, when I tried to recreate one (with the same name) in
the DB on the Office 2000 computer, it says an ...

I searched for the answer but not sure if this is a count IIF or Count or
DCount
My field is [Service] and contains a drop-down list with Meeting1, Meeting2
and Meeting3. How do I count each and get totals for each - like 5 Meeting1

Hello all, please can you help.
I have a number of learners on a programme that start at different times of
the year. I want to be able to count the number of 1st's of each month that
they are in learning.

I have a list of 160,000 records with these fields:
fname, lname, address, city, state, zip, dob
I need to generate a list with all fields where the first initial of lname
and the dob are equal.  

I have a table tblStaffInfo.  I also have a table tblStudentInfo.  In the
latter table I have fields for PrimaryHouseParentID, AcademicAdvisorID, and
TherapistID.  I would like to relate all three of those fields to the
StaffInfo table and create a query that would pull LastName, ...

Please help me find a better way to query. I have a field that contains
physician full name in various format. For example, it can be written as Soko
M.D. Mary J or Soko MD,Mary or Soko,Mary, etc. I can retrieve data by putting
in LIKE SOKO*MARY* in query design. Now, I don't want ...

I’m trying to build a query that will compare SSN from table-1 to table-2. If
table-2 does not have the SSN’s that are on table-1, then they are NEW SSN’s
records to be added to table2.
1.  How do I write a query to check for these NEW SSN’s?

I have a query that is supossed to gather a count of items in each status for
a date range.  When I run my query it is giving me a count per day of some
but not all status.  How can I have it give me a count for the full date
range?

My table has:
"item" "date" "price" "category" "customer" "market"  "product line"
"comments"
I want a query that show only the last date of each item.

I have a database of all registered voters in my town.   Each voter is
represented in the database as a single record.  The database is design
in the following way:
Fields            Description

I have 6 queries that comes that I need to combine to generate a single
report.  Is there any way I could accomplish using a macro and SQL? Or, would
it be better to append the data into a table?
Thanks.

I have a query that is based on 5 tables. Each table has data about skills
employees have performed. However each table does not have information on
all of the employees. My problem is that the query only returns records for
employees that have data in all the tables. Anyone have ...