Access 97 field problem...

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

Sherry

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 "complete" (yes/no or
"x") that will further refine that report.

I added the field to the table, added it to the query & 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,
 
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?
Click to expand...

Check in table design to be sure that the Default property of the
field is blank. It sounds like it's defaulting to True (which is
stored as -1; 0 is False).
 
Back
Top