Formula in a report

  • Thread starter Thread starter Darrin
  • Start date Start date
D

Darrin

I am Very new to Access, so I know that there will be a
very easy answer to this. I work for an utility and I
want to run a report that tells me what utility poles
need to be replaced. I have a table with our inspection
data and a field named [remaining strength] What I want
to do is print a report that gives me only those utility
poles who's [remaining strength] is =<40%. The formula
is easy enough but where do I enter it so it brings up
the correct report.

Thanks in advance
 
Build a new query as follows:

Select * from [table1] where [remaining_strength] < .4
Order by ????????

replace table1 with your table name, remaining_strength
with the field name and remove the brackets around both.
Assuming the remaining strength field is numeric of some
type this should return what you need.
 
Back
Top