Filter Report in Access 2013

sashapixie

sashapixie

Board Regular
Joined
Aug 29, 2013
Messages
71
Office Version
  1. 365
Platform
  1. Windows
Hi

I created a report from a filtered table, however when I unfilter the table this applies the same filter to the report, I have check boxes in the report, what I want to do is filter the report based on the checked boxes, I am new to access, any help would be appreciated.

:)
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Sort by date Sort by votes
I have worked this issue out now, I just needed to create a query with my criteria, only issue is now I have created the report and added a new field and criteria to the query and this is not updating in my report :(
 
Upvote 0
I have worked this issue out now, I just needed to create a query with my criteria, only issue is now I have created the report and added a new field and criteria to the query and this is not updating in my report
Click to expand...
So, have you changed the Report to use the Query as your Data Source instead of your original Table?

If you add a new field to your Query after the Report is created, you will need to add that field to the Report manually (it is not automatic). Just open the Report in Design View, click the "Show Fields" button, and click and drag your new field onto the Report.
 
Upvote 0
I tried that but it doesn't filter in the same way the query does, I added a field to select staff from a type list, in the query I have all the records for my staff, but the report shows staff and operatives, I can't work out why it is not filter even thought the data is being pulled from the query.
 
Upvote 0
How exactly are you "filtering" your Query?
Are you using "Filters" or "Criteria". I think "Filters" are only temporary for as long as the Query is opened. Criteria is saved along with the Query.
 
Upvote 0
I'm using Criteria, if I create a new report from the query with the new criteria the report works fine, I am just struggling to update the old report with the new field and criteria, I don't understand why they are both pulling data from the same query, I don't want to have to create a new report each time I make amendments to the query.
 
Upvote 0
If your Report is really using the Query as the Data Source, it will return the EXACT same set of records that your Query does.
If it does not, then your Report probably is not using that Query as its Data Source, but rather some other Query or still your original Table.
Are you sure that you changed your Data Source of the Report after you created the Query (and saved the changes to the Report)?
 
Upvote 0
I created the report using the wizard, but it looks like it was using data from different tables, I have selected report from the property sheet and can see all the tables it was using, I have changed these to all pull the data from the query, however it is now duplicating my name field :( Thanks for you help so far I would have thought creating the report from the wizard with the query selected would pull all the data from my chosen data source.
 
Upvote 0
I have changed these to all pull the data from the query, however it is now duplicating my name field
Click to expand...
Can't you remove one instance of the name?

I don't ever use the Wizard to create Reports. If you have your Query open, and click on "Report", it will build a "default" Report automatically based on that Query. Then you can edit that to suit your needs. Or, if you click on Report Design, you can build your query from scratch.

Alternatively, you could use the Report Wizard to rebuild your report this one time. Just make sure that you select the Query, and nothing else, as the Data Source of your Report.
 
Upvote 0
I have reverted back to my previous version and created a new form with the query open, this appears to have worked, I will just need to re format my report as per my previous version.

Thanks for all your help, I'm new to access and your advice was very helpful. :)

Merry Xmas!
 
Upvote 0
You must log in or register to reply here.

Similar threads

JenniferMurphy
  • Question
How to structure a variable product rating database
Replies
5
Views
279
mdmilner
M
M
  • Solved
Access and Excel Reports
Replies
1
Views
796
Micron
M
T
  • Question
Display a list of the count of each unique value in an Access report.
Replies
1
Views
457
Micron
M
bobgrand
  • Question
New to Access - Build a Project Tracking Sheet
Replies
3
Views
377
Micron
M
R
  • Question
Access Reports
Replies
1
Views
354
welshgasman
welshgasman

Forum statistics

Threads
1,214,606
Messages
6,120,484
Members
448,967
Latest member
visheshkotha

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top