Hi, I have a query which i have created by two linked tables. I have then based a report on this query. In the query i have written [Enter Date] in the date column and [Enter Shift] in the shift column. When i open the query it asks me once to enter the date and enter the shift and seems to work. When I open the report it asks enter date and enter shift multipl times (like it is asking per page) What am i doing wrong?
I expect you might have a subreport or chart in your report. IMHO, parameter prompts are never a good user interface http://www.tek-tips.com/faqs.cfm?fid=6763. Consider using controls on a form. -- Duane Hookom Microsoft Access MVP "Nikki" wrote: > Hi, > > I have a query which i have created by two linked tables. I have then based > a report on this query. In the query i have written [Enter Date] in the date > column and [Enter Shift] in the shift column. When i open the query it asks > me once to enter the date and enter the shift and seems to work. When I open > the report it asks enter date and enter shift multipl times (like it is > asking per page) What am i doing wrong?
