Hi All
I have a query that needs to display:
I am creating a query for reporting that needs to show these values and their associated currencies and be able to total the value columns. So as an example, the data stored would be:
But displayed in the query i would like to see:
Now for different suppliers, transport and customers depending on where they are and what currency they do business in and the such like these currencies will change so its not just a matter of using 1 particular currency for a specific column it is literally based on the preceding field
hope this makes sense, i just need to understand how i format the columns based on the preceding field and make sure that they are still able to be totalled, and that total use the currency.
PLEASE NOTE: as i am aware in writing this that it might seem potentially nonsensical to have multiple currencies possible in the same column and try to total them, the query will return results based on user interaction and only show data that makes sense to total, so bought price will never have GBP and EUR displayed at the same time so the totals will make sense its just that i can't force specific currencies as each time the user queries they may choose a different product/customer/supplier so i need to make it use the currencies associated with the data
kind regards
Glen
I have a query that needs to display:
- Price of bought product
- Total value of bought product
- Price of transport product per kg
- Total value of transport of product
- Price product will be sold at
- Total value of sold product
- Value of customer claim
I am creating a query for reporting that needs to show these values and their associated currencies and be able to total the value columns. So as an example, the data stored would be:
But displayed in the query i would like to see:
Now for different suppliers, transport and customers depending on where they are and what currency they do business in and the such like these currencies will change so its not just a matter of using 1 particular currency for a specific column it is literally based on the preceding field
hope this makes sense, i just need to understand how i format the columns based on the preceding field and make sure that they are still able to be totalled, and that total use the currency.
PLEASE NOTE: as i am aware in writing this that it might seem potentially nonsensical to have multiple currencies possible in the same column and try to total them, the query will return results based on user interaction and only show data that makes sense to total, so bought price will never have GBP and EUR displayed at the same time so the totals will make sense its just that i can't force specific currencies as each time the user queries they may choose a different product/customer/supplier so i need to make it use the currencies associated with the data
kind regards
Glen