Combo Box selection Invoicing by Month

[FrunkaBlunka]

Hi,

I am trying to create a query which displays mothly invoicing based on
a selection from a combo box on a form. So for example if I pick May
from my combobox, I would like everyhting that was invoiced in May to
appear in my query. At the moment I have inserted MSCAL.Calendar.7 to
select the date when invoiced. That date is stored in the record in the
tbl call ProjectDetails.

Using that date how do I create a query that looks at what I have
selected in my combobox ie Dec and displays records from the month
only. Originally I had a query for every month but I thought there must
be an easier way instead of having 12 separate querys.

I had it set up another way where I had 12 toggle buttons with the
different months so I could see 2 or 3 months of Invoicing if I wanted
to but I found that rather tedious.

If anybody can think of an alternative method or a working solution it
would be greatly appreciated.

Thanks

Blunka

 

[Guest]

An idea only:
Add one more Column to the left of your Combo Box with number from 1 to 12,
modify it to show the name of the month (if you want).
For example, if your Combo Box's Row Source Type is Value List, and it's Row
Source is: Jan;Feb;Mar;Apr ... , change it to : 1;Jan;2;Feb;3;Mar;4;Apr ... ,
Set Column Count: 2, Column Width: 0
In your Query, add a field {e.g: MonthOfInvoice: Month([DateOfInvoice])},
Set Criteria for that field: [Forms]![YourForm]![YourCombo]
Hope this is clear.