Replies

If you *Never* want French the best bet would be to delete the French dictionary – then it wont be able to set it. The dictionary will be called something like mssp3fr.lex – The fr indicates the language. It might be anywhere depending on how office was installed and what version use search (find) for *.lex.

A long winded method would be to make a new table using a make table query and include a calculated field called RealIndex which would contain Lastname Firstname.

Then run an append query selecting only those items with a flag. In the second query the RealIndex field would be set to Occupation.

Then use the resulting table for the report.

You might make a macro to pull all this together, in which case although clumsy it would run at a single click.

You can probably do the whole thing in one massive SQL query but they are much more difficult to maintain.