bobunknown
Registered User.
- Local time
- Yesterday, 23:26
- Joined
- May 25, 2018
- Messages
- 77
Hi all just trying to expand my knowledge of group by and other such functions so I can get useful information from my data and I would appreciate some help.
The attachment shows a sample of data I'm working with, just two columns to start; Bin ID & ID.
My aim, to count the Bin ID's but to have them grouped by ID.
My best guess would be
Select both fields...
Count Bin ID...
From Bins(the table)...
Group by ID...
on the money? ooooor way off? advice and examples would be appreciated.
The attachment shows a sample of data I'm working with, just two columns to start; Bin ID & ID.
My aim, to count the Bin ID's but to have them grouped by ID.
My best guess would be
Select both fields...
Count Bin ID...
From Bins(the table)...
Group by ID...
on the money? ooooor way off? advice and examples would be appreciated.