Wendy,
If you are trying to capture the LaborHrs from 10/16/00 to 10/22/00, change
the order of the "Then, Else" values like this:
IIF(ClockInDate >= 10/16/00 And ClockInDate <= 10/22/00, LaborHrs, 0)
Regards
Jim Stetter
-----Original Message-----
From: Wendy Pursche [mailto:wpursche@...]
Sent: Friday, October 27, 2000 10:05 AM
To: Vantage egroups list
Subject: [Vantage] RB calculation
I would like to calculate total labor hours per job in a range of dates.
I need to make this a calculated field because the rest of my report is
going to be from a larger date range. This is what I have so far and it
doesn't seem to be working.
IIF(ClockInDate >= 10/16/00 And ClockInDate <= 10/22/00, 0, LaborHrs)
Any ideas?
Wendy Pursche
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...
[Non-text portions of this message have been removed]
eGroups Sponsor
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)
[Non-text portions of this message have been removed]
If you are trying to capture the LaborHrs from 10/16/00 to 10/22/00, change
the order of the "Then, Else" values like this:
IIF(ClockInDate >= 10/16/00 And ClockInDate <= 10/22/00, LaborHrs, 0)
Regards
Jim Stetter
-----Original Message-----
From: Wendy Pursche [mailto:wpursche@...]
Sent: Friday, October 27, 2000 10:05 AM
To: Vantage egroups list
Subject: [Vantage] RB calculation
I would like to calculate total labor hours per job in a range of dates.
I need to make this a calculated field because the rest of my report is
going to be from a larger date range. This is what I have so far and it
doesn't seem to be working.
IIF(ClockInDate >= 10/16/00 And ClockInDate <= 10/22/00, 0, LaborHrs)
Any ideas?
Wendy Pursche
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...
[Non-text portions of this message have been removed]
eGroups Sponsor
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)
[Non-text portions of this message have been removed]