Report only certain items

[lunchboxfl]

I want to create a report from a field with pcs and laptops to only report laptops. Both are coming from a fied called Device_Type in the database. Is this possible with an if statement or something. Thanks.

 

[PaulJR]

First you need to create a query and put 'laptops' in the 'Criteria' section. You can then create a report from your query. If you google 'access query tutorial' you'll find lots of helpful info.

 

[lunchboxfl]

yeah but thing is I do not have a field just called laptops. I have a field called device_type that has laptops and desktops in it.

 

[PaulJR]

Yes, I appreciate that, maybe I didn't explain myself too clearly.

If you create a query, with device_type in one of the fields, you filter on laptops by inserting the text 'laptops' in the criteria section of the query.

I think I am visualising what you require correctly!