In query, getting "Data type mismatch in criteria expression" mess

[Guest]

1. Using a Make Table query, I generate a table

2. When I run a query that uses this table, I get the message ""Data type
mismatch in criteria expression"

In the query that i used for the Make Table, i have several fields including
dates, currency, numbers, and text.
I may have goofed up in setting formats/values in some of the fields. For
example:
I wanted to set some of the fields to zero or null. I used the following
syntax:
aDateField: " " (i want this field to be a blank date)
aTextField: " " (is this ok?)
aNumberField: 0 (is this ok?)
aCurrencyField: 0 (i want this field to be a blank currency)

Note: If i run the same query using an existing tabe (i.e., one that was
not created using a Make Table query) it works fine.

What am i doing wrong?

 

[Guest]

Also, I should note that

I am using a Union Query on an existing table and the table created by the
Make Table Query. The number of fields are the same. Evidently, there is a
mismatch in one or more of the fields in the existing table and the table
that i'm trying to union it with (i.e., the one created by the Make Table
Query)

Is there a way to ensure that these fields have the same data type?

 

[Ken Snell [MVP]]

To set a date/time field to a "null" or "empty" state, set it to Null.