Help with counts on underlying table

[tomlin873]

Hello, I have an [Orders] table which features [Status] field with several types of Status possible (‘To Buy’, ‘To Make’, ‘Scheduled’, ‘Complete’ etc.)

For the several form views in my database, I’d like a small summary display (possibly in the footer) that would give a current count of the various Status types (i.e (‘To Buy = 3’, ‘To Make = 6’, ‘Scheduled = 9’, ‘Complete = 37’ etc.)

Can I use an expression on each form to extract the appropriate counts or would I create a query on the underlying table or…?

Any help with the language to use for specific commands would be much appreciated since I’m a newbie.

 

[rainman89]

this can be done with a query

count the ID field and in the criteria of the status you can put whatever code it is that refers to the status
ie
tobuy=1
tomake=2 etc...

hoping that you have it set up this way. it will make it easier on you if you do

 

[tomlin873]

Thanks for pointing me in the right direction Ray - looks like I've got it sorted and it works well in my various forms.
Best regards
TonyT

 

[rainman89]

glad to hear it and glad to help