Hi,
I am brand new to Microsoft Access having only a week's worth of experience and I'm finding an issue where my query is producing the desired results but the report is not. More specifically, I'm trying to create a report that allows a user to choose a period in order to retrieve data for that period. The data being retrieved are percentages that are calculated as a line item divided by the total of all line items. This is working when the user, for example, chooses January, but if the user hits refresh and then chooses February, the numerator in the calculations are appropriately from February but the denominator stays as January's and produces the wrong result. The frustrating part is that this works in the queries when refresh is used. Furthermore, if I run January and close the report and then reopen and run February, I get the proper results (i.e. February numerator and denominator). Doesn't a report simply pull data from the query or does it actually perform calculations itself? For some reason it seems to be remembering the January denominator when displaying February results.
I hope this question makes sense. If not, please let me know on what I should expound. Any help would be appreciated. Thank you.