Hi all, I have a check box in my form that I want to total up. It is Lives
Saved.  What I want is a simple total.
This is what I have:
SELECT tblSENESarLog.FY, Sum(tblSENESarLog.LIVESSAVED) AS SumOfLIVESSAVED,

Dear NG -
Could someone help me figure out how to change the month value of a
date value from 9 to 10.  IOW, I have about 20 records with dates like
09/20/2006 and 09/3/2006 and so on.  All dates range from 09/01/2006 to

Dear NG - Is it possible to "test drive" an update query before "buying
it"?  I'd like to see if it is going to work before I make the changes
permanent.  And yes, I have little confidence in myself at this point!
Mike

How do I set the previous month end business day so I do not have to type it
in each time I run a macro.
For example, I have 15 queries that require this field and I do not want to
prompted to type in 11/30/2006 15 times.

I am having a problem with creating employee totals.
I have two tables as follows:
employeesTable:
emp name, locationID, location Name

I am trying to run a query that searches for the same keyword across several
columns.  I have created a form which lists all of the searchable items in a
drop down list but at the moment it is only letting me search for the items
in one column.  I want to search across several.  ...

How does Access determine whether or not a query will allow you to add new
records?  I have a query based on 3 tables...perhaps my tables are not
properly laid out, but I wanted to ask this quick question first.
Thanks

When I set a criteria in a calculated field I am prompted to "Enter
Parameter Value". Does this mean that you can't set criteria for a
calculated field???

2003, XP, all service packs. All the queries have changed their field name.
here is an example.
tlkpWorkDesc.WDesc has changed to Expr1: tlkpWorkDesc.WDesc
tlkpWorkDesc.Item has change to Expr2: tlkpWorkDesc.Item

I hope someone may be able to help
I am running access 2000 on XP machines
I have the following expressions as validation rules on a form.
=Date() Or Is Null Or <1

I have a query.  Below is the SQL for that query.  It joins six tables,
all ODBC.
When I run it, I get a dialog box titled "Enter Parameter Value" asking
for the value of Query18.Expr1

Is it possible to open a query in SQL view without first opening it in
design view? Opening in design view breaks links to non-existing tables and
sometimes MS-Access seems to automatically save the query with the broken
links, without prompting to cancel.

I am experiencing a weird problem. The database has been functional for
4 years. Now one of the total queries is spewing garbage characters????
The database is only 450M and links to two other databases about the
same size. If I take off the sum (or group by) feature on the query it

I have a basic database containing student records.  I would like to be
able to query incomplete phone numbers.  Is there a simple way to do
this?  By the way, some of the phone numbers will have the area code,
some will not, some have no phone number at all.  This is information

TRANSFORM Count([qry_DMC/TOP_CountFY06].ID) AS CountOfID
SELECT [qry_DMC/TOP_CountFY06].Area, Count([qry_DMC/TOP_CountFY06].ID)
AS [Total Of ID]
FROM [qry_DMC/TOP_CountFY06]