Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 6858 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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...

Posted

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 [ ]

This topic is 6858 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.