filter records

[joecamel9166]

I hope this all make sense.


I'm building a repair database. There are 6 stages to the repair. (receive, eval, quote, approve, repair, ship)
each form has a required initial field.
(All of this Unit data is stored in a single table)
What I want to do is make a list box so I can show which units are in which stage.
My thinking tells me that I should filter by records that have receive initials value = true and eval, quote, etc = false. so on and so forth.
(there are multiple people entering their initials, so I just need to indicate there is data in the field)
What is the best way to query this information?
Or if you think there is a better way to do this, I'm all ears!

thanks

[NTC]

one can query those fields via Is Null or Not Is Null in the query criteria to return records that qualify

I presume you have a sequential aspect to this thus all evaluated are de facto received; in which case you don't want to see those received records if they've moved on to the next stage.... so you'll have a series of queries; in this case you would have Not Is Null for receive and Is Null in eval - to get just records of receive only.....

[joecamel9166]

Thank you. I came to that conclusion.