add fields on queried output

[luvbite38]

Hi,

I an running a query on an external DB and showing required fields from Main DB.

Is there a way, I can add few fields which don't exist in main-db in the query.

The additional fields would be calculated (Field Called % Share * Total Profit)?

any ideas please.

Kind Regards,

 

[alansidman]

Look at this:

http://office.microsoft.com/en-us/a...culated-field-in-a-query-mdb-HP005188023.aspx

Alan

 

[luvbite38]

Thank YoU