How to write an expression in script ??

[#1]

If 'x' is the table having 'a' & 'b' fields . I need something like,

Comm = .[ a ]*(.[ b ]/100)

How can I write in the script ??

Thanks in advance.

[johnw · Accepted solution]

I believe it decided that "Total" is a file, and it used whatever your current path is to find that file. There's no such file, so it gives you an error. I don't have experience with access databases, but I believe you have to use the SQL keyword to tell it to send the next bit of script to the ODBC driver to pass to the database. Then you load from those results by using a preceeding load. Put it all together, and I think you want something like this:

LOAD [Inside %],
[Total Costs],
([Inside %]*([Total Costs]/100)) AS COMMISSION
;
SQL SELECT Inside %, Total Costs
FROM Total
;

[#3]

Hi John !

Thanks for you reply.

Your solution working like a rocket....

Thanks a lot!