When opening report it prompts for input

[i.am.sophie]

Hi All,

I have a database with loads of different sales data from Jan 2014 with other product details as well. I also have a form where the user can input any of these data (this is based on a query):
- Campaign name
- Exact Date
- Month
- Year
- Category
- Campaign Type

This should run the query, then open a report that's grouped by:
1. Year
2. Month
3. Exact Date
4. Dem name

Even if the user inputs the month and year on the form, when reopening the report, it prompts for inputting the year and month as well, but nothing else.

Do you have any suggestions?

Thanks,
Sophie

 

[CJ_London]

is your query a group by query?

 

[i.am.sophie]

Hi,

Erm..I'm not sure, I don't think it is. (Sorry, I'm new to Access.)

The query is built to find certain data in a huge database based on the user's input on the form. Only after I've done both of these, thought maybe it would be nicer to open the results in a report and not in Datasheet view, so I built the report as well, where the info is grouped by those 4 things.

 

[i.am.sophie]

I was going through everything and found the problem. In the query's code the year and month were not listed after SELECT. Which is quite strange because I definitely remember seeing it in earlier datasheets..

Thanks for your help though!