bloody_football
Registered User.
- Local time
- Tomorrow, 06:27
- Joined
- Sep 8, 2004
- Messages
- 70
I am new to Access so this may seem simple to some but I have searched the forum board and can't find an answer. I'm using access 2000.
I have created a query with 4 columns, the last column does a count of the third column and all works fine (hopefully the example below can give show what I mean) -
Location Status Type Count
-----------------------------
NSW On Hire PS2 23
NSW On Hire PS4 154
etc etc
I have created a report fine but all my problems occur when I try to create a 'page'.
I have drop down menus so the user can choose the 'Location', 'Status' and 'Type' that they wish to enquire about, but I can't work out how to show the 'Count' on the page.
I really do hope I have explained the problem properly
I have created a query with 4 columns, the last column does a count of the third column and all works fine (hopefully the example below can give show what I mean) -
Location Status Type Count
-----------------------------
NSW On Hire PS2 23
NSW On Hire PS4 154
etc etc
I have created a report fine but all my problems occur when I try to create a 'page'.
I have drop down menus so the user can choose the 'Location', 'Status' and 'Type' that they wish to enquire about, but I can't work out how to show the 'Count' on the page.
I really do hope I have explained the problem properly
