BAQ Search Adding Fields

Yahoo Archive
1
You should be able to just use a Selection Criteria exactly as you
describe........Gary

--- In vantage@yahoogroups.com, "laidig.systems" <laidig.systems@...>
wrote:
>
> I am trying to create a part search to display all parts where Avg
> Cost is > 0. Is there a way to do this? I made a BAQ to add the Avg
> costs together and display them in a calculated field but when using
> quick searches, you cannot place any criteria against calculated
> fields. Does anyone else have a possible solution?
>
2
I am trying to create a part search to display all parts where Avg
Cost is > 0. Is there a way to do this? I made a BAQ to add the Avg
costs together and display them in a calculated field but when using
quick searches, you cannot place any criteria against calculated
fields. Does anyone else have a possible solution?
3
> I am trying to create a part search to display all parts where Avg
> Cost is > 0. Is there a way to do this? I made a BAQ to add the Avg
> costs together and display them in a calculated field but when using
> quick searches, you cannot place any criteria against calculated
> fields. Does anyone else have a possible solution?

Couldn't you make a condition if any of the avg cost fields are greater than
zero then the avg cost is going to be greater than zero?

Mark W.
4
Quite true. I'm really not sure why i didn't think of that. Thanks
for being an extra pair of eyes!


--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> > I am trying to create a part search to display all parts where Avg
> > Cost is > 0. Is there a way to do this? I made a BAQ to add the Avg
> > costs together and display them in a calculated field but when using
> > quick searches, you cannot place any criteria against calculated
> > fields. Does anyone else have a possible solution?
>
> Couldn't you make a condition if any of the avg cost fields are
greater than
> zero then the avg cost is going to be greater than zero?
>
> Mark W.
>
5
> Quite true. I'm really not sure why i didn't think of that. Thanks
> for being an extra pair of eyes!

Or in my case, four eyes...

I agree that it would be a nice feature to be able to select on calculated
fields as well...

Mark W.