How to build a report that only displays specific data (1 Viewer)

[awade]

Good Morning All,

I have an excel spread sheet that is linked into access 2003 via a table. This spread sheet is updated by personnel in another location and I have to run a weekly report on engines stored in that table that are below a certain performance level.
The column heading is MGT Margin and I have to list all of the engines that are below 20 degrees.
Can I run a query that looks at this table and produces a report of all the engines that are only below 20 degrees?
I currently have to cut and paste each engine from the updated spread sheet every week onto a separate spread sheet and import that into access to run the report. Can a query be used to run the required report? I have attached a screen shot of the query that I am putting together to try and run this report.

Thanks in advance.

 

[pbaldy]

Sure, you can either put the parameter in the query or use this method:

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

Presuming it's a numeric field, the query criteria would be:

<20

 

[awade]

Thanks Paul,

Yes it is a numeric field.

Sorry, I am very new to access, where would I put this parameter in the query?

 

[pbaldy]

In design view, you'd put it in the criteria box under that field.

 

[awade]

Thank you very much, put the <20 in the criteria box under the MGT Margin Query field query and generated the report.

 

[pbaldy]

Happy to help!