Allen0926
Last Activity: Dec 14 '12, 03:19 PM
Joined: Dec 12 '12
Location:
-
It will be a unique value but it is not a primary key nor is it required to be one. Rather than creating an update query I thought there may be an afterupdate action as stated by NeoPa I could do that would simply save the concatenated value in the underlying table. -
ADezii,, where would I put that line of text??Leave a comment:
-
NeoPa, Thank you for "fixing" my post. I didn't have a chance to read the guideline for making posts. I will before I do another one.
Thank you everyone for the great responses! Checking to see which works best and will update when I have it fixed.Leave a comment:
-
Concatenate 2 fields into another field in same table
I am attempting to combine (concate) 2 fields into another field in the same table. Works great in a query and I understand how to do it on a form, but how do I store the return (value) back into my table?
The combination of these two values determine a unique string....Event:[castype]&""&[casnumber]
This result I use for linking my Main Form to my Subform and will also be used for runnig reports....
No activity results to display
Leave a comment: