Following the SQL given below, with the corrections that the table name is
[Resolved by Hospice Date Worked] and the Cost Column is Called [Credit
Amount], I have the following SQL that gives me the error "Syntax error
(missing Operator) in Querey expression 'SUM ([Credit Amount]

I am trying to construct a query that will sum the contents of a particular
field based on todays date.  Can't seem to find any examples of this.  
Select count(wins) as numtrades from table where (date = today);  Obviously
the (date=today) is the problem area.

I am running a query that counts all Adult and Juvenile audio book
cassettes. I have call numbers like BOOK CAS J GANTOS (which is a
juvenile cassette) and BOOK CAS F SMITH (which would be an adult
cassette). The J or the F is the important thing here to determine

I have an Access 2000 db in which I need to essentially duplicate an
existing query about 20 times, varying the field being searched on
with each one. Rather than cutting-pasting and changing the search
criteria in each one, is there a way I can make a simple script or

I have an extensive query that I need to export into an Excel spreadsheet -
however the memo field only copies over the first 255 characters - is there a
way to bring over the entire memo field?  If I bring them over one by one
(copy) it does the whole memo field, but cannot ...

SBcnt Table:
[SBNO]
-----------
013180

I created a query to check for duplicates as the following:
SELECT [ALL Policies].CustomerNo, [ALL Policies].ApplicationNo, [ALL
Policies].Carrier
FROM [Working Table] INNER JOIN [ALL Policies] ON ([Working

I'm trying to take the date stored in INVDATE and calculate COVDATE.  The
COVDATE is simply the first day of the next month.
So, if INVDATE is 3/5/2007, then COVDATE is 4/1/2007.  If INVDATE is
12/15/2007, then COVDATE is 1/1/2008.

I am trying to run a query on a table (called SETS) that includes a date
field (short date).  If the date equals a specific date I want to return
"Yes", if not I want to return "No".  Here is the statement I am trying to
run:

I have a table that lists appeals based on responsibility (5 different
options).  I am trying to get the query to list number of appeals, percentage
of appeal, cost of appeals and percentage of cost of appeals bassed on the
responsibility options.  I have canabalized a previous ...

I have a field that contains either 1, 2, or three characters. I want to add
leading 0s to the number to make all numbers three characters long. I use
this formula:
IIf(Len([parcelnumber]="1"),"-00" &

I have a memo field from which I would like to extract a date. Sample text is:
sent on 02032007 from US
I want to create a parameter query, the date entered by the user should be
used to filter the records. In other words, that date should be used to match

I have about 2000 Duplicate records in a Table with 100,000 records. I read
the Microsoft online article about how to "Find, elimiate ... duplicate
records":
http://office.microsoft.com/en-us/access/HA010345581033.aspx?pid=CL100570041033#13

I have a field that has integer and non-integer data.  For this one query, I
need to select out only the integer values.  How do I make a query ingore any
value that has a decimal attached?  (I don't need to round... I only want to
select the whole numbers.)

i cannot get past the logon screen on my compaq presserio when i type in my
password it comes up did you forget your password have been using this
password for 6 years! now it wont let me in! have tried recovery discs but
they wont load what can i do?