By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,751 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Access error: parameter value for field

P: 2
I am creating what I think should be an easy form, but I guess it isn't that easy for a beginner. I have a sum of impressions and a sum of clicks and need to create a column that gives the click thru rate. I put =[Sum Of Clicks]/[Sum of Impressions] in that column. (With CTR as the field name and Var in the total cell). Now it is asking for a parameter value for the Sum Of Clicks and I'm not sure what to put. (This is probably a piece of cake for others, but not yet for me.)
Oct 13 '11 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 10K+
P: 12,347
What that means is that there's no field called [Sum Of Clicks].
Oct 13 '11 #2

Expert Mod 15k+
P: 31,344
If you've built this from a query designed in Access there's a good chance you're really looking for [SumOfClicks] instead I would guess.
Oct 14 '11 #3

P: 2
I got my answer. Thanks for your input. My coworker helped me.
I made my 1st query determine the total impressions and clicks.
The 2nd query determined the click through rate on those totals.
The 3rd query determined the click through rate on the sum of the totals.
Then the report shows all of the needed numbers. It was much more complicated than I thought it would be, but division isn't one of the options that is offered when creating the queries.
We are also going to try creating an extra field on the report to do the division once.
Oct 14 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.