Problems Creating Queires in Access 2003

[Authors]

Just an annoying little problem involving access 2003 (a program I know nothing about)
In previous versions of Access all you had to do to add a field to the query builder was to double click on the required field in the tables and it would automatically appear down in the new query below.
Ever since upgrading though, this same action seems to place random fields in the query that bear no ressemblance to the one that was double clicked. Is this a settings thing or another case of things being improved for the worse!

Cheers

 

[RoyVidar]

Hi!

Don't have 2003, but there is an option (Tools | Options - table/query tab) in xp for "Output all Fields". Think that property should be in 2003 too. If this is checked, try unchecking it.

Roy-Vidar