BAQ 6.1 Blank Title 77131

Yahoo Archive
1
Try <Part.ProdCode Begins 'I'>

Allen Tucker
IT Manager
Espey Mfg. & Electronics Corp.
Email: atucker@...


--- In vantage@yahoogroups.com, "dwestzero" <dwest@...> wrote:
>
> Hi All
> I need to write a BAQ that finds all parts with a ProdCode STARTING with I.
> in Access I would use Part.ProdCode like "I*"
>
> Can't seem to get this to work here.
> any ideas?
>
> for each Part Where Part.Company = cur-comp
> and Part.company = 'manu'
> and Part.ProdCode = "I" no-lock
> BY Part.PartNum:
>
> Is there a good web reference for this any where?
>
> cheers for any thoughts
> Dave
>
2
Hi All
I need to write a BAQ that finds all parts with a ProdCode STARTING with I.
in Access I would use Part.ProdCode like "I*"

Can't seem to get this to work here.
any ideas?

for each Part Where Part.Company = cur-comp
and Part.company = 'manu'
and Part.ProdCode = "I" no-lock
BY Part.PartNum:

Is there a good web reference for this any where?

cheers for any thoughts
Dave