The following statement creates the following Run-Time Error:
Run-Time Error 3075:
Syntax error (missing operator) in query expression 'PropertyID=2
DefendantType="Owner"

I have a table that includes and ID and language field where multiple records
include the different languages.  Some ID's have up to three languages so it
looks like:
ID1,language1

I have three fields.  They are [initials], [type of time] and [amount].  I
need the sum of the [amount] field for [type of time] that is either "comp
time earned" or "comp time used" so I created a crosstab query.  [Initials]
is the row heading, [type of time] is the column ...

I would like to extract data for the current month only from my data base
based on a receipt date. formated as mm/dd/yyyy I can get todays stuff and
last months stuff but simply can't get the current month.

I am getting an error with the below DSUM expression:
LeadHours:
IIf([helo#]<41200,nz(DSum("HOURS","tblUnitHours","[STATION]='" &
[STATION] & "' [LongNose]='S'"),

I am facing a problem of creating multiple aggregate functions in the same
query. What I want is like to get the number of courses for a certain month
and I have a field that gives me the date of a course. So what I am doing now
is creating a separate query for each month. For ...

Dear Forum,
I hope you could help me with my new MS access 2000 challange.
I would like to calaculate in a query the different between 2 dates.
Output should be cleaned by Saturday and Sunday.

Good morning, I need a Left outer Join with two conditions:
The records not in Dept table and CONDITIONS: (Emp.Name=Dept.Name AND
Emp.Age=Dept.Age)
For Example: I have two tables like below:

I have read many many articles on this website and I still can't get this
right.
I want a count of distinct RefNum displayed on my subform.
My subform displays 3 records, 2 with the same RefNum, so I would like the

I have a query that runs perfectly well using a multivalued field (Access
2007), however when I base a subreport on it I get an error back claiming
that it can't find the relevant field in my table...can anyone help?

Quick question...
I am trying to set up a query in access 2007 that will return all of my
customeers who I shipped to 14 days ago.
This simple function works in my 2003 version, but why can't I get it to

How do I properly use the two WHERE conditons below?  The OWNER is a literal
statement, meaning the owner of the property and will also remain the same.
Property_Owner: Concatentate("SELECT FirstName & ' ' & MiddleName & ' ' &
LastName & ' ' & Suffix  FROM taDEFENDANTS WHERE ...

I have a user form where a user types a date.  I then need to group and count
records in my table for the week of the date the user picked plus the past 3
weeks.  My weeks are Monday - Sunday.  For example, if a user picked May 20,
2008, week 4 is Monday, May 19 - May 25, week 3 ...

I have the below SQL that obtains the names of property owners from the data
stored in tables.  The SQL adds the firstname, middlename, lastname and the
suffix together into a field called Property_Owner.  The question I have is
this, what if the property has two owners (most ...

Ok, below is the SQL statement for a query I want to run to find the list of
open disputes and combine the current list of disputes with the old list that
has the updated comments and such. When I run this, the resulting records are
duplicating. For example: