Using multiple criteria when running a report

[kmurtha]

I have a project database that had information broken out as follows

Proj Name
Year
Status
Jan Hours
.
.
.
Dec Hours

I want to run a report and allow the user to select a year and then a Qtr to report on on.

The real problem is that I keep the hours broken down by month, so how do I relate months (ex Jan, Feb, Mar) to a Quarter?

Secondly, how do I prompt a user for multiple criteria for a report (ex: [Please Enter Year]:, [Now Please Enter Quarter]:

Thanks
Kevin

 

[SydneyGeek]

Kevin,

I think you've made life hard for yourself. It would be much easier to query a table that had

Proj Name
Year
Status
Month
Hours

You could then build an expresssion in a query to calculate the Quarter, and use that for filtering the report.

The above could easily be viewed in the Month-across format by using a Crosstab query.

Do you have multiple months filled for each record? And how many queries / forms have you built so far? The reason I ask, is if the database isn't too far down the track, reorganising the data may be easier in the long run.

Otherwise, could you give a bit more info? There may be a way to grab what you need, by building a series of expressions.

Denis