Where Statement On Report

[fenhow]

Hi,

I have a query that has two fields,

si_Permitting_Status_Lookup and si_Grantee_Acres

It is a totals query so field #1 is grouped by value and field #2 is a sum field.

I have a report that uses this query to show the results.

What I am trying to do is place a txtbox on the report that I can control the value I want to show.

For an example if my query results show 10 items for si_Permitting_Status_Lookup and I only want to show the value and sum for say value #2 out of the 10, how could I do this?

I am trying a dlookup but it will not work..

Example of what I want to do on the report.

txtbox1
= [si_Grantee_Acres] where [si_Permitting_Status_Lookup] = "Refused"

Thanks so much.

Fen How

 

[pbaldy]

If you're trying to restrict the report to that one record, I'd use this technique:

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