I'm trying to do this formula in access query as a expression to create
a new field and having hard time, can anyone help me please?
IF[dbo.NTH_ACTIVITY_DEFINITION].ACTIVITY_DEF_DID=[dbo.NTH_ACTIVITY_DEFINITI­ON].ACTIVITY_DEF_DID
AND

I have a query that lists a salespersons sales i need to have the total sales
show on their main form .
I have created a text box on the form but cant seem to figure out the
expression to get it to total the 1 column of sales.  Also i would like the

My MS SQL skills are under great test at the moment. I was wondering if
I could get some help on this problem.
So I have a Query which is pulling fields from different tables.
Below are the date elements of my query

I am trying to filter records via a query; the query has a Date field
"DueDate". I would like to display the records that meet the following date
criteria:
<Now()

i have this append query its working apart from one bit
for the field Manufacure ID, I would like it to get the number from the
form i am on
How do i get it set up in the query that when it appends all the data

When joining SELECTs with
SELECT name FROM table1
UNION ALL
SELECT name FROM table2

I want to run a query that is grouped by city and product dollars in each
city.  I want to limit the return to the top 5 products by dollars for each
city.
I can run a query and roll up the dollars but I don not know how to limit

I have a report that gets its data from a query
The query requires input to narrow down the selection.
The query pulls data to print a load order for a delivery route.
The first prompt is the "Delivery Week?" at that point I will type

I am facing the following problem:
Two tables:
Table1
Name    Code

Hello.-
I am having problems with a query that it might seem simple but is
giving me a lot of problems. Most of the values given by the query are
incorrect, they all seems to be a lot higher that what it should. The

Is there any way to avoid this damn error?
Trying to convert using CDbl() does not work.
As best as I can tell, all of the data fits 8.4, which is the way the
field is configured, which means it is a bogus error.

Basically I'm wanting a query to produce DISTINCT results for
"gallery.prod_title" only; obviously there are two tables involved.
With the DISTINCT results I'm aiming to print other data like:
contact_details.bus_name

My table has the following fields
ItemNo          Name Image                       DateRecd
123               Foo 00                               1/1/06
123               Bla.01                                2/1/06

Hi I am Using Microsoft Access 2003. I have a problem getting the name
of the Table. I want to prompt the user for the name of the table so
that i could run a append query. the syntax of the query is like as
following:

what does this error mean:
"Operation must use an updateable query"