Search results

adding to what ive wrote above ive just made another field called StartID and only written ABC/ in the cells of that field then i went back to the report ive created and tried concatenating StartID into ListID by using: [StartID] &[ListID] again an = sign was added this didnt work also

ok so what ive just done is in the form i have made i have edited the control source of the field i want, and changed it to "ABC/" & [ListID] access automatically added an = in front of everything so it turned out to be: ="ABC/" & [listID] when i saved it it came up with a couple of errors...

im starting to think it goes in the validation rule box am i right?

thanks for the reply i used -> "sometext" & [fieldname] in the format box for the field name and it returns some different format am i actually entering it in the right box or is there a box that i am missing to concatemate? kind regards & everything is much appreciated

sorry for not knowing much about access but how do you concatenate cells because if i could concatenate then i could just add what ever text i wanted to onto the start of the autonumber field i have. and if i concatenate then i go to search for a record, will i have to add just the number or...

hi i am trying to get my database to autonumber the field like in excel. in excel you just have to drag a little point on the end of the cell and it will auto number till wherever you want. i dont know how to do this on access another thing is that there are letters aswell as numbers included...