Recent content by Matty D

Thanks to both of you for the replies. I will edit the table and form as needed to be proper. Much appreciated.:D

I am still new to designing databases and have learned alot from this years database I built, in large part to reading these forums :D On another Access site it stated, on a list of standard rules, that: "Thou shalt never allow thy users to see or edit tables directly, but only through forms...

I know your correct. As I was trying to find the solution to my problem it became very clear that storing the calculated value was a no-no. However I don't have the knowledge to get the 8 items to total up as well as one additional field all grouped under a series of account numbers that needs...

Thank you very much for that quick reply, I was googling as you wrote that :p so you saved me some time. I will read through it and start thinking about how I'm going to do this next year as I don't think I want to turn this database into more then one years worth of data. Hopefully I can learn...

I really do wish I found this site before I created this monster. If I change the names of fields now it should not affect anything except in my queries and reports correct? I can do those over again fairly easily. Normilization of items1, items2 etc., I don't follow, nor do I know what...

Well I tried one last time and realised my error, I did not code things properly. Please close or erase this thread. Sorry for any inconvinince.

I have tried searching through these forums for an answer and I thought I found one, two actually, but I still can't seem to make things happen on my end. I appologize first off because I have very limited Access knowledge outside of some basics. Here is my situation. I have 8 fields for cost...