Hello peoples!
I have one question I hope you will help me.
How do I filter rows in my query, which are not needed but can be re-displayed if need.
Kind regards!
Hello peoples!
I have one question I hope you will help me.
How do I filter rows in my query, which are not needed but can be re-displayed if need.
Kind regards!
If the query results are on a form, apply a filter. Either through VBA or using the right click menu options.
Or specify criteria for the filter in the query design.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Based on that query I made a report, is it possible to filter the rows in the report, which I do not need but can show them as needed.
You can filter a report in Report view mode, again by right clicking a field and applying a filter.
This filter will be held over if you goto print preview.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Yes, I understand. But I have a report of 35 names, some of which need not be displayed. The criterion is pulled from a completely different table where I made the column for those names "Active" - YES / NO.
In the report for the Query add the other table, link the matching field (Names?) and add the "active" field, make the criteria for that = Yes
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Minty thanks for previous posts!
Please consider that I am a beginner in access, can you explain me more closely, how to link a report with the required table and column.
Thank you!
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓