New answers tagged

0 votes

MS Access SQL - Left Join (or sub-query?) most recent related record

You can use LEFT JOIN with subquery: Try: SELECT l.*, a.* FROM ( ( Lead as l ) LEFT JOIN ( SELECT LeadID, MAX(ActivityDate) ...
user avatar
  • 1,157
0 votes

Access Web App query 3 Tables with aggregatios - Need a workaround

I do not understand your data model. One pc can have multiple cpu's? And for every cpu you store all data, even If the same type of cpu is also in other pc's?
user avatar
  • 51

Top 50 recent answers are included