Recent content by NumberXYZ

Thanks for the reply. I've managed to calculate the distance between two postcodes (northing & easting) useing 'fdist'. This gives me a table where each member has a km distance for each of the 100 venues. I'm now simply trying to do a query that only displays one record for each customer. I've...

Hello I currently have two tables - one with a list of ten customers and their postcodes (eastings & northings)- the other with a list of 100 stores and their postcodes (eastings & northings). I was recently shown a 'fdist' query where you could put a distance parameter into the query. This...

Hello I've done this in excel but can't replicate in access. Table 1 Member Id Name Income Score 765849 Davis 51,000 678459 Smith 52,500 567483 Jones 54,00 Table 2 Income Score 50,000 20 51,000 30 52,000 40 53,000 50 54,000 60 I'm trying to...