Multicalculated Query Help

[ssanfu]

Try changing "NextInt" to:

NextInt: IIf(Int([OverallComplete]+1)>100,100,[OverallComplete]+1)

As to the report, in the report I created, "Copy Of All Game Completion", you are trying to display data from a field (from the query) that doesn't exist.
You changed the field names in the 2nd query from what I had named them.
Not a problem , but if you change a field name in the record source, you must also change the control source name for the control that uses that renamed field.
Sometimes the easiest way to fix a problem like this is to delete the control, then recreate the control.




BTW, you shouldn't use spaces in object names. Only letters, numbers and/or the underscore.

[Fuhgawz]

IIF that's why it wasn't working for me. I was trying IF.

Ill figure out the reports at some point. I can get the information I need from the queries for now. Thanks for your help.