Search results

Ah, gee. That's brilliant, thanks. I had that relationship: vat_rate ID to Vat rate, but was convinced it was wrong because it was the ID number that was being calculated instead of the vat rate. I see in the invoice table now that sites, customers and vat rates are all ID numbers rather...

Been sat puzzling over this for hours and still not got it. I'm now using a form to input the VAT rate and it's clear that, whilst the vat rate is displaying in the table, the query is using the vat rate ID as has been said and I can't see where I'm going wrong. It won't beat me though, I...

Ok, I will try that.

Struggling to get this. I will get there but I keep getting the vat rate id returned. The relationship looks fine but I'm clearly missing something

I think the penny is dropping. I am now trying to create the correct relationship between the two tables...

Ha! I knew it was that vat rate! So it's the vat rate rounding first and then the query calculating the rounded figure? I will try and fix it.

It's almost two years since I registered here so about time I introduced myself. I work in the licensed trade, pubs, clubs, hotels etc., and have found databases a great tool. I first started asking dumb questions about a stock control utility back in 2008 and it was up and running fairly...

So reading that link lookup fields = bad. What is the alternative?

Thanks for your time on this by the way; it's appreciated.

I've exported the tables and query to a new DB. The problem is still there and more convinced now that it is the vat rate that is the problem.

That's right, it should be the same. There is no sub-query, the VAT rates are input straight into the table by a vat rate form. From there, there is a lookup field in the invoice table to pull in the appropriate vat rate. I think I'm doing something dumb with the vat rate number, but I can't...

That rounds it to £2.60.

Here goes, see if this uploads ok. I have the calculation: VAT Amount: [Subtot]*[VAT_Rate]/100

That doesn't help, though thanks for looking. I can do the maths regarding vat, this is a different issue I think. Access is rounding the number calculated up and I can't see why. If I calculate vat off the subtotal directly rather than the vat rate number pulled from another table it works...

I should say that I've had no problems with this before but have hard coded the vat rate in the past. That proved to be a mistake, and a royal pain in the butt to get over, so this time I'm trying to do the thing properly. I'm suspicious of the 'vat rate' number.

It's calculated by the total. So I have an amount, less discount = subtotal, subtotal x vat rate theoretically equals vat amount

I'm sure this has been asked before, but I have searched and can't find the answer. I'm writing a simple invoicing utility but want the VAT rate to be variable. I have: tbl_invoice and tbl_vatrate. The VAT rate in the invoice table looks the rate of from the VAT table. The problem is that...

Gee, what to say? That's patience and perseverance in spades; thank you :)

Something changed now, I have a print on the way. Ha ha!!! That's cracked it :) The list box and then button click has got it sorted, wow. I'm sure I can get it to display rather than print now, that's genius.

'Method or data member not found' That's from the 'click' event in a button