# BAQ Search Adding Fields

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?
>
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?
> 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.
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.
>
> 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.