Query Help

davidnash

RAF DBA Man
Local time
Today, 13:17
Joined
Jan 25, 2006
Messages
14
I have attached a pic of the table.

I am fairly new to Access and need to build a query on a table, as shown.

It has the columns:
SerialNo, ProgressionID, PersID, Date, Comment, CommentNo.

From this I need to show the latest progressionID (i.e. the one with the highest CommentNo and greatest Time.

It prob sounds easy to some of you guys, but I am on a big learning curve at the mo.

Cheers
Dave
 

Attachments

  • Progression.jpg
    Progression.jpg
    91.9 KB · Views: 130
Firstly, don't call a field "Date". The word "Date" is a reserved word in Access and will lead to confusion at later stages.

Secondly, check out the Max() function in Access help, this may be what you're looking for.

Col
 
Thanks for the prompt help

I have just done my first access course (last week) and realise this. With this database though, I am working on something that was developed years ago. I remember from the course about reserved words, but forgot. I will now address this.

As for the Max() function, they told us about that on the course so i will look into it, thanks for the help.

Dave
 

Users who are viewing this thread

Back
Top Bottom