Search results

Thanks that work... i feel stupid how i missed that! cheers mate

doing it in design view

thanks for getting back to me... i know what you are saying and yes it is to populate a report. however my uni prof. wents to check every F@cking table and query to make sure there set up right. its stupid but somthing thats got to be worked out.

what i didn't say was that it needs to be formatted in the quaery itself

I have used an expression build to basically do a tax calculation. its abit like this [Cost ex VAT]*(1+[Valueaddedtax]![VAT]/100). right this should give a value with tax add and it does but not in a currency format? the field isn't in a table so i can't format it like i would do in a table...

Thank you get getting back to me... I can't set it up as a system constant as i have a set specification. I am might to have a table with just the number value in... i just can't understand why i can't access it. Does it have something to do with the data type? Any help?

Thank you get getting back to me... I can't set it up as a system constant as i have a set specification. I am might to have a table with just the number value in... i just can't understand why i can't access it. Does it have something to do with the data type? Any help?

Right basically what i'm tryin to do is .... i have a table tblConstants this has one field in which holds a TAX value. I'm wanting to use the value in the query this is what i have entered using the expression builder Cost inc VAT: [Unit Price]*[No Of Items]*(1+[tblConstants]![VAT]/100)...