Joined: 19 May 2011
Online Status: Offline
Posts: 106
Topic: suppressing combined fields Posted: 21 Sep 2015 at 7:42am
I have a report with a name field and two date fields. I am trying to create a formula where it will suppress the detail section if the name field and date1 field equals the name field and date2 field. I have tried converting the date field to text and then used:
({Table1.Name} & {Table1.Date_Volunteered}) = ({Table1.Name} & {Table1.Date_Cleared}) along with a few other variations but it didn't work. Any ideas
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 23 Sep 2015 at 6:17am
If you are pulling all of the data from the same table (which is what your example looks like), you don't need to compare the name, just the dates. So try just
{Table1.Date_Volunteered} = {Table1.Date_Cleared}
Another thing you could do instead of suppressing sections is to use the Record Select to filter out the records completely - add the formula above to the formula in the Select Expert.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
