Recent content by USMarine430

:banghead: Basically I want a fluid automated process where the Macro Opens Report Prints Report Closes Report and the cycle repeats itself until all months have been printed out. I think my "Where" Condition is my problem. Any help would be appreciated. If you cannot see it below it is...

I currently have a report linked to this table. The sole function of this table is to association a two letter code with a program name. When the report runs, it prompts the Query to ask first: Program Name Warehouse Month If nothing is selected the query by default will elect a wildcard...

Well - Here is what I did - I created a new table like you said Alan, I joined it to the existing table in the query, and then I went in to change the control source of the text box to the newly added "monthDesc" - so now when the query prompts me for the month, it is converted to a text variant...

Pretty darn close - I want to keep the numerical value in the report itself - i just want to convert the numerical value generated in the text box to an alphabetical variant. Is there a where clause I can make? or an "if" statement that would convert the number entered into the query to letter...

About the snipet - I have no idea, I worked with a colleague of mine and that is what he came up with - it works well. . . and I am no where near expedient in my Access knowledge to tell you anything more than the fact that it works. . . Please see the attachment . . .

I have a text box which feeds of of the control source labeled as "month" - this column has nothing but the numbers 1-12 in it. And so appears in the text box is this number. The report prompts the query which has the string: Like...