Access Queries HELP please

[aramisG93]

Hello,
Im having trouble in access...
I need to creat 3 seperate queries... Have been trying for hours and havent cracked any of them...

Fristly, how to show who has a birthday in the current week, so i have the DOB's entered in a table, but need to use that data to find out which of them fall in the current week, unsure at all how to make the year not matter.

Secondly, how to find the lowest value in a table, so who ran the fastest time in a race, but to single out only that result.

Thirdly, the way in which to input mathimatical calculations, i understand SQL might be able to help me, but im not sure how to use it.

Thank you in advance.

Aramis

 

[Cronk]

(1) In the criteria of your query design, use between Date1 and Date2
(2) The query design lets you set the order for any column(s) and the query properties lets you specify the number of records to be returned.
(3a) You can add a calculated column to your query eg Cost:[Quantity] * [Price]
(3b) Call a function from your query.

You can get further information by searching on the above.

 

[aramisG93]

Thank you for your help, that has aided me greatly.