Search results for query: *

That works.

5 is stored in the field in the table. I know it is very stupid, but we inherited the database from a user. Would it be easier just to create a field in the table and insert a date - like if it was December(Month) and 4(Year) then I would insert 12/1/2004 in the new field. Then you example...

1/1/2005,2/1/2005, and 3/1/2005 but I would have to convert them to where [Month]IN(January,February,March) and [Year] =5 but if the user selected January or March then my year would change (ie December would be 4 and then January and February would be 5) I've been working on it and I have...

I think I am missing something in my query TRANSFORM Sum(DataTable.Amount) AS [The Value] SELECT DataTable.[Equipment Category], Sum(DataTable.Amount) AS [Total Of Amount] FROM DataTable WHERE (((DataTable.[Store Number]) Not In (850,851,890,0,891)) AND ((DataTable.[GL #]) In...

Yes January, February, March, etc in the cboMonthField 1 through 9 in the cboYearField I did the debug window and this is what it showed ?[Forms]![3 Month Summary Report Form]![cboMonthField] March ?[Forms]![3 Month Summary Report Form]![cboYearField] 2

Am I not suppose to put anything in the parameter clause of the query? I have tried to follow the FAQ example but everytime I enter the parameter DateValue([Forms]![3 Month Summary Report Form]![cboMonth] & " 1 " & [Forms]![3 Month Summary Report Form]![cboYearField]) I get an error. But I...

Do I need to add anything to the text boxes on my report for the months other than setting the control source to M0, M1, etc.?

Sorry I had typed the wrong form name in. I am running it now. Thank you for all of your help

when I try to run the query it ask for the values in the cboMonthField and cboYearField? I have the form open with values selected.

Ok I have the code to open the form. Do I pass the values in the combo boxes in the Where statement?

would I call the query in my button to print the report? not bind it to the form. Right?

Yes, I have a form with two combo boxes on it. One that has the months (cboMonthField) listed the other has year (cboYearField) in it. Here is my query so far TRANSFORM Sum(DataTable.Amount) AS [The Value] SELECT DataTable.[Equipment Category], DataTable.Year, Sum(DataTable.Amount) AS [Total Of...

okay I have the query with the calculated date. But where do I put this? Use this expression for your Column Headings: ColHead:"Mth" & DateDiff("m",[SaleDate],Forms!frmA!txtEndDate) This will produce Mth0, Mth1, Mth2, Mth3,... where Mth0 is sales from the same month as the ending date on...

Where do I add this? Should I pass these values in from a form? I've never written a report that required this so pardon my lack of knowledge in this matter. Thanks Karen

I'll give it a try and let you know how it goes. Thank you for your help Karen

unfortunately not. That's the whole problem. The actual month is stored in the field (ie January, March, etc).

I have no date field. I have two fields Month and year so I'm not sure how to make you suggestion work. I've tried. Thank you.

I have a report that the user needs to enter the month they would like to start at (ie January) In the code it will also pull the 2 months before that month. the user is then asked what year they would like to view. (ie 05). If the month is January or February then the year they enter has to...