Just trying to calculate the percentage difference between budget and amount spent.
I think i have all of the relevant data in the image below
the problem is when i run the query it pops up with
"Enter Parameter Value"
SumofTransAmount
whats odd is the query executes fine if i just click "Ok" my percent values show up as they should
also I can enter any (number) value I want int the the message box and it still executes just fine
not sure if i can explain the query better than the photo but.
tbl_Transactions has all the transaction data including the linked field "TransAccount" which is really just the category of transaction i.e. food, rent, bills, etc.
tbl_budgetFY20 just had a $amount for each TransAccount record (which i think means its a one to one relationship, but I cant seem to get access to change the relationship type)