The [CrewMembers] field has criteria of Like [Enter Crew Member]
The [CallDate] has criteria of Between [Enter Start Date] and [Enter End Date]
I want to open the query in a report or form - and enter only the CallDate criteria one time - but keep rerunning the query using different criteria for the CrewMember field.
Is this going to be possible? its a pain to keep entering the same CallDate Criteria over and over again....
Re: Populating a list -- table structure? ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ...KitID, long integer ... (microsoft.public.access.forms)
Re: Fields in Label dont give correct information ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report,... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ... (microsoft.public.access.reports)
Re: Tips on domain aggregate replacements ... This already is a split db, but the users are 400 miles away from the server hosting the data:) They are all running the same copy of the FE locally on a single terminal server via TS/RDP sessions. ... It doesn't seem to have much impact on performance; the report takes just about as long to run if they are all logged in as it does when I am logged on testing it at night. ... I would do DSums from the controls on the report on the data returned by the query.... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months (the DSum in VBA was a sideline to this issue) and present these as items on each line of output. ... (microsoft.public.access.modulesdaovba)
Re: using a form with combo box to input criteria ...Candia Computer Consulting - Candia NH ... When you removed the criteria,... Then your criteria in the query would be... ... query behind your main report.... (microsoft.public.access.forms)
Re: using a form with combo box to input criteria ...Candia Computer Consulting - Candia NH ... When you removed the criteria,... Then your criteria in the query would be... ... query behind your main report.... (microsoft.public.access.forms)
