bobunknown
Registered User.
- Local time
- Today, 09:31
- Joined
- May 25, 2018
- Messages
- 77
Hi all you Report wizards
im trying to learn more about reports. Specifically the expression builder.
*Context
I have a database for Waste removal (bins and stuff) and I want a report that tells me how many bins of a particular size we have out currently. The database I have has a "Bin Size ID" assigned to each different size of bin (120L = 1 , 140L = 2, 240L = 3 etc).
My idea was to use the expression builder to count how many times the ID 4 (for example) shows up but the expression builder has other ideas.
This is what I have so far:
=DCount("[Bin Pricing]![Bin Size ID] = 4 and [Collections]>0")
(The bit at the end is because I don't want it counting bins we don't collect)
Any thoughts? is my approach correct? or is there anther way?
im trying to learn more about reports. Specifically the expression builder.
*Context
I have a database for Waste removal (bins and stuff) and I want a report that tells me how many bins of a particular size we have out currently. The database I have has a "Bin Size ID" assigned to each different size of bin (120L = 1 , 140L = 2, 240L = 3 etc).
My idea was to use the expression builder to count how many times the ID 4 (for example) shows up but the expression builder has other ideas.
This is what I have so far:
=DCount("[Bin Pricing]![Bin Size ID] = 4 and [Collections]>0")
(The bit at the end is because I don't want it counting bins we don't collect)
Any thoughts? is my approach correct? or is there anther way?