User Support Forum

Hi,

I usually don't do much with custom reports, but I'm trying to do an AP report that basically reports check payments for a given date range. I have my transaction date range showing current dates, yet when I run the report it's giving me 3 or 4 years of data....and I'm only asking for the current month.
Any ideas?
Thanks.

How is the actual query listed on the screen with the big "Run Query" button?

One I just created shows the following and works fine:
(Transaction Date ranges from 01/01/2011 to 01/31/2011)

This was done using the "between two dates" selection on the query builder.

My query looks just like yours does....except with a few additions.

(Transaction Date ranges from 01/01/2011 to 01/31/2011)
and Transaction Type exactly matches Manual Check or Computer Check
and Reference does not contain VOID

This is what my Query screen looks like. It runs fine, it just gives me data all the way back to 2004.

fbcacctg wrote:My query looks just like yours does....except with a few additions.

(Transaction Date ranges from 01/01/2011 to 01/31/2011)
and Transaction Type exactly matches Manual Check or Computer Check
and Reference does not contain VOID

This is what my Query screen looks like. It runs fine, it just gives me data all the way back to 2004.

Try changing it to look like this:

(Transaction Date ranges from 01/01/2011 to 01/31/2011)
and (Transaction Type exactly matches Manual Check or Computer Check)
and (Reference does not contain VOID)

I think that second line may be tripping you up as the system is taking that OR before 'Computer Check' and linking it to the last AND.

The joys of and/or logic and grouping !!

Yep, the problem is a lack of brackets!