C
Cesar
Hi,
I'm using a query to pull data from a SQL database, I have some criteria on
it as Date. I need to create a new field multiplying the sales value times
the % of commission but the problem is that the % of Commision is not a value
in a table or field, is a changable value that I need to be asked every time
I run the query, kind in the same way I am asked for the Date (criteria). Is
there a way to do it here in the query or do I have to do it with code in
excel?
please help
I'm using a query to pull data from a SQL database, I have some criteria on
it as Date. I need to create a new field multiplying the sales value times
the % of commission but the problem is that the % of Commision is not a value
in a table or field, is a changable value that I need to be asked every time
I run the query, kind in the same way I am asked for the Date (criteria). Is
there a way to do it here in the query or do I have to do it with code in
excel?
please help