BAQ for Vendor ID/Name/GL Expense Account

Cancel request......figured it out.

At 03:07 PM 1/7/2010, you wrote:
>
>
>Any suggestions on creating a BAQ based on the
>Vendor table but pulls in the GL Expense Account
>which appears in the display but is not a data element in the vendor table?
>
>



[Non-text portions of this message have been removed]
Any suggestions on creating a BAQ based on the Vendor table but pulls in the GL Expense Account which appears in the display but is not a data element in the vendor table?
Vendor.ExpenseDiv, Vendor.ExpenseDept, and Vendor.ExpenseChart are the fields you want. You could make a calculated field that did something like:

Vendor.ExpenseDiv + "-" + Vendor.ExpenseChart + "-" Vendor.ExpenseDept

If you wanted them all in one string.

-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 Bob
Sent: Thursday, January 07, 2010 3:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ for Vendor ID/Name/GL Expense Account

Any suggestions on creating a BAQ based on the Vendor table but pulls in the GL Expense Account which appears in the display but is not a data element in the vendor table?



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

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