General Questions re an Existing Report Creteria Example attached.

[logle0917]

I need to edit some creteria on existing reports. I am confused as to why the creator of these reports put the creteria on several different lines instead of once on one line like in and In (list) or Like or Between Dates. Is there some type of reason for doing this in MS Access or can I do one line Creteria and what would be to purpose of doing it the way that it is shown on the attachment here. Thanks!!!




Lisa

[pbaldy]

No attachment, but in the actual SQL that the query designer creates, items on the same line are separated by "And", while items on different lines are separated by "Or". Big difference in the resulting logic.

[logle0917]

Ima try to add the attachment again I do SQL and looking at the Access Editor in design view does not make sense to me. Why several Date ranges why not just one Between Dates?

[pbaldy]

That is a pretty complicated query, but generally they are trying to achieve:

WHERE (A And Date) Or (A And C)

if the date didn't appear on every line you'd get

WHERE (A And Date) Or (C)

so the date restriction wouldn't be applied along with C. It may help if you visualize that all criteria on the first line must be met, OR all criteria on the second line, etc. If the date wasn't on a given line, it wouldn't be included in the restrictions for that line.

By the way, in SQL view you could write it so it only appeared once, but the design grid will often change it so it can visually represent it to you.

[logle0917]

Thanks that helps! Seems like it would have been simpler to just write this in a SQL Query.

[pbaldy]

Happy to help, and welcome to the site! SQL can be cleaner. The design view is an effort to make SQL more visual for beginners, but it can also confuse matters.