Search results

I've built a report based on queried data that has conditions 1,2,3,4,5,6,7,8. I've now got new data that needs to use the same report but only has conditions 1, 2, and 3 and am getting "No such field in the field list". This makes sense being that 4,5,6,7 and 8 do not exist. My question is...

Hi there, I've inherited a report that is coded to pull specific dates (9/1/YY - 8/31/YY) It's our new year and I can't seem to figure out the notes on updating this. to pull 9/1/2021-8/31/2022. Notes are: "modify the code on the start and end dates by changing the option to Editable and...

How would I format a calculated text box to add parentheses around the number?

Why does the follow sum calculation work but not count within the Q1 parameters? The Count gives me total in my query and ignores the Q1 parameter. =Sum(IIf([Dateasked] Between [Forms]![Prospect Reports Manager]![Q2Start] And [Forms]![Prospect Reports Manager]![Q2End],[Amountasked],0))...