Month on a report

[MrMcFestoe]

I have a report based on a query which asks for the user to input the month they want the report for.

I have tried all ways to display the month the report is based on.

The query looks at 4 fields which could have the month of Jan, March, June, September.

Is there a way of putting the month the user enters on a report?

 

[evilmousse]

I don't understand.

Do you want to use the month a user types into
a textbox as query critera?

try using a dialog form. (a form with
controls for criteria, and a button to
docmd.open your report) then you set
code in your report.open event to compare
what the dialog form's controls are.
ie: me.recordsource = "select * from t_info
where month = '" & forms!fdlgBigRpt!txt_Month & "'"

..i also reccommend using a combobox with
preset month items.
-g

[flush]

 

[MrMcFestoe]

A better explanation,

i have a query that asks for the month to be entered, what i am trying to do is take the month that is entered and place it in the header of a report.

The month in the header needs to be the month the query was run for due to the query looks at 4 fields each with a month value in.

Does that sound any better

 

[flaviooooo]

I think Evilmousse's advice is the right one here.

Use a form where the user can insert the month in question, and then you can reference this entry in your query and report by using =[forms]![formname]![txtmonth]

greetz