I need some help on DISTINCT in a query I'm trying to run.
I have two tables which are linked. This is the query I use:
SQL = "SELECT DISTINCT name, category, land, task, nbc_protect,
airportable, amphebian, alternative, capacity_fuel, crew, height,
length, width, range_max, range_eff, range_cruise, speed_road,
terrain_water, speed_terrain, calibre, rate_of_fire, weight,
penetration, type_ammo, diameter, radius_casualty, type_fuse,
type_grenade, traverse, num_rotor_blades, num_barrels, altitude_max,
pressure, charge, max_speed_air, ceiling, datum_invoer,
datum_controle, time_controle, weaponkey, ImagePathAndFile " & _
"FROM Weapon INNER JOIN Images ON Weapon.WID = Images.IID"
Order = "name"
The Table Weapon has a autonumber (WID) which is linked to the ...