V8.03.4xx BAQ question

Yahoo Archive
1
Thanks Ken and Brian - just the nudge I needed !!
I searched the 'tools user guide' but did not see it covered in there

bw

--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> You will need to have at least two tables in your query (which you do, but just saying).
>
> Start with Part, and add RcvDtl.
>
> In the Phrase Builder where you define the relations, change the "WhichItem" column in the relation header from "each" (the default), to "last".
>
> Then on the panel where you define the sorting options outside of the relation builder, sort the query on part and then receiptdate in ascending order.
>
> -bws
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
> Â Â Â Â bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of bw2868bond
> Sent: Tuesday, December 01, 2009 10:33 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] V8.03.4xx BAQ question
>
> BAQs are not my forte and I could use a nudge in the right direction.
>
> I want to use the part and rcvdtl tables to return the LAST receiptdate for parts within a part number range
>
> I can set up the BAQ with the tables and set the criteria on the parts.
>
> How do I tell the BAQ to only give me the latest receiptdate?
>
>
>
>
2
BAQs are not my forte and I could use a nudge in the right direction.

I want to use the part and rcvdtl tables to return the LAST receiptdate for parts within a part number range

I can set up the BAQ with the tables and set the criteria on the parts.

How do I tell the BAQ to only give me the latest receiptdate?
3
You will need to have at least two tables in your query (which you do, but just saying).

Start with Part, and add RcvDtl.

In the Phrase Builder where you define the relations, change the "WhichItem" column in the relation header from "each" (the default), to "last".

Then on the panel where you define the sorting options outside of the relation builder, sort the query on part and then receiptdate in ascending order.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of bw2868bond
Sent: Tuesday, December 01, 2009 10:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] V8.03.4xx BAQ question

BAQs are not my forte and I could use a nudge in the right direction.

I want to use the part and rcvdtl tables to return the LAST receiptdate for parts within a part number range

I can set up the BAQ with the tables and set the criteria on the parts.

How do I tell the BAQ to only give me the latest receiptdate?



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
4
After selecting your tables in the phrase builder, you'll go to the table relations table.

On the left side you'll see "each" for WhichItem. Change this to last.

Ken

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of bw2868bond
Sent: Tuesday, December 01, 2009 8:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] V8.03.4xx BAQ question



BAQs are not my forte and I could use a nudge in the right direction.

I want to use the part and rcvdtl tables to return the LAST receiptdate for parts within a part number range

I can set up the BAQ with the tables and set the criteria on the parts.

How do I tell the BAQ to only give me the latest receiptdate?



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