hello,
i have a query thats outputs my costs on a project divided into 50 categories. additionally, each project can be divided into 3 stages, each with the same 50 cost categories. i have been using a query that prompts the user which stage they would like to look at, and it works great.
however, it would be useful to be able to see all stages at once, next to one another.
so, essentially, i want to be able to input the stage parameter in the criteria box for three fields in the query, so instead of showing the costs for one stage at a time, it will show all three(and a summation across all stages), without a prompt.
it works when i set the one field manually to the first stage, but when i add additional fields, it returns a blank query.
what am i not understanding about ho this is supposed to work.
thanks,
patrick