Question Print Record with Yes against them

[chohan78]

hi,

I am trying to design a form or report where I can print the records marked with Y/N, but not sure how to do it?

could anyone please help !!!!!
thanks.

 

[pbaldy]

You can base the report on a query with that criteria, or use this:

http://www.baldyweb.com/wherecondition.htm

but hard-code the criteria.

 

[chohan78]

thanks Paul,

I have attached a simple sketch of the database which I am thinking, I want a report where I enter an order number and it give me all those fields where the required field is ticked. (please check the table) and should not give those items which are blank.

not sure how to go ahead but I am sure your guidance will make be able to achieve the goal.

looking forward to your response.
thanks.

 

[pbaldy]

For starters, with the "item" fields you table is not normalized:

http://www.r937.com/Relational.html

If you choose to stay with this design, this query will pull records where one of the fields is checked:

SELECT *
FROM Table1
WHERE Table1.item1_req=True OR Table1.item2_req=True OR Table1.item3_req=True OR Table1.item4_req=True

 

[chohan78]

hi thanks for the query.

but I am not sure where to put this code ? I mean which field..

 

[pbaldy]

That is a query in SQL view. In design view, you'd put True in the criteria of each required field, on different lines.