February 15, 200620 yr Hi, after all, I'm here again, asking your help... I have a database with account names and dates and hours. Every day I create a new record putting the current date and hour to control the time of one person that have one account name. But I have to make a report and I want to view only records of one Account Name (example: Everton) and all dates that I've been inserted by using date ranges. Like this: Account: Everton StartDay: 08/02/2006 EndDay: 10/02/2006 FIND By clickin in find, this will return all records like this: Everton - 08/02/2006 Everton - 09/02/2006 Everton - 10/02/2006 I have writen this script: Enter Find Mode[] Insert Calculated Result [select; GetAsText (Database::StartDay) & "..." & GetAsText (Database::EndDay)] Perform Find [] I need the part of the script that returns only records from user "Everton"... Can you help me please???! Thank you very much...
February 15, 200620 yr Why use Constrain, when it can be done all in one stage: Enter Find Mode [ ] Set Field [ Date ; gStartDay & ".." & gEndDay ] Set Field [ Account ; gAccount ] Perform Find [ ]
Create an account or sign in to comment