G
Guest
Hello,
Let me start off by saying thank you for any help. What I am trying to do
is to count the distinct amount of months that are in my table (tblInvoices)
based on the date they were recieved (rcvdBill).
rcvdBill format is mm/dd/yyyy
For instance:
Company 1:
Invoice A: rcvd 5/1/2006
Invoice B: rcvd 5/3/2006
Invoice C: rcvd 6/1/2006
Invoice D: rcvd 10/1/2006
What I would like is for the Query (or whatever else) to calculate the
disticnt months, which in this case is 3.
Again thank you for your help, and if you need me to clarify anything please
dont hesitate to ask.
Let me start off by saying thank you for any help. What I am trying to do
is to count the distinct amount of months that are in my table (tblInvoices)
based on the date they were recieved (rcvdBill).
rcvdBill format is mm/dd/yyyy
For instance:
Company 1:
Invoice A: rcvd 5/1/2006
Invoice B: rcvd 5/3/2006
Invoice C: rcvd 6/1/2006
Invoice D: rcvd 10/1/2006
What I would like is for the Query (or whatever else) to calculate the
disticnt months, which in this case is 3.
Again thank you for your help, and if you need me to clarify anything please
dont hesitate to ask.