ms access - How to find parameter value -


situation: have report based on query. query not have parameter values need entered. yet when open report, asks me parameter values.

question: how can find out part of report access needs these values?

i've been searching on web, can find references query parameters, i've said, don't have.

i managed solve missing parameters problem using following 2 strategies:

  1. entered fake variable ("xxxxxxxxxx") parameter, spot in preview version of report (once realized form was, realized particular form had small light green triangle in upper left hand corner indicating error)

  2. i used database documenter object definitions report subreport included. in report saw there expression included report grouping function. didn't show anywhere else!

hope helps else!


Comments

Popular posts from this blog

python - No exponential form of the z-axis in matplotlib-3D-plots -

php - Best Light server (Linux + Web server + Database) for Raspberry Pi -

c# - "Newtonsoft.Json.JsonSerializationException unable to find constructor to use for types" error when deserializing class -