I have a crosstab query that I want to use a run-time parameter (i.e. [Please
enter date]) in one of the fields that happens to be a Row Heading.  When I
run the query, I get an error stating that the database does not recognize
'[Please enter date]' as a valid field name or ...

In tableA.upc I have a field that holds 697807070369 for a value
in tableB.upc I have a field that holds the information but has leading zeros.
Also not all items have the same amount of leading zeros.
How can I query those fields to show me the information for tableB.upc?

I have a date/time field. I need to extract just the date in order to do
further date calculations. I created a calculated field using DateValue - but
if the field does not have a date, it returns #Error. So, I changed it to the
following: IIF([field] is null,"" ...

I have a bout 600 records of employee names in my tblEmployee.  I have there
first name as e.g., John A. and EmplLastName as e.g., Smith.  I have
EmplEmail that is supposed to be e.g., John.A.Smith@CompanyName.com  Wherer
Company Name represents the company's name.

If I have a subform within a form, the subform will add each new record
according to the ID that was linked from the main form.
My question is, how do I get that ID for query purposes?
I want to run an action query based on the linked parameter of the

Can this statement be simplified? It seems like a "hack" but it works
for me.  I'm just wondering if theres a more efficient way to do it.
The query lists all records in tblClients and the sum of curAmount for
the specified period.

In  database, I have three tables. THe first one has the audit findings, the
second one has the responses from the clients, and the third one has the
follow-up work on th implementation of the recommendation. In the last table
there may be multiple records tied up to that same ...

Cross-Post from General Questions = NO Replies there yet...
I can get the recordset generated by an Access Cross-Tab Query to transfer
into
Excel thru automation...but...

First let me tell you what I'm trying to do and let me know if there is a
better way.
I am wanting to be able to click on a button and have it export a query and
save it to the an excel format (97), without having to do anything else.  It

I have a form with a subform and I would like to create a button that copies
the entire contents of the record (including subform) into a new record. I
have fantistic code for copying the main form, but how could I tweak this
code to include my subform (Partner_WI_Subform)? ...

I have a form that works great, it counts the items that are needed for my
report. The problem that I am having is when I open my query to check my
totals they are not there, each field is empty. I filter my form from the
query so all the data that is in my form should be in the ...

I am using VBA to screen scrape values off of a Reflection Digital/Unix screen
(that isn't as difficult as it sounds)
into an Access Table.  Part of this extract includes pieces of actual Cache'
code (MUMPS) which includes numerous quote charactes, apostrophes, pipe

trying to figure easy way to get 1st of current month (3/1/2004) - figure
then i could use DateAdd to minus 3 months - the first of month is stumping
me here this morning - can i do this in a query?
thanks!

This query works in SQL but gives an error if I try to do a Access query.
Anyone know why?
update tickets set [Description] = TicketDetail.TicketDesc
from TicketDetail

I need to be able to count more then on column in a query and still have
them grouped by each column.
So lets say I have 14 columns  called Q1-Q14. I need to count how many times
each number in the column appears for each column. Each column can have a