Recent content by GeorgiF

Hiya, They were (are) defined fields and I did get an error message. I changed the format to currency and that resolved it (I think) for new records but previous ones where there is a null value have the message still. I will try again tomorrow as I have had enough of databases for tonight...

Oh Brian, I am sorry, I am new to this forum thing and thought I had thanked you both (hence 'thank you guys' in my last post). Didn't mean to be rude. Sorry again.

Oh guys, thank you soooo much. I have just used the example in Uncle Gizmo's post and it was spot on! Life is good again!!!! Thanks

Hiya, I have a fairly basic database that I use for customer information more than anything else. It also calculates VAT and total invoice value for me (I have done this in forms rather than queries). However, I tried to add a basic calculation based on figures that I have already entered as I...