Recent content by Reggie2004

One problem. I have the table linke to a .txt file. I would have to sanitize the data to send you the filter.txt file. Then after sanitization I don't think there will be any data to use. What do you think?

It listed in the Queries tab.

Data type mismatch

And ((Filter.MODULE_BALANCE)<"0") and ((Filter.[TC-590])<>"TC-590"); 2nd OR (((Filter.MODULE_BALANCE)>"0")) OR ((Filter.[TC-590])="TC-590");

Field Size 255 Required no Allowed zero length yes indexed no Unicode Compression no IME Mode No Control IME Sentence Mode None Data type text I hope this is what you want.

<"0" is all I see in the design view.

Neither works. 0 or "0" with your query. I get data type mismatch on both.

When I used yours I did not have any quotes. A straight copy and paste.

Data type mismatch error. When I use your changes.

You are currect it is a text field. But when I use the query you gave me I get a data type error.

It is a number field.

Removed the change to 1 query only. Still missing 4 records.

FROM Filter WHERE ((((Filter.[TC-530])<>"TC-530")) And (((Filter.[TC-150])<>"TC-150")) And (((IsNull((Filter.DOD)))=True)) And (((Filter.DOB)>=#1/1/1929#)) And (((Filter.DOB)<=#1/1/1986#)) And (((IsNull((Filter.[SSN S])))=True)) And (((Filter.[TC-421])<>"TC-421")) And...

But I still end up with 252 instead of 256 records.

Yes I have.