Recent content by forbsey

I cant get it work because I have imported an Excel file into Access which has a lot of empty cells. It will only add default zeros to any additional records which are added, it won't assign zeros to existing blank cells. Is there any way of doing this? (there are over 2000 records with 7...

Is there any way I can automatically add zeros to cells with no value?

Got it working now. Fairly new to Access, still learning the ropes! Thanks again

I am having a problem with a Combo box which I have added to a form. I have added it and imported the values from a table but when I go back to the main view and select one of the values in the list, the value changes for each record. i.e. the Combo Box is a list of towns, when I select say...

I am trying to add a calculated field in a form which will calculated VAT on a price. I have added a Text Box and included the following: VAT:CCur([price]*0.175) But I'm only getting "#Name?" when I return to the main view. Any help on this would be greatly appreciated. I am using Access...