Specify which Field in Query Form

K

Kahuna

Hi folks.

I have a query (QBF) which for my own perverse reasons I'd like to keep as
a QBF. However I'd also like to be able to switch which fields are used in
the calculation:

Say I have two fields to be considered in the QBF Labour_cost and
Control_number

If Control_number =1 then

Labour_cost QBF column should have Labour_cost1

If Control_number = 2 then

Labour_cost QBF column should have Labour_cost1
etc.

I know we can do this in a custom function or as an sql string, but it would
be neat to do it in the QBF if there is a way?

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

QBF Query by Form- more than 2 tables? 3
How do I display the results of a query in an existing form? 1
Create a Dynamic Search query 1
Query By Form - Questions 2
Parameter Query Criteria Help 5
Query by form 0
Query Question 5
Security / User Access 1

Top