I am struggling with an “Append Query”. Here is what I have:
+ a table with “Prospect IDs” and other information about prospects
+ a table with “Mailer IDs” and other information about mailers
+ a table called “Mailings” with fields for “Prospect IDs” and “Mailer IDs”

I have a query that displays certain information based on a form. I now want
to sum totals for certain information from the query. There is a few slot for
projects. There is also about 10 projects to choose from. For each project
slot, there is a corresponding Hour slot. I can ...

I converted some Access 97 databases to Access 2000 databases, consisting of
4 Fields only (each Field consisting of a mix of letters and numbers).
When I tried to print out the Tables, only the text previewed or printed,
but not one of the numbers.

Can someone tell me how to tell my table to automatically run all my updtae
queires before opening?

is there any tool which is capable to convert query initially written for
msaccess database to query for mssql server.
I have tons of queries which contains iif, trim and similar functions which
should be converted to case, ltrim(rtrim(, etc. etc.

What is wrong with this expression?
cfs:  (4.28*0.577*0.577351*([Field4])+0.004^2.5)

Stupid question, but I can't locate the function.  I'm calculating the volume
of a cylinder and need to use the math. constant pie (3.14...).  

It's me again. I posted similar question for quite sometime last year about
ranking and this time with few more other ranking problems (sub-sub-sub
query) plus to update the records base on this ranking. I could do simple
update query but got stuck with this one.

Not sure if it can be done or not, i am trying to create a query with an "IF"
formula in it, when if a field is greater the "1" it will open "query/report
1", and if the field is equal to "0" it will open "query/report 2"
Thanks for your help in advance!

I keep getting this message when i run my query from code?? but it runs fine
from Access! what is the problem and how do i resolve it?
Thanks
Darryn

On one of my computers, I am getting the following error:
"Function is not available in expressionin query expression . . ."
I know as a fact that this is a new error and it is unique to this computer.
It is not an error in the query, but that is where it appears.  It must be

I use Access 2003 and I am in the kitchen business.  Prior to now, I have
ordered one kitchen at a time using access.  The method is: "Client" is one:
flowing to "Project" which can be many (kitchen and bathrooms): to "Order
Details" which is a listing of each cabinet in a ...

i have a textbox, and a command button on a form, along with a subform.
is it possible to make it so the content in the textbox acts as criteria for
a "filter selection method"  which can be executed when i click the command
button?

Field 1 is Date, Field 2 is time, Field 3 is elapsed time, Field 4 is
temperature, Field 5 is pressure head,
Error message is:
You tried to execute a query that does not include the specified expression

Hi there...
I have an ASP page which retrieve all records from a database and displays
in a table in a form.  The database has 5 fields and 3 records total.  So I
do the following: