For some reason I have a duplicate in my query that shouldn't be there.  One
employee has been promoted 2 times and only the most recent time should be
displayed.  I selected this by chosing Max PromoDate.  Thanks !
SELECT tblPersonalInfo.strFirstName, tblPersonalInfo.strLastName, ...

I have a field called CustomerName that has  values that are last name,
first name.  So there is a value of Smith, John which is John Smith.  I want
to preserve the value in this field but create a new field called
CustomerName1 that has John Smith in it.  It would need to ...

Access 2003.  I use the query grid to create my query but pasted the sql
below so if the answer can be directed so I can use the grid, that would
help.
I need my query to display a list of patients who were on a therapy 70 or 81

I am trying to run an append query that will append a record to a
table if a certain criteria is not met.
When my database opens, I want it to look to a table and see if there
is a record for today's date.  If not, I want it to add one.  If a

I would like to assign two users to a database.  One for general use where
users would log into the database as read only and the other as an admin user
that would be allowed to make changes to the records and the formatting.  I
am an average access user; please keep responses ...

This is my Select query. How can I change this to Change the
TENDSALE.RECEIPT_NUM to = NEW_RECEIPT_NUM
I don't want to add records just increase the RECEIPT_NUM by 2000
SELECT TENDSALE.RECEIPT_NUM, [RECEIPT_NUM]+2000 AS NEW_RECEIPT_NUM

I am working on a query to assign leads by percentage available.  So for
example if we have:
25 Source A
10 Source B

I'm trying to extract the month name (not just the number) from a ChkDate
field in a query.  ChkDate is a Date/Time data type.  I use a DatePart
expression which works fine to pull the month number.
MonthNum: DatePart("m",[ChkDate])

Hope someone might be able to help me.  I have two queries that generate
"identical" data from two different sources. When I look at each of the query
outputs, it has exactly what I want in each.  Each query has identical column
names, and the number of elements are exactly the ...

I have two Queries that I am trying to combine:
SELECT Year([OrderDate]) AS [Year], Month([OrderDate]) AS [Month],
Count(File_Tracking.FileNumber) AS CountofFileNumber
FROM File_Tracking

I have a query that pulls information from three different linked tables.  
(this might very well be the source of my problems but I dont understand why)
When I run the query manually in Access the result set is as I expect, but
when I use that query in a function in Access VBA, ...

I work at a homeless shelter and we're putting together an Access
database to automate our keeping track of guests, services and
statistics.
Here's the situation:

Can anyone shed some light on what this error means and how to fix it?
This database runs automatically each week and has worked fine up
until today. Now each time it reaches a specific query it gives me
this error. Does this have something to do with the jet*.tmp files? I

I have a query based on two tables that takes over 3 minutes to run. There
are 3 lines of criteria. One of the tables has 120,000 records and the other
has 6,500 records. All the fields for which criteria have been specified are
indexed (duplicates OK - except obviously the key ...

I am looking for an easy way to do this:
I have written a query which provides me with a calculated value I will call
IntMult.
I would like to use that value as follows: