From: "kingston via AccessMonster.com" <u27511@uwe>
Date: Mon, 27 Nov 2006 16:58:54 GMT
In query design mode, all criteria on a single line are processed with AND.
Separate lines are processed with OR. Each field has its own parameter,
although they can be the same. So for field1 you'll have [Parameter1], and
for field2 you'll have [Parameter2]. In your case, both should be on the
same line.
Mozy wrote:
I'm very new to this so forgive this idiotic question.
I've managed to set up a parameter query. However, I don't know how to apply
Boolean operators so that if, for example, "coffee" is in one field and
"report" in the second or third fields, how do I ensure that I get "coffee
report" when I run the query?
Re: Differing results for the same report when run on different pc ... At least each user is opening a separate instance that way. ... then ran the query and got the same results. ... but I don't think that's likely as the 2 machines with the ... The report is based on a query and the query produces the same ... (microsoft.public.access.reports)
Re: Combine data in fields within one table ... Conrad's explanations:... I don't believe I mentioned anything about creating a "separate table each ... query to serve as the source for each report.... All the data in my query is currently in Access and pulled from ... (microsoft.public.access.queries)
Re: Displaying the same data separately on a report ... Unless you have a ridculous table structure (such a separate... just format the date field. ... And I've created a report that groups ... If you can use a single query to get all the desired data, ... (microsoft.public.access.reports)
Re: Creating a report from two different parameter queries ... I may have to add addition table fields to query the data in a meaningful manner to accomplish the report with one query. ... > Do you mean you have two separate queries, and you are trying to include ... (microsoft.public.access.reports)
Re: Field Update "On Close" Event ... Its best to have a separate process for updating records,... and only after the print job is sent do you query the user about updating ... you normally create a separate menu bar and tool bar for your target report... (microsoft.public.access.reports)
