I am using PartRev table only and I want to display all the Approved Revs that are the primary rev for a specific plant.
for each PartRev no-lock where PartRev.Approved = True And PartRev.Plant = 'CIS' And PartRev.AltMethod = '' .
I had to set the Criteria to a specified constant and didn’t enter anything in the specified constant.
Miguel A. Santillan
Compass Manufacturing Systems
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 2, 2016 11:13 AM
To: Vantage <vantage@yahoogroups.com>
Subject: Re: [Vantage] e9: baq cRITERIA
E10? do a Left Join where its null
Jose C Gomez
Software Engineer
T:
904.469.1524 mobile
Quis custodiet ipsos custodes?
On Wed, Mar 2, 2016 at 1:56 PM, Miguel Santillan msantillan@... [vantage] <vantage@yahoogroups.com> wrote:
I want to display only the records with the AltMethod that is blank. How would I setup the criteria.
Miguel A. Santillan
ERP Analyst
Compass Manufacturing Systems
510-661-6666 Office
Disclaimer
The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.
Disclaimer
The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.
