Grouping records -

[aquila1972]

I have a table with columns
"Jobs", "Cost-code", "Date", "Amount"
There are 200 K lines in the table.
Aprox 50 differnent jobs number with aprox 100 differnt cost_codes
What I trying to do is Group by Job and group by cost_ codes
Cost codes are 00-000
I want to group by Land = cost_ codes 02-???

Land = 02-???
Soft cost = 03-??? through 05-???
Finance = 06-??? through 09-???

Is there a way to do this?
How do I set up that Land as a column label and equals cost code records
(02-???)


Would like to do it using VBA which so far I can't get any where with it
Can you get me started with what would be need to create groups by land,
Soft costs, & finance.

Thanks
Tom

 

[Marshall Barton]

I have a table with columns
"Jobs", "Cost-code", "Date", "Amount"
There are 200 K lines in the table.
Aprox 50 differnent jobs number with aprox 100 differnt cost_codes
What I trying to do is Group by Job and group by cost_ codes
Cost codes are 00-000
I want to group by Land = cost_ codes 02-???

Land = 02-???
Soft cost = 03-??? through 05-???
Finance = 06-??? through 09-???

Is there a way to do this?
How do I set up that Land as a column label and equals cost code records
(02-???)


Would like to do it using VBA which so far I can't get any where with it
Can you get me started with what would be need to create groups by land,
Soft costs, & finance.

Sorry, but this doesn't make much sense to me. Grouping has
two very specific meanings in Access. One is a way of
specifying a group of records for aggregate functions to
operate on in a query. The other is a way of organizing a
report's data with similar values into "blocks" with header
and footer sections.

If you just want to view the data in the table sorted by the
job and the first two characters of the cost code, you
should use a query (I can't see how VBA would enter into
this scenario) with an ORDER BY clause.