Search results for query: *

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.

I added = to those sets ie <=. Still I am 4 records short.

I have 2 queries. They are exact opposites. But I am losing 4 records. Can anyone help? I am just going to list the 2 queries. First FROM Filter WHERE((((Filter.[TC-530])="TC-530")) Or (((Filter.[TC-150])="TC-150")) Or (((IsNull((Filter.DOD)))=False)) Or (((Filter.DOB)<#1/1/1929#)) Or...

I don't have a primary key. The field is the DOB field. I see everything except the DOB and the DOD field data.

The fields are showing correctly. Just not all of my data. Reg

I have a linked table. Several of my fields are not being shown. Any suggestions on how to procede? Reg