Yh:)
it shouldnt come to this but i suppose it will work:)
i think its clear that Rabbie won the stupid match by scoring 10 own goals;)
thanx a lot, iv upped your reputation as you did help me anyway:)
good to see theres still some nice people round:) x
Yh ill be under the bridge:)
only to hit you wiv a stick tho when you land in the canal and hold your head under the water.
Thanx anyway namliam:)
i spent so long doing this i dont have to do the invoices:)
i might just use the old Access and then import it when i get the chance, thatl work right?
How about you say something useful and engage your brain before you type
I don't suppose you have 2007 and so wont have these problems
and yes it was good advice but it didnt work, im grateful to namliam for the help, you're not helping on the other hand so go do something useful like jump off...
How do i put it as default value?
maybe u should do this lol an let me import it?
would have saved me 4 hours and u the time it takes to keep replying and solving the problems
I entered Cash+Cheque+Card into the validation rule in the table in the "Money In" field but it didnt work.
I also put as "Money In" at the end after that but that didnt work either
im irritated that iv spent 4 hours doing this now an got nowhere!!!
why cant it be simple?
I think id much rather not do this than keep inputting all this information, why is it so much more difficult than before?
iv done what you said but now i have another field at the end called "Money In"-which doesnt work and iv also got the "Expenses" field twice now only one is called...
okay iv made a new query and added the fields, where do i write in the formula?
the design view is different from the table design view and it doesnt have a validation rule
is it criteria?
So i do what exactly then?
this access is confusing and i havent used it for a very long time, ill up your reputation as much as i can cos i realise im awkward lol
I could do wiv like a step by step guide or just easy to follow instructions
Thanx:)
Im just doin what the boss wants:rolleyes:
Thanx a lot you cant find this anywere in the help or on other sites (even if it is so simple)
So thanks a lot, i owe you one mate;)
Why does it make a difference doing this in a table rather than a query?
Oh an i just tried it out with...
It sounds real stupid but im having trouble doing this even tho i could a few months ago, maybe because im using Access 2007 now?
Anyway im trying to add these 3 fields in my table:
"Cash"
"Cheque"
"Card"
in this field: "Money In"
All of the fields are Number, i tried in currency but failed in...