Mashulace
10-14-2009, 02:09 AM
I'm doing a fairly simple little query here:
http://imgur.com/xpBCF.png
Basic idea, as outlined above, is that I've got one field (Job Value, a number) divided by 100, and the result multiplied by a different field (calculated by the query). For some reason I can't fathom, I'm being asked for a value for the calculated field.
http://imgur.com/kb7ov.png
Anyone take a guess at why it's doing this? If I delete the field I'm working on, it stops asking, so I'm fairly certain that's where the problem lies.
Here's the field in question:
Total: ([Job Value]/100)*[Percent]
http://imgur.com/xpBCF.png
Basic idea, as outlined above, is that I've got one field (Job Value, a number) divided by 100, and the result multiplied by a different field (calculated by the query). For some reason I can't fathom, I'm being asked for a value for the calculated field.
http://imgur.com/kb7ov.png
Anyone take a guess at why it's doing this? If I delete the field I'm working on, it stops asking, so I'm fairly certain that's where the problem lies.
Here's the field in question:
Total: ([Job Value]/100)*[Percent]