Only Yes to show in report

[bigcraigie]

Hi, I was trying to create what i thought was a simple query in Access- in a list of objects (some duplicate) with dates, I added an 'Active' column. In the report I only want to show 'active' objects which will be checked in the check box. I have tooked through the forums but none of the suggestions seem to work? Iam quite new to this , I have Group by in Total row, unchecked show, and have tried not null and 1 in the criteria row.
Cheers

 

[tehNellie]

You can simply use YES and NO in your criteria (no quotes)

TRUE/YES in an Access yes/no data type evaluates to -1, no idea why.

 

[bigcraigie]

Re: Only Yes to show in report part 2

Ok guys, I've managed to filter it using Yes or No instead of a tick box, I've even managed to save an import path from updated information on Excel - now, if I have one client, and an updated payment, I only want to show the client once with the last payment. I tried putting 'last' in the total row (in this case the 2nd row) but it still shows the previous one when I run it?

 

[vbaInet]

TRUE/YES in an Access yes/no data type evaluates to -1, no idea why.

Yes = -1 and No = 0
It's not a Boolean data type. It's just an Integer data type Formatted as Yes/No.

 

[vbaInet]

Re: Only Yes to show in report part 2

now, if I have one client, and an updated payment, I only want to show the client once with the last payment. I tried putting 'last' in the total row (in this case the 2nd row) but it still shows the previous one when I run it?

I suspect this could lead to more questions being asked in order to understand your structure. You will need to ask this question in a new thread. Questions not related to your subject need to be asked in their own threads.