Need help with Query

[userZ]

Access DB:
TableA:
ID, team, group, date, time, game, result, city, country

Need a query that extracts the last (max (date plus time)) game a team has played where city name starts with "abc" or "def".

select ID, team, group, date, time, game, result, city from TableA .....

:banghead:

 

[namliam]

sounds like school work, what does your textbook say?

Next word will be "Where" and you will need a "group by" too

 

[userZ]

No, it is not a school work. It is a fun project.

 

[Ranman256]

Your table is designed wrong. You need other tables....
TTeams
TeamID, team name,

TRoster
PersonID,name,position, TeamID

TMatches
MatchID, date,homeID,VisitorID,location,homeScore,VisitScore