T
TKM
Is it possible to have grouping in a query based off another field in a
query? You can have a report in Access look like the below. But can all the
grouping totals etc be done in a query and none of it done directly in the
report? Reason being I need to transfer the results into an Excel spreadsheet
and I am thinking it needs to go into a report then export to excel. Any help
is appreciated.
I.E. A Access report can look like this..But can you do it in a query
EXAMPLE:
Emp ID
XXXXX
XXXXX
XXXX
XXXX Total number of emp XXXXX
Emp Phone NUMBERS
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXX Total nunmber of phone number XXXXXXXXX
query? You can have a report in Access look like the below. But can all the
grouping totals etc be done in a query and none of it done directly in the
report? Reason being I need to transfer the results into an Excel spreadsheet
and I am thinking it needs to go into a report then export to excel. Any help
is appreciated.
I.E. A Access report can look like this..But can you do it in a query
EXAMPLE:
Emp ID
XXXXX
XXXXX
XXXX
XXXX Total number of emp XXXXX
Emp Phone NUMBERS
XXXXXXXXXX
XXXXXXXXXX
XXXXXXXXX Total nunmber of phone number XXXXXXXXX