G
Gover
I've imported an excel spreadsheet into Acees. Need to Group by Column
Heading - Premises Name - which has been entered many times for each premises
- then to display all the items that premises holds
I can produce this in a report, but the user wants to use this information
in a mailmerge. Thought I could group it easier in Access than Excel!!!!
Premises Name Asset No Location Category Item
1 Crouch Close, Group Home A063123 Kitchen Elec Dishwasher
1 Crouch Close, Group Home A063124 Kitchen Elec Cooker
1 Crouch Close, Group Home A063125 Kitchen Elec Toaster
1&2 Fields Road, Group Home A064535 Kitchen Gas Cooker
1&2 Fields Road, Group Home A064537 Kitchen 1 Elec Freezer
1&2 Fields Road, Group Home A064538 Kitchen 1 Elec Fridge
Heading - Premises Name - which has been entered many times for each premises
- then to display all the items that premises holds
I can produce this in a report, but the user wants to use this information
in a mailmerge. Thought I could group it easier in Access than Excel!!!!
Premises Name Asset No Location Category Item
1 Crouch Close, Group Home A063123 Kitchen Elec Dishwasher
1 Crouch Close, Group Home A063124 Kitchen Elec Cooker
1 Crouch Close, Group Home A063125 Kitchen Elec Toaster
1&2 Fields Road, Group Home A064535 Kitchen Gas Cooker
1&2 Fields Road, Group Home A064537 Kitchen 1 Elec Freezer
1&2 Fields Road, Group Home A064538 Kitchen 1 Elec Fridge