finding duplicates in a form

[Guest]

I don't think that the query wizard for find duplicates
works with a combo box field for status_id. The combo
box contains the field open, closed and future. There
can only be one open period at a time. The underlying
table looks something like this:

GL_ID GL Period Status_ID
0104 Jan - 04 Closed
0204 Feb - 04 open
0304 March -04 Future
0404 Apr -04 Future

 

[Mike Painter]

I don't think that the query wizard for find duplicates
works with a combo box field for status_id. The combo
box contains the field open, closed and future. There
can only be one open period at a time. The underlying
table looks something like this:

GL_ID GL Period Status_ID
0104 Jan - 04 Closed
0204 Feb - 04 open
0304 March -04 Future
0404 Apr -04 Future

The wizard works on a query which is formed of usually one table. It has
nothing to do with the combo box.

To find if there are more than one period open, you can just run a query
with the criteria for the field Status_ID set to "open"