strange query problem - right code wrong answer

[Davros]

hi

basically i am trying to combine a hyperlink with individual X and Y grid coordinates so i can open a web page and go to a location. this has been working and now for some reason it is not. no one has done anything to the database and yet this query has stopped working and i have no idea why.
the query is this:

hyperlink_1: nz([hyperlink]) & nz([hyperlink1]) & nz([x]) & nz([hyperlink2]) & nz([y]) & nz([hyperlink3])

nothing specatacular. it just says join the columns hyperlink,hyperlink1,X,hyperlink2,Y,hyperlink3 and output to the field named hyperlink_1

the outcome is an individual hyperlink with a specific grid coordinate. when i run the query now all i get is the text that is present in the field 'hyperlink' and nothing else. if i remove the 'hyperlink' field from the query then the other components of the query show in hyperlink_1. when i add the field 'hyperlink' back in they do not?
this one has me stumped? i thought about field length but then the output field hyperlink_1 is only about 150 charaters long.
anybody have any suggestions?
thanks in advance

 

[Davros]

answer found if anyones interested

for some unknown reason the 'hyperlink' field which was a text field had over 300 charaters of text in it (?? how this happend i do not know - default is 255). i only found this out by increasing the width of the of the field horizontally and i found 3 lines of text. my code below now works as i have deleted the extra text. very strange problem - i have no idea how this occured
thanks anyway