Re: Unwanted Parameters Show Up ina Report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello Allen:

Thank you so much for your response, you were right on the money. I checked
the Sorting/Grouping and I was grouping on a field called [YR] which I had
changed to [YEAR]. When I made that change, the parameters box no longer
showed up.

What's the relationship between referencing an incorrect field and the
Parameters dialog box showing up?

Thanks,
RT

"Allen Browne" wrote:

In report design view, open the Sorting and Grouping dialog (View menu), and
have a peek there.

Then open the Properties dialog (View menu). Make sure you are seeing the
properties of the report (not of a text box.) On the Data tab, clear the
Filter and Order By properties, and confirm that the RecordSource is the
query you think it is.

If you are still stuck, it must be the Name or part of the ControlSource of
a control.

Or possibly Access is confused about what a field used to be named. You can
eliminate this possibility by unchecking the Name AutoCorrect boxes under:
Tools | Options | General
and compacting the database.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Robert T" <RobertT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:35D4D4A4-E9CE-4F1B-B01D-33B173B862BB@xxxxxxxxxxxxxxxx
Hello:

I had an old report wherein I changed the source and developed a new
query.
The query worked perfectly when it runs by itself. However, when I run the
report, it prompts me for a year parameter. I checked everywhere and could
not find any parameters in the query. As I said before, the query works
perfectly outside of the report.

I then built a new report using the same exact query and it worked
flawlessly without any parameters popping up. That told me the parameter
issue was with the report. Where do I look to find that annoying parameter
and how can I get rid of it?

Thanks,
RT



.

Relevant Pages

  • Re: Recording the frequency of Yes/No Fields
    ... Create a query. ... That will eliminate all the records where the number as zero. ... Or you can put a text box on the report if you wish. ... Tips for Access users - http://allenbrowne.com/tips.html ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: #error and #name?
    ... Also, make sure the sum is in the a group or report footer, not the Page ... > the report is linked to a query, and contains text fields to display each ... > I have also tried ControlSource = sumbut in both cases I ...
    (microsoft.public.access.reports)
  • Re: Date calculation in query
    ... and an outer join. ... Tips for Access users - http://allenbrowne.com/tips.html ... I want this query to be based solely on ... the "run report" button, it would automagically generate a report ID, ...
    (microsoft.public.access.queries)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)