select Month gone awry

[Jon Geiger]

I have 2 identical (I think) databases functionally but different data. One
has much more fine-tuning in the report appearance. Select queries filter
records for the desired month and year. One works elegantly after telling it
the month and year number to yield records of interest for a report but the
other, with all the window dressing, asks month and year number over and over
for each record meeting the criteria.
Relationships, field formats, table structure, queries, criteria and reports
all appear to be identical but I can not find the difference that causes
multiple questions of year, month.
Anyone ever seen this or have a clue?
Thanks

 

[Olduke]

I have 2 identical (I think) databases functionally but different data. One
has much more fine-tuning in the report appearance. Select queries filter
records for the desired month and year. One works elegantly after telling it
the month and year number to yield records of interest for a report but the
other, with all the window dressing, asks month and year number over and over
for each record meeting the criteria.
Relationships, field formats, table structure, queries, criteria and reports
all appear to be identical but I can not find the difference that causes
multiple questions of year, month.
Anyone ever seen this or have a clue?
Thanks

Just off the top of my head, it may be that the search criteria you are
entering are working fine for the query, but getting lost between the query
and the report.

Also, check your report to ensure that the text boxes holding the data you
want to print are in fact text boxes and not labels. If they are labels and
they say [Date], this is a prompt for a Date parameter. Hightlight the area
on the report in question and check to top left corner. It should state
Text# or Label#. If it states Label, change it to a text box.

 

[Jon Geiger]

Thanks for the suggestions. Trying to imagine how the criteria could be
lost between query and report, I ran the 2 database queries side by side then
proceeded to the subreport. There I discovered the difference. I had the
wrong record source for one of the subreports. Thanks for your help.
Jon

I have 2 identical (I think) databases functionally but different data. One
has much more fine-tuning in the report appearance. Select queries filter
records for the desired month and year. One works elegantly after telling it
the month and year number to yield records of interest for a report but the
other, with all the window dressing, asks month and year number over and over
for each record meeting the criteria.
Relationships, field formats, table structure, queries, criteria and reports
all appear to be identical but I can not find the difference that causes
multiple questions of year, month.
Anyone ever seen this or have a clue?
Thanks

Just off the top of my head, it may be that the search criteria you are
entering are working fine for the query, but getting lost between the query
and the report.

Also, check your report to ensure that the text boxes holding the data you
want to print are in fact text boxes and not labels. If they are labels and
they say [Date], this is a prompt for a Date parameter. Hightlight the area
on the report in question and check to top left corner. It should state
Text# or Label#. If it states Label, change it to a text box.

 

[Jon Geiger]

Thanks for the suggestions. Trying to imagine how the criteria could be
lost between query and report, I ran the 2 database queries side by side then
proceeded to the subreport. There I discovered the difference. I had the
wrong record source for one of the subreports. Thanks for your help.

I have 2 identical (I think) databases functionally but different data. One
has much more fine-tuning in the report appearance. Select queries filter
records for the desired month and year. One works elegantly after telling it
the month and year number to yield records of interest for a report but the
other, with all the window dressing, asks month and year number over and over
for each record meeting the criteria.
Relationships, field formats, table structure, queries, criteria and reports
all appear to be identical but I can not find the difference that causes
multiple questions of year, month.
Anyone ever seen this or have a clue?
Thanks

Just off the top of my head, it may be that the search criteria you are
entering are working fine for the query, but getting lost between the query
and the report.

Also, check your report to ensure that the text boxes holding the data you
want to print are in fact text boxes and not labels. If they are labels and
they say [Date], this is a prompt for a Date parameter. Hightlight the area
on the report in question and check to top left corner. It should state
Text# or Label#. If it states Label, change it to a text box.