you didnt hurt me, just that I am missing a lot of information because your question(s) is very general... even the original question is not very precise...
And I still dont know ...
Where and how are you trying to do your count?
Where and how does your database work? ie why do you need this? What do you need it for?What is your target?
Where and how do you want your day?
Thanks for a Coooool briefing...
Ok.. so i will explain you as what i need,
Having a requisition table, then PO table, "Auto" (auto number) is a field in requisition table, field auto is used as lookup (FK) in table PO means AUTO number is number for a specific doc.
Now i need a count of Auto in report .. and i need this count based on different dates in PO table with grndate field having same auto number like;
if 4570 having item A on 1st Jan 2014
if 4570 having item B on 1st Jan 2014
if 4570 having item C on 1st Jan 2014
........ then the count should be 1
same as;
if 4570 having item A on 2nd Jan 2014
if 4570 having item B on 2nd Jan 2014
........ then the count should be 2
if 5001 having item A on 1st Jan 2014
if 5001 having item B on 1st Jan 2014
if 5001 having item C on 1st Jan 2014
........ then the count should be 1
same as;
if 5001 having item A on 2nd Jan 2014
if 5001 having item B on 2nd Jan 2014
........ then the count should be 2
this is the maximum that i suppose to the best of my explanation, hope will work for you to make this easy for my...