Help with a report

E

Eric

Hi everyone. I am hoping someone can help me here.

I have created a report in which it gives us complaints by
quarter. This works great. What one of the requirements
was to be able to have our Goal FSRs and Actual FSR's on
the report. This is where I am having trouble.

So far I have created a table that the user will have to
manually update. I have made a table called tblFSRGoal and
put in fields like Quarter, GoalFSR, and ActualGoal.

I used a query to calculate if they qualify or not:

SELECT tblFSRGoal.*, IIf([tblFSRGoal].[GoalFSR]>=
[tblFSRGoal].[ActualGoal],"Y","N") AS Qualify
FROM tblFSRGoal;

Now, I have created a form that the user selects a report
via a radio button, inputs dates, and clicks on a button
to run the report. What I want to do is for a certain
report: grab the start date, see which quarter it is, run
my query, then put the results of that quarter in the
report. How do I do this?
 
Top