Access2000 - prob something obvious

  • Thread starter Thread starter Sherry
  • Start date Start date
S

Sherry

that I'm doing wrong...

I have a report that will eliminate records (based on query) if there is a
ship date. That works. But now I want to add a field (yes/no or "x") that
will further refine that report.

I added the field to the table, added it to the report & then on query made
it either "ship date" or "complete" is null, then report will have only
active records...

Problem is, on that "complete" record, w/o inputting anything, it puts in
either "N" or "-1" --- or even sometimes just "-".... What's up w/that?

This should be an easy thing - I'm hoping someone can point me in the right
direction! It's probably something obvious -- I've done many things like
this before w/out this problem.

TIA,
 
Back
Top