Search results

THANK YOU SOOOOOO MUCH!!! It's now working as it should! The only thing left is to figure out why in each of the Amount 1 to Amount 5 fields, the default £0.00 doesn't show. However, it does show when I create a new record. I've checked the properties for each box and in the deafult value...

This is the code which I have in the control source for the total field - =IIf(IsNull([Benefit 1 Amount]+[Benefit 2 Amount]+[Benefit 3 Amount]+[Benefit 4 Amount]+[Benefit 5 Amount]),0,([Benefit 1 Amount]+[Benefit 2 Amount]+[Benefit 3 Amount]+[Benefit 4 Amount]+[Benefit 5 Amount])). I got this...

Basically, I have a main form which has details of eeach person me and my colleauges work with. On the form, it has a lot of input fields like name, age, dob, status, staff name etc. The fields I added in was their state benefit income. Each of the amount fields is for a seperate benefit and...

WOW - this site is ace, wasn't expecting such a quick reply! Ok, although the database is v complex, it has been built by myself via hours of trawling through google etc and I also had some background knowledge too. Where do I stick the 'Me.Text262 = Nz([Text158], 0) + Nz([Text207], 0) +...

Hi All I have quite a complex database which I have set up for my job with the Council. Over the last 12 months, I've added and removed various functions to the main form on the database. Yesterday, I added extra fields onto the form called 'amount 1', 'amount 2', 'amount 3', 'amount 4' and...

I have set up an access 2003 database for work. I am a somewhat newbie to Microsft Access - the last time I used it was in 2004 for High School! Anyway, I have made a database with several tables and one main form for entering data. I want to make it so that when you open the form, and when...