Count number of records with date

[thescottsman]

Hi all

I have a table which specifies the delivery date

I have a from that allows you to choose a year and a month.

I have an unbound textbox which I wan to display the count

I want to be able to count all the records from a table with the year and month specified in the comboboxes and display this in the texbox

can anyone help?

 

[Uncle Gizmo]

Your first step would be to use the built in query designer grid and create a query that successfully returns the records that match.

 

[thescottsman]

Hi

And what would be the best way in which to do that and then apply it?

 

[Uncle Gizmo]

Using the built in query designer for this particular task should be a skill you have mastered by now. However if you are unfamiliar with it then I'm sure you would be able to find a youtube video demonstrating its use.

 

[thescottsman]

My apologies

I have sorted out the query and it is working.

How can I apply this into vba?

thanks for your help