Recent content by u0rjgr

Thanks for this Paul. I don't know what I was doing but have got it to work. Been a real pain though. :rolleyes: I have read on the site that you guys say that autonumber won't always number consecutively, does this happen alot as I am worried now as I will be relying on autonumber to provide...

Thanks for the reply. The problem is the calculation takes the info from the autonumber e.g '1' and a field that has a default value 'BP', I am combining these two boxes to create the field that is displayed on my form 'BP1' . I would just use the autonumber field but I need a text reference...

Hi, I am having a problem with one of my reports. Basically I want to display (in the report) a box from my form that has been produced by combining the data from two other boxes on that form. On the form it displays fine but I have noticed that in the actual table that the form reads from...