Record that won't print

N

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?
 
B

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?
 
N

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?
 
B

BruceM

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

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.
 
B

BruceM

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

Howard Burgman

Novice2000 said:
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?
Click to expand...
 
Top