Complicated?

[Paul Cooke]

I think this may be complicated but if you don't ask!!!....

I have a from called "Treatment Form" in it, it has a number of fields including one call "Company". At the bottom it has 10 sets of fields for medication issued and the quantity (Separate fields) to a company. Each field is numerically named Con1 & Qty1, Con2 & Qty2 etc.. I also have a check box at the end of the form which is called "Checked"

What I want to do is run a report that lists all the medications issued and the quantities
to a particular company in total but ingnoring forms with a tick in the check box?

I hope this is not to confusing and possbile?

Thanks

 

[D.Mair]

Yes well I think so.

Set up a Query
Place all the field in it. i.e. Company Con1 Qty1 Con2 Qty2 and the check box field

set the criteria for the Company field to

[Forms]![Treatment Form]![Company]

that will only select one company and set the check box field criteria to

No

Save the Query and then create a report on it

That I think should do it.
Although I am no expert.