I have created some queries that are joined on long text fields (80-120 characters). I can save the query in the graphic query design window. But when I reopen the window I get messages that the Joins have been deleted. I cannot find any references to this issue. Does anyone have experience or info on this?

I don't need a lecture about the use of long text fields in Query Joins. And yes I have used Search first.

Thanks for your help.

I haven't seen the error probably because I would never use such a long text string as a key. Is there some reason you can't use autonumbers as the primary and foreign keys? You can always create unique indexes on the text string to prevent duplicates.

Pat,

Thanks for your response. The reason I'm doing this is the project I'm working with is to match Medical Facility Names against a Master List of Medical Facilities. So regretably. the query must join on the Names.

I link two tables on the Name and a numeric identifier. The Join on the numeric Identifier does drop off, but the Join on the Text field does.

I will try more testing to see if I can figure something else out.

If you come up with anything, I would appreciate it.


Thanks

I have found that the QBE occassionally has problems representing the actual query. In those instances, you can save the query in SQL view and if you NEVER switch it to QBE view, Access won't mess with your SQL. I usually have to do this when I have a totals query that needs a where clause rather than a having clause. Access always wants totals queries to have having clauses and tends to change my where clauses to havings which of course makes the query return the wrong data.