Access help – forms to select data

[SkippyjonJones]

I’m trying to create a form that users can view to drill down through information.

 

 

So it will initially show a set of data in a table – linked to a query that sums up all the amounts for column1 one in the table.

 

I then want then to be able to select an item in column 1 (lets say it’s a set of towns) and use that criteria to display a listing where column 1 then stays as just the one they have selected but it now sums the data based on column 2 – and displays that.

Then select an item from column 2 and shows that sub set.

 

Ultimately after selecting from 4 or 5 sets of info then to produce a spread sheet with all the data in it.

 

EXAMPLE

 

So initially

 

 

Column 1 amount

Town a 10,000

Town b 15,000

Town c 35,000

Total 60,000

 

Selection = town b

 

Town b

Column 2 amount

Shop 1 8,000

Shop 2 1,000

Shop 3 500

Shop 4 6,500

Total 15,000

 

Selection - shop 4

 

Town b

Shop 4

 

Column 3

Item type 1 1,000

Item type 2 3,000

Item type 3 2,500

Total 6,500

 

Selection item type 1

 

Town b

Shop 4

Item type 1

 

Then a list of everything that makes up that selection to a total of 1,000 (could be 20 or 100 items.)

 

I then want that list to be exportable (into excel).

 

 

How do I do that so its just able to select by clicking on the criteria or at least a drop down list…