Oldsoftboss
AWF VIP
- Local time
- Tomorrow, 01:56
- Joined
- Oct 28, 2001
- Messages
- 2,499
I have been grappling with this for some time to no avail.
I have developed a database to keep track of assets. Each asset has a categoryID, and this controls what labels appear next to the field names (Building category might have Address, Date Constructed, Height etc, Computer category might have Brand, RAM, Screen Type etc) I have a report to summarize the asset list, ordered by asset number.
Problem:
Pic1 is what I currently have, but the headings at the top are for the first asset. If the second asset has a different category it gets confusing.
When sorting by asset No unless I include the field names beside every record, I cant seem to sort by asset no. (Pic2) To me, this looks messy.
Pic3 is grouped by category, but this messes up the asset order and groups all the assets for a category together (as you would expect)
What i really want is for the Assets to still be in order, then if a category changes, start a new heading.
So the report would come out
Heading... Computers
Asset 1
Asset 2
Asset 3
Heading... Buildings
Asset 4
Asset 5
Heading... Mechanical Equipment
Asset 6
Asset 7
Asset 8
Heading... Computers
Asset 9
Asset 10
etc
As you can see the categories are repeated, thus the grouping falls down.
I have experimented with a subfrom, but without success.
Any help appreciated.
Dave
I have developed a database to keep track of assets. Each asset has a categoryID, and this controls what labels appear next to the field names (Building category might have Address, Date Constructed, Height etc, Computer category might have Brand, RAM, Screen Type etc) I have a report to summarize the asset list, ordered by asset number.
Problem:
Pic1 is what I currently have, but the headings at the top are for the first asset. If the second asset has a different category it gets confusing.
When sorting by asset No unless I include the field names beside every record, I cant seem to sort by asset no. (Pic2) To me, this looks messy.
Pic3 is grouped by category, but this messes up the asset order and groups all the assets for a category together (as you would expect)
What i really want is for the Assets to still be in order, then if a category changes, start a new heading.
So the report would come out
Heading... Computers
Asset 1
Asset 2
Asset 3
Heading... Buildings
Asset 4
Asset 5
Heading... Mechanical Equipment
Asset 6
Asset 7
Asset 8
Heading... Computers
Asset 9
Asset 10
etc
As you can see the categories are repeated, thus the grouping falls down.
I have experimented with a subfrom, but without success.
Any help appreciated.
Dave