locating records

[Chris]

I have create a form that creates a query. i have that
up and running but now want check the orignal data for
any flags in the orignal data set. for example my query
returns the following fields
Date, ID, Value
The unique id in the orignal table is ID & date
combined. I would like to check for each record in the
query if the value has a flag associated with it. I
don't want the flag in the query b/c it is for input into
another program. I just like it to inform the user if any
values have a certain flag. I don't know where to
start. any help is appreciated.

 

[John Vinson]

I have create a form that creates a query.

How do you "create" the Query? in VBA code? or does the Query use form
references as criteria?

i have that
up and running but now want check the orignal data for
any flags in the orignal data set. for example my query
returns the following fields
Date, ID, Value
The unique id in the orignal table is ID & date
combined. I would like to check for each record in the
query if the value has a flag associated with it. I
don't want the flag in the query b/c it is for input into
another program. I just like it to inform the user if any
values have a certain flag. I don't know where to
start. any help is appreciated.

I guess I don't understand. You don't want to include the flags, but
you do want to include the flags (to inform the user)? If the query
returns a hundred records, and eight of the records have flags, what
should the user see?

I think you may need two queries - one to present the flags, and a
separate query for the export to the other program.