Newbie to Access doing Report

  • Thread starter Thread starter Bob Howard
  • Start date Start date
B

Bob Howard

Suggest placing a filter on the recordsource. Go to the report and open the
properties sheet. On the data tab, you'll see your query name (in the
recordsource line). Below that should be a filter. This would be where you
would type in something like Status<>Closed (this is written in SQL
"where-clause" format) --- then make sure to go down a line or two and set
fileter to Yes (otherwise the filter would be ignored). Bob.
 
Hey newbie here - I have done a basic report and it looks good.

The only problem I have is that ALL the records are printing on my report.
I want all records to print except for the records that have the Status of
"Closed".

Can this be done.

Thanks for any help.

Newbie
 
Your report should be based on a query. Just change your query to only
include the redords you want. Under the "status" field put...

Not "Closed"
 
Thanks Rick. However, my report is not based off of a query - I used the
"report wizard".

So not sure what you mean by change your query.

Thanks !
 
Generally, I would build my reports off of a query (the wizard does this)
not a table. The query let's you determine what records will be pulled.
 
Thanks Bob - did what you said, but records with the Status of Closed are
still showing up.

Any suggestions?

Thanks !!
 
Hi again. Perhaps i was assuming you had SQL knowledge and would tidy up
the filter to make the syntax sorrect.

Check the syntax of the filter.

You need to specify the exact name of the field ... so if it's "Status"
(including a capital "S") then you should specify [Status]

You need to specify the exact field content you are checking ... so if it's
the word "Closed" (including a capital "C") then you should specify "Closed"
(including the quotes)

Thus, the filter would be [Status]<>"Closed"

If the opened/closed status of this record is not text but rather a yes/no
(true/false) condition as it would be defined within a checkbox then you
would need to specify True or False.

Thus, the filter would be [Status]=False

Obviously, the syntax must be precise. Hope this helps!

Bob.
 
It worked !!!!!

THANKS BOB !!!!!!!!!!!!!!!!!!!!!!!!!!!!

Ty




Bob Howard said:
Hi again. Perhaps i was assuming you had SQL knowledge and would tidy up
the filter to make the syntax sorrect.

Check the syntax of the filter.

You need to specify the exact name of the field ... so if it's "Status"
(including a capital "S") then you should specify [Status]

You need to specify the exact field content you are checking ... so if it's
the word "Closed" (including a capital "C") then you should specify "Closed"
(including the quotes)

Thus, the filter would be [Status]<>"Closed"

If the opened/closed status of this record is not text but rather a yes/no
(true/false) condition as it would be defined within a checkbox then you
would need to specify True or False.

Thus, the filter would be [Status]=False

Obviously, the syntax must be precise. Hope this helps!

Bob.

Ty said:
Thanks Bob - did what you said, but records with the Status of Closed are
still showing up.

Any suggestions?

Thanks !!
Click to expand...
Click to expand...
 
Back
Top