I want print blank (Nothing) if the value of the field is 0. In my
query i have a field
Select dbo_FINDG_RSK_LVL.FINDG_RSK_LVL,
Count(dbo_FINDG_RSK_LVL.FINDG_RSK_LVL) AS CountOfFINDG_RSK_LVL From

How do I create an update query that updates a table from a query? I have a
query that I need one of the fields to update into a table. Can this be done?
In my query I have a field "Expr1" that I need to put into a
tblRawDiameterPricing.BCPrice

Can anyone tell me a quick and easy way to pass the results of a query in
access into excel to chart data through a DDE link ?  I'm aware there is
charting functioanlity in access, but it has proven to be rather inflexible
in my experience.

I manage an awards database. Awards are paid in stages called payments,
which vary in amount.  I have 2 main tables in my database called
tblAwards and tblPayments.
I am trying to produce a query to group Awards to show total payments

Have current linked table that needs to be appended at the end of each month
to a running year to date table. Have a Date field in the YTD table and want
to make sure that current data is not appended more than once. For example,
if January 06 has already been appended and ...

I am trying to create an update query that would follow the following rules.  
I am banging my head against the wall in an effort to write the SQL but don't
seem to wrap my brain around it (keeping in mind that I am not by any means
an expert).

I am running a query that prompts for a date and runs a week from that
day. Right now, no matter what is entered, it returns all of the
records in the table. Here is the query.
PARAMETERS [Enter Week Start Date(mm/dd/yy): ] DateTime;

I am getting an error message with the following query. Could someone
post an example of how to do what I'm attempting so that I can
understand how it's supposed to work?
I have 5 tables. I am trying to do a union on all 5 and add up the

Does anyone know of a way to match data records that are not exactly the same
or based on part of the field value?
i.e. ABC Carpet                         ie. Chubby chicken
     A B C Carpets                          Chubby chickens .....

I would like to query a database regarding entries that appear after a
certain date.
I  would prefer to have a date picker embedded in a form to choose this date
and then be able to open another form from a query that will give me all the

I need to calculate weekly hours in microsoft access, but i dont know how to
do it please help
yannekat@hotmail.com

My company currently has an old database that contains data from 2002-2006.  
We want to create a new one to go from june of 2005-june 2007.  I created a
new table in the current database, but all my queries are gathering data from
the old table.  How can I update all my queries ...

My co-worker has a macro that runs three make-table queries and all of them
ask for dates (Between.....And) that his users have to type in........Three
Times.  He wants to save the original dates the users type in for all three
queries.  By the way, he's doing his reporting for ...

I have a table containing membership data for a professional
organization.  I was asked to add data that gives the date of a
professional certification.  I added the field to the table which is
blank to start with.  I was given a list of names along with the

Trying to merge a query to a Word document. Same query and document used
last year. The query has 888 records the merge shows 0 records. The only
different is that I have changed to XP. Any ideas??? Thanks.