I have a crosstab query in which I would like to show all possible column
values, including those where the value would be null.  I understand that I
can accomplish this entering the column values in the query properties under
column heading.

When I run the query, one column has very strange characters like little
squares with question marks inside.  When I go back to look at the source
data, it has letters.  Any idea why my query produces the strange characters
and how I might correct it?

I have a query that calculates a bank balance.  I want this query to
append the current days date and the bank balance to a table.  I have
a macro setup to autorun the query when my database opens, but can't
get it to work correctly.  Details:

I run a query in access 2003 and use the group by and first functions.
Everything works fine except when I create a table from this data the column
heading contains "first of' and then the name. Is there a way to eliminate
the 'first of' other than going into design for the tale ...

I have a macro that opens up a form, hidden, datasheet, edit mode, runs a
delete query which includes all of the fields in two seperate tables, then
closes the form it was deleting from.  
When running the macro, all i get as a response is:

I'm running Access 2007 and would like to know if this logic is correct for
searching duplicates in two tables.
I'm trying to find my renewal rate between all clients from last year
(stored in one table) and all clients from this year (stored in another

I have a table that is provided from higherup that gives me an order header
date in this format 000070207 where the last six digits are the actual
shipping date. I want to get rid of the three left 0's and format the date is
something like mm/dd/yy. Everything I have tried ...

Is there any statement in Access query mode comparable to the Excel statement
=find("this",A5) .... which returns the position number of "this" in cell
A5.  
Thanks.

(I posted this in Reports... but am reposting here)
I have a transaction # for each record in my main form with a subform
"Approvals" and "Checkouts".
I created a query to show the sum of all Approvals and all Checkouts by

I have a shift 6 running after midnight, hence the productions shows on the
next day, can I have the production for the same day.
The shifts timings are shift 1 - 6am - 9am, shift 2 - 9:30am _12:30pm,
shift3 - 1pm - 4pm, shift 4 - 5pm-8pm, shift 5 - 8:30pm:1130pm, & shift6 -

What is the expression for converting multiple dates mm/dd/yyyy to the
coinsiding month?

I have a data base that some fields that are Null and I would like to fill
those
with N/A
I tried to do an update query but comes back with syntax error can someone

Count Aggregate Function
I have multiple independent queries and I need to get the number of records
each of them produced all in one query. I tired union all and was able to get
the required results but was wondering if there is a better way to get the

Need help how to update a table where in the Mid Name field there are
initials.  I want to be able to update with a period after the initial only
if there is an initital and skip the empty fields.  Thank you in advance for
any help.

I have an append query that takes data from one table and pastes it into
another.
the Append query takes data from a table iwth 8 fields, and pastes it into a
table with about 40 fields.  the 8 fields have exactly the  same names in