Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
how do I enter query criteria only once?
After clearing the parameters for each query, and making sure the grouping levels didn't have any date references, And, changing one of the fields from Report # to Report Number (I guess Access doesn't like the # sign) I finaly got the bloody thing to work! Thanks everyone, especially Imhoteb...- mattock7
- Post #10
- Forum: Microsoft: Access Other topics
-
how do I enter query criteria only once?
Sorry Raskew, I still get prompted seperately for each query. I did find something interesting, though, when experimenting with Imhoteb's recomendation- After entering the criteria once into a form- I still get prompted for each criteria in each query- however: if I leave the subsequent...- mattock7
- Post #7
- Forum: Microsoft: Access Other topics
-
how do I enter query criteria only once?
That sounded like a great idea, and I did create a form that automatically pops up when I run the report. It allows me to enter start and end date info, and the queries on the report are pointed at the form for their criteria. However, when I run the report, it still prompts for each start and...- mattock7
- Post #5
- Forum: Microsoft: Access Other topics
-
how do I enter query criteria only once?
The problem is, i need to summarize the information in the same field several different ways. The only way I could figure out how to do so was with seperate queries. Is it possible to summerize the same field in different ways within the same query?- mattock7
- Post #3
- Forum: Microsoft: Access Other topics
-
how do I enter query criteria only once?
I created a report with 6 sub-reports. Each sub report pulls from a different query, but each of these queries draw from one main query, which prompts for start/end date criteria. I want to use the same start/end date criteria for all of the sub-reports. When I open the report, it askes for...- mattock7
- Thread
- Replies: 9
- Forum: Microsoft: Access Other topics
