9.05.702A BAQ Summary question

Yahoo Archive
1
In a BAQ you have to change the table to a summary table and then create a calculated field using an aggregate formula where the output is numeric in value. I’m not sure if that’s what you’re going for with your example. Happy migration to 10 where BAQ’s are closer to real query tools…☺

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, June 10, 2015 12:02 PM
To: Vantage List
Subject: [Vantage] 9.05.702A BAQ Summary question



I am trying to create a BAQ whose resulting values will be used as the source for a combo box on a customization.



The data I need to compile is kept in the Part.UserChar1 field.



In Access/SQL I can do this very simply follows:



SELECT PUB_Part.Company, PUB_Part.UserChar1
FROM PUB_Part
GROUP BY PUB_Part.Company, PUB_Part.UserChar1
HAVING (((PUB_Part.Company)="cli"))
ORDER BY PUB_Part.UserChar1;



I cannot figure out how to do this same thing in a BAQ. I feel like I must be missing something obvious.



Any ideas?







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

I am trying to create a BAQ whose resulting values will be used as the source for a combo box on a customization.


The data I need to compile is kept in the Part.UserChar1 field.Â


In Access/SQL I can do this very simply follows:


SELECT PUB_Part.Company, PUB_Part.UserChar1
FROM PUB_Part
GROUP BY PUB_Part.Company, PUB_Part.UserChar1
HAVING (((PUB_Part.Company)="cli"))
ORDER BY PUB_Part.UserChar1;


I cannot figure out how to do this same thing in a BAQ. I feel like I must be missing something obvious.Â


Any ideas?