How can I make a query in Access that will automatically include newly added
fields in the SQL query statements?  I want to be able to add a new field and
then open the query to see that it has found the new field and searched it
for a specific value.

Is there any way for a crosstab qry to enter a date criteria like: between
now() and now()-14? with dates is working but with now(0 is not working.
Thanks,
Dan

I'm new in this forum and I found them very helpful.  I need help o
something.  How can you run some sort of a looping macro or cod
where the criteria in a query is based on a field in a table, and th
query is run for each record in that table?  To illustrate, I have

how come i randomly get an error message saying table not found (exact error
message is pasted at bottom of this post).  I get this error when trying to
perform a select statment with ADO in visual basic 6 on windows xp to a
remote access 97 .mdb via oledb.

I have a query that looks at the invoice field of a table, and based on the
data in that field, for each transaction type "DI", changes the transaction
type to "Monthly Billing @@", @@ being a number from 01 to 99. The invoice
field will either contain a number sequence, from 001 ...

Greetings!  I am trying to create an update query tha
uses the IIf function to give staff members hired before 7/1/96
salary increase of 7%, and all others an increase of 3%.  This i
from a Stellar Publications workbook that I am using as a

I have a form based on a query which when the employeeID is entered, the
forename and surname are displayed. However, I have had to make some changes
which included adding a new table which, in turn, made the query not
updateable. I have solved this by changing the properties to ...

I may be asking more than access can deliver.
I have 2 tables:
In the first table I have a mobile telephone number with the average number
of minutes used the previous three months together with additional fields

Everyone,
Here's what I have:
I have an employee table setup with Social Security as a  key, the
Department they are in along with a bunch of other data. I then have another

I have a crosstab query with two row headings, four columns, and one totals
column where the average is calculated for each row. If one of the columns is
missing a value for one of the rows, the value in the totals column is
incorrect for that row. It is neither the average of ...

I have a table with about a 1000 lines of data pertaining to some client
data (much of the data is numerical).  For about 50 of my clients I have 2
different lines of data - I need my query to spit out the exact same data
as my table but with only 1 line (with the numbers summed) ...

I'm trying to embed an error function in an IIF function, but I can't seem to
get it to work properly.  In Excel, I often use a formula like this:
IF(ISERROR(A1*1),"UNKNOWN",A1*1).  Essentially, if you're going to give me
an error when I try to do the formula, don't do it.  ...

I'm using the Trim function to remove leading spaces from a field in a query
like so:
Trim([address])
and I keep getting a compile error...any suggestions?

I have a form with 3 currency fields.  I would like to show them as blank
instead of $0.00 if there is no data inputted.  I have changed the default
value to Null in the table and on each field of the form and it is still
showing as $0.00.