VB and SQL using Access - retrieving info within a certain timeframe

Hi,

In an database holding online chat conversations I am trying to select messages from a table in my Access 2002 table called 'Message' which were sent in the last 10mins, in the last hour or in the last month. This database is used for analysing data on a real-time online chat conversation so the user needs to be able to run these querys

The fields in the table it needs to retrieve are User and Message based on the Time field.

I'm not sure how this would work? I think it would have to know the time that it is now automatically and then deduct 10mins, one hour or a month and then select the messages and user who sent messages in that time displayed in an Access form.

Im new to VB and SQL so dont really know how to do this or how they link together in Access, would anyone be able with help me with this?

Any help would be greatly appreciated.

Thanks
-x-

Take a look at sql tutorials at www.w3schools.com or maybe www.mvps.org