Record that won't print

[Novice2000]

Hi,
I am printing invoices from a table that contains adress infor and fees. For
some reason one record will not be brought back in a query. It doesn't appear
to be any different than all of the other records in the table. Any ideas?

 

[BruceM]

Is it a parameter query? That is, are there criteria for any of the fields?
If so, does removing the criteria allow the record to be included in the
query? If so, the one record's field value does not meet the criteria for
the field. If that is the case, what is the field and what are the
criteria?

 

[Novice2000]

Only >0 for the fee and the fee for this client is $300. I removed it and it
still isn't showing up. I thought about the one field not meeting criteria,
but how can that be? It is part of a table of 15,000?

 

[BruceM]

You removed the criteria, so that there are no criteria for any field, and
still the record did not show up?

 

[Novice2000]

Yes!! It is beyond weird. I am still trying to figure it out. I may end up
having to type the invoice. But, my bigget concern is to find out what the
cause is so it doesn't happen again.

 

[BruceM]

Post the query's SQL. To do that, click View > SQL. Copy what you see, and
paste it into a message.

 

[Howard Burgman]

Hi,
I am printing invoices from a table that contains adress infor and fees.
For
some reason one record will not be brought back in a query. It doesn't
appear
to be any different than all of the other records in the table. Any ideas?