Zero Balance A/P Invoice

Yahoo Archive
61
Charles:

I have a report that shows a summary of the status of each op and assembly
on a job. Would that help you?

Lydia
lcoffman@...

-----Original Message-----
From: Charles Metcalf [mailto:chuck_metcalf@...]
Sent: Thursday, January 11, 2001 12:34 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Report Builder

Todd,

I am trying to find a field that I can put on a status report that will
show where we are on the work order.
Seq Work Center
Operation Status
10 40 Draw Material
20 Cut Complete
20 30 Cnc Machine
30 Profile Complete
30 85 Heat Treat
15 Age

In the above example we would know we were through Machine and the next
work center would be heat treat.

Thanks
Chuck



Chuck,

Specifically what are you trying to determine ? Having never worked with
Classic I'm not sure what you are asking for.

Todd Anderson



In DCD Classic there was a field called Last Operation Worked. Is
there a similiar field in Vantage.
Thanks
Chuck






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.)
62
That report would certainly help me. Could you post it or send it to me
directly?

Thanks,
Kathy Hambleton
Electron Energy Corporation
717-898-2294
kbh@...



-----Original Message-----
From: Lydia Coffman [mailto:lcoffman@...]
Sent: Thursday, January 11, 2001 5:23 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Report Builder


Charles:

I have a report that shows a summary of the status of each op and assembly
on a job. Would that help you?

Lydia
lcoffman@...
63
I cannot remember who pointed me in this direction, but it really
helped. Now I have another question. This formula "SUBSTRING
(MemoText, 1, INDEX(MemoText, CHR(10)))" prints the text in the
MemoText field to the first carriage return. How would the formula be
revised to skip the text before the first carriage return and then
print the text after the first carriage return
64
Chuck,

To extract the text after the first carriage return:

SUBSTRING(MemoText, INDEX(MemoText, CHR(10))+1, LENGTH(MemoText))"

Regards
Jim Stetter
-----Original Message-----
From: Charles Metcalf [mailto:chuck_metcalf@...]
Sent: Friday, January 12, 2001 8:35 AM
To: vantage@egroups.com
Subject: [Vantage] Report Builder


I cannot remember who pointed me in this direction, but it really
helped. Now I have another question. This formula "SUBSTRING
(MemoText, 1, INDEX(MemoText, CHR(10)))" prints the text in the
MemoText field to the first carriage return. How would the formula be
revised to skip the text before the first carriage return and then
print the text after the first carriage return





[Non-text portions of this message have been removed]
65
Charles -

Create two calculated fields
The first field extracts the portion from position 1 to the first carriage
return.

cfFirstPart = "SUBSTRING(MemoText, 1, INDEX(MemoText, CHR(10)))"

The second field extract the portion from the 1st character after the 1st
carriage return to the second carriage return.

cfSecondPart = "SUBSTRING(MemoText, (INDEX(MemoText, CHR(10)) + 1),
INDEX(MemoText, CHR(10), 2))"

HTH,
Calvin


----- Original Message -----
From: Charles Metcalf <chuck_metcalf@...>
To: <vantage@egroups.com>
Sent: Friday, January 12, 2001 7:35 AM
Subject: [Vantage] Report Builder


> I cannot remember who pointed me in this direction, but it really
> helped. Now I have another question. This formula "SUBSTRING
> (MemoText, 1, INDEX(MemoText, CHR(10)))" prints the text in the
> MemoText field to the first carriage return. How would the formula be
> revised to skip the text before the first carriage return and then
> print the text after the first carriage return
>
>
>
>
>
> 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.)
66
Charles,

I'm sorry but I've been out with eye surgery since last Wednesday. I
made several job status reports which I have shared with others. We
have a Job Structure report which shows how the job is structured when
released. We have a Shortage Report which shows the job status by
assembly, operation and material. When an assembly, operation and/or
material requirement is met, that item drops off the list. If the job
is shown as complete in data entry and the quantity is less than
required, the item stays on the report. Let me know if you would like
one or more of these offline and I will send them to you.

Steve

-----Original Message-----
From: Charles Metcalf [SMTP:chuck_metcalf@...]
Sent: Thursday, January 11, 2001 3:34 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Report Builder

Todd,

I am trying to find a field that I can put on a status report
that will
show where we are on the work order.
Seq Work Center
Operation Status
10 40 Draw
Material 20 Cut Complete
20 30 Cnc
Machine 30 Profile Complete
30 85 Heat
Treat 15 Age

In the above example we would know we were through Machine and
the next
work center would be heat treat.

Thanks
Chuck



Chuck,

Specifically what are you trying to determine ? Having never
worked with
Classic I'm not sure what you are asking for.

Todd Anderson



In DCD Classic there was a field called Last Operation Worked.
Is
there a similiar field in Vantage.
Thanks
Chuck






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.)
67
I would love to see these reports. Could you send them to me offline?

Thanks
Todd Hofert
Spartan Graphics, Inc.
(616)887-8243


-----Original Message-----
From: Steve Wirtz [mailto:SWirtz@...]
Sent: Monday, January 15, 2001 8:39 AM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] Report Builder


Charles,

I'm sorry but I've been out with eye surgery since last Wednesday. I
made several job status reports which I have shared with others. We
have a Job Structure report which shows how the job is structured when
released. We have a Shortage Report which shows the job status by
assembly, operation and material. When an assembly, operation and/or
material requirement is met, that item drops off the list. If the job
is shown as complete in data entry and the quantity is less than
required, the item stays on the report. Let me know if you would like
one or more of these offline and I will send them to you.

Steve

-----Original Message-----
From: Charles Metcalf [SMTP:chuck_metcalf@...]
Sent: Thursday, January 11, 2001 3:34 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Report Builder

Todd,

I am trying to find a field that I can put on a status report
that will
show where we are on the work order.
Seq Work Center
Operation Status
10 40 Draw
Material 20 Cut Complete
20 30 Cnc
Machine 30 Profile Complete
30 85 Heat
Treat 15 Age

In the above example we would know we were through Machine and
the next
work center would be heat treat.

Thanks
Chuck



Chuck,

Specifically what are you trying to determine ? Having never
worked with
Classic I'm not sure what you are asking for.

Todd Anderson



In DCD Classic there was a field called Last Operation Worked.
Is
there a similiar field in Vantage.
Thanks
Chuck






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

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.)
68
I would also like to take a look at these reports. Will they be posted?

Les Tingley
Decorated Products

> -----Original Message-----
> From: Todd Hofert [SMTP:thofert@...]
> Sent: Monday, January 15, 2001 8:53 AM
> To: vantage@egroups.com
> Subject: RE: [Vantage] Report Builder
>
> I would love to see these reports. Could you send them to me offline?
>
> Thanks
> Todd Hofert
> Spartan Graphics, Inc.
> (616)887-8243
>
>
> -----Original Message-----
> From: Steve Wirtz [mailto:SWirtz@...]
> Sent: Monday, January 15, 2001 8:39 AM
> To: 'vantage@egroups.com'
> Subject: RE: [Vantage] Report Builder
>
>
> Charles,
>
> I'm sorry but I've been out with eye surgery since last Wednesday. I
> made several job status reports which I have shared with others. We
> have a Job Structure report which shows how the job is structured when
> released. We have a Shortage Report which shows the job status by
> assembly, operation and material. When an assembly, operation and/or
> material requirement is met, that item drops off the list. If the job
> is shown as complete in data entry and the quantity is less than
> required, the item stays on the report. Let me know if you would like
> one or more of these offline and I will send them to you.
>
> Steve
>
> -----Original Message-----
> From: Charles Metcalf [SMTP:chuck_metcalf@...]
> Sent: Thursday, January 11, 2001 3:34 PM
> To: vantage@egroups.com
> Subject: RE: [Vantage] Report Builder
>
> Todd,
>
> I am trying to find a field that I can put on a status report
> that will
> show where we are on the work order.
> Seq Work Center
> Operation Status
> 10 40 Draw
> Material 20 Cut Complete
> 20 30 Cnc
> Machine 30 Profile Complete
> 30 85 Heat
> Treat 15 Age
>
> In the above example we would know we were through Machine and
> the next
> work center would be heat treat.
>
> Thanks
> Chuck
>
>
>
> Chuck,
>
> Specifically what are you trying to determine ? Having never
> worked with
> Classic I'm not sure what you are asking for.
>
> Todd Anderson
>
>
>
> In DCD Classic there was a field called Last Operation Worked.
> Is
> there a similiar field in Vantage.
> Thanks
> Chuck
>
>
>
>
>
>
> 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.)
>
> 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.)
>
>
> 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.)
69
We tried to post the job shortage report once before but they (E-groups)
had some problems with it so I have sent it directly to others. I wish
they would help me try again. I'm off to a meeting so I will send
later.

Steve

-----Original Message-----
From: Les Tingley [SMTP:ltingley@...]
Sent: Monday, January 15, 2001 9:02 AM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] Report Builder

I would also like to take a look at these reports. Will they be
posted?

Les Tingley
Decorated Products

> -----Original Message-----
> From: Todd Hofert [SMTP:thofert@...]
> Sent: Monday, January 15, 2001 8:53 AM
> To: vantage@egroups.com
> Subject: RE: [Vantage] Report Builder
>
> I would love to see these reports. Could you send them to me
offline?
>
> Thanks
> Todd Hofert
> Spartan Graphics, Inc.
> (616)887-8243
>
>
> -----Original Message-----
> From: Steve Wirtz [mailto:SWirtz@...]
> Sent: Monday, January 15, 2001 8:39 AM
> To: 'vantage@egroups.com'
> Subject: RE: [Vantage] Report Builder
>
>
> Charles,
>
> I'm sorry but I've been out with eye surgery since last
Wednesday. I
> made several job status reports which I have shared with
others. We
> have a Job Structure report which shows how the job is
structured when
> released. We have a Shortage Report which shows the job
status by
> assembly, operation and material. When an assembly, operation
and/or
> material requirement is met, that item drops off the list. If
the job
> is shown as complete in data entry and the quantity is less
than
> required, the item stays on the report. Let me know if you
would like
> one or more of these offline and I will send them to you.
>
> Steve
>
> -----Original Message-----
> From: Charles Metcalf
[SMTP:chuck_metcalf@...]
> Sent: Thursday, January 11, 2001 3:34 PM
> To: vantage@egroups.com
> Subject: RE: [Vantage] Report Builder
>
> Todd,
>
> I am trying to find a field that I can put on a status
report
> that will
> show where we are on the work order.
> Seq Work
Center
> Operation Status
> 10
40 Draw
> Material 20 Cut Complete
> 20
30 Cnc
> Machine 30 Profile Complete
> 30
85 Heat
> Treat 15 Age
>
> In the above example we would know we were through
Machine and
> the next
> work center would be heat treat.
>
> Thanks
> Chuck
>
>
>
> Chuck,
>
> Specifically what are you trying to determine ? Having
never
> worked with
> Classic I'm not sure what you are asking for.
>
> Todd Anderson
>
>
>
> In DCD Classic there was a field called Last Operation
Worked.
> Is
> there a similiar field in Vantage.
> Thanks
> Chuck
>
>
>
>
>
>
> 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.)
>
> 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.)
>
>
> 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.)

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.)
70
Would you mind sending them to me too?
Thanks
Sophie

> -----Original Message-----
> From: Todd Hofert [SMTP:thofert@...]
> Sent: 15 January 2001 13:53
> To: vantage@egroups.com
> Subject: RE: [Vantage] Report Builder
>
> I would love to see these reports. Could you send them to me offline?
>
> Thanks
> Todd Hofert
> Spartan Graphics, Inc.
> (616)887-8243
>
>
> -----Original Message-----
> From: Steve Wirtz [mailto:SWirtz@...]
> Sent: Monday, January 15, 2001 8:39 AM
> To: 'vantage@egroups.com'
> Subject: RE: [Vantage] Report Builder
>
>
> Charles,
>
> I'm sorry but I've been out with eye surgery since last Wednesday. I
> made several job status reports which I have shared with others. We
> have a Job Structure report which shows how the job is structured when
> released. We have a Shortage Report which shows the job status by
> assembly, operation and material. When an assembly, operation and/or
> material requirement is met, that item drops off the list. If the job
> is shown as complete in data entry and the quantity is less than
> required, the item stays on the report. Let me know if you would like
> one or more of these offline and I will send them to you.
>
> Steve
>
> Â Â Â Â Â -----Original Message-----
> Â Â Â Â Â From:Â Â Â Â Â Charles Metcalf [SMTP:chuck_metcalf@...]
> Â Â Â Â Â Sent:Â Â Â Â Â Thursday, January 11, 2001 3:34 PM
> Â Â Â Â Â To:Â Â Â Â Â vantage@egroups.com
> Â Â Â Â Â Subject:Â Â Â Â Â RE: [Vantage] Report Builder
>
> Â Â Â Â Â Todd,
>
> Â Â Â Â Â Â I am trying to find a field that I can put on a status report
> that will
> Â Â Â Â Â show where we are on the work order.
>                     Seq               Work Center
> Operation        Status
> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 10Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 40 Draw
> Material          20 Cut     Complete
> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 20Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 30 Cnc
> Machine          30 Profile     Complete
> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 30Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 85 Heat
> Treat          15 Age
>
> Â Â Â Â Â Â In the above example we would know we were through Machine and
> the next
> Â Â Â Â Â work center would be heat treat.
>
> Â Â Â Â Â Thanks
> Â Â Â Â Â Chuck
>
>
>
> Â Â Â Â Â Chuck,
>
>      Specifically what are you trying to determine ? Having never
> worked with
> Â Â Â Â Â Classic I'm not sure what you are asking for.
>
> Â Â Â Â Â Todd Anderson
>
>
>
> Â Â Â Â Â In DCD Classic there was a field called Last Operation Worked.
> Is
> Â Â Â Â Â there a similiar field in Vantage.
> Â Â Â Â Â Thanks
> Â Â Â Â Â Chuck
>
>
>
>
>
>
>      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.)
>
> 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.)
>
>
>
> eGroups Sponsor
> Click Here!
> <http://rd.yahoo.com/M=169066.1281467.2883016.2/D=egroupmail/S=1700007
> 183:N/A=560430/*http://cgi.pathfinder.com/cgi-bin/magsubs/cc/subs/fort
> uneext1rf?EFFORTKEY=FOBTGJ4>
>
> 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.)
>
71
I would like a copy of this offline also please.
Thanks,

Kimberly Maxwell
Westwood Precision, Inc.
PH: 425-347-1303 Ext. 41
Fax: 425-353-8945
email: kimberly.maxwell@...
www.westwoodprecision.com

> -----Original Message-----
> From: Steve Wirtz [mailto:SWirtz@...]
> Sent: Monday, January 15, 2001 8:39 AM
> To: 'vantage@egroups.com'
> Subject: RE: [Vantage] Report Builder
>
>
> Charles,
>
> I'm sorry but I've been out with eye surgery since last
Wednesday. I
> made several job status reports which I have shared with
others. We
> have a Job Structure report which shows how the job is
structured when
> released. We have a Shortage Report which shows the job
status by
> assembly, operation and material. When an assembly, operation
and/or
> material requirement is met, that item drops off the list. If
the job
> is shown as complete in data entry and the quantity is less
than
> required, the item stays on the report. Let me know if you
would like
> one or more of these offline and I will send them to you.
>
> Steve
72
Hi,
I would love to see this report.
Thanks,
Judy Stauduhar
Taber Bushnell
judys@...


From: Steve Wirtz [mailto:SWirtz@...]
Sent: Monday, January 15, 2001 8:39 AM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] Report Builder


Charles,

I'm sorry but I've been out with eye surgery since last Wednesday. I
made several job status reports which I have shared with others. We
have a Job Structure report which shows how the job is structured when
released. We have a Shortage Report which shows the job status by
assembly, operation and material. When an assembly, operation and/or
material requirement is met, that item drops off the list. If the job
is shown as complete in data entry and the quantity is less than
required, the item stays on the report. Let me know if you would like
one or more of these offline and I will send them to you.

Steve
73
When you use conditional printing, what determines whether the
conditional printing choices are "True/False" or "Print When Field
has contents/Print When Field is Empty or Unknown", and can you
change them some how.
Thanks
Chuck
74
What determines whether the choices in conditional printing
are "True/False" or "Print when field has contents/Print when field
in empty or unknown" and can you change the selection??
Thanks
Chuck
75
You can create a calculated field to determine the parameters of the
"TRUE/FALSE" condition. Then reference the calculated field in the
condition area.

Shirley Graver
(End User)
Sys Admin
Rubber associates Inc.
Cleveland/Akron

-----Original Message-----
From: chuck_metcalf@... [mailto:chuck_metcalf@...]
Sent: Friday, January 26, 2001 2:55 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder


What determines whether the choices in conditional printing
are "True/False" or "Print when field has contents/Print when field
in empty or unknown" and can you change the selection??
Thanks
Chuck


eGroups Sponsor

www.




To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com





[Non-text portions of this message have been removed]
76
At 02:51 PM 1/26/2001 , you wrote:
>When you use conditional printing, what determines whether the
>conditional printing choices are "True/False" or "Print When Field
>has contents/Print When Field is Empty or Unknown", and can you
>change them some how.

I think it's based on the data type of the field that you've selected in
the combo box. If the field is a boolean (true/false, yes/no) then it's
taken directly as such. For other types, like string, non-null = true,
null = false. For numeric, non-zero = true, zero = false. In addition,
all Progress data types can have an "unknown" value which is treated as false.

-Wayne
77
Chuck, the choice of "True/False" or "Has contents/empty" changes with
the type of field you use as the condition. For example; if the field is a
character field then has contents/empty shows; if numeric you see
zero/nonzero; if logical you see True/False. You decide what field to use
as the conditional trigger to print or not print. I use this feature all the
time. One of the ways I use this feature is to control whether a subtotal
line prints. To do this, I have an aggregate (linecount) that counts the
number of details printed in the group, then have a calculated field
PrintSubTotal = iif(linecount=1,false,true). The "PrintSubTotal" goes in
the conditional print box field and I check True. Result -- if only 1
detail line in the group, I don't show a subtotal. Hope this helps.

Regards
Jim Stetter
-----Original Message-----
From: chuck_metcalf@... [mailto:chuck_metcalf@...]
Sent: Friday, January 26, 2001 2:55 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder


What determines whether the choices in conditional printing
are "True/False" or "Print when field has contents/Print when field
in empty or unknown" and can you change the selection??
Thanks
Chuck


eGroups Sponsor

www.




To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com





[Non-text portions of this message have been removed]
78
I keep seeing messages about running report builder reports automatically. Can someone give me the exact syntax for a batch file or whatever is needed to accomplish this, and also how do you call out a specific library and report?
79
Wayne Cox wrote:

> At 02:51 PM 1/26/2001 , you wrote:
> <snip>

> In addition,
> all Progress data types can have an "unknown" value which is treated as false.
>

Not quit true. It is neither true nor false. However, testing any value against an
unknown will always return a false value; except if you compare one unknown
against another unknown, you will get a true result. Also note ( we are getting
kind of esoteric here) you can have multiple unknowns in a unique index, since
each unknown is considered to be itself unique. Unknown sort high.

There will now be a short pause while everyone says --- Who Cares?.

--
/* ============================================================== */

William E. Colls Tel 613 591 0079
PROComputer Systems Fax 613 591 3924
67 Willow Glen Dr www.procomsys.com
Kanata Ontario Canada PEG Member 1998051404

Specialists in Progress Software development since 1985
80
I need help on a formula: My data looks like this;

PromDate Part# ProdQty QtyDue Inv Value
2/9/01 12345 7 6 0
? 23456 0 5 15
3/1/01 45678 8 7 0
? 56789 0 8 10

I would like the value "Calculated Field in my report is ValueDate"
to show up if the PromDate is before 2/28/01, or if the unknown value
is in the PromDate, but there is enough inventory to support the
QtyDue.

Any help would be appreciated.

Chuck