Search dates in access

[HiZiNg]

Hi!

Im setting up a access database and I am wondering... how do i search after dates...I mean, in my access file i have salespersons, the number of sales they have in a month and the dates they sold them... the thing is that I want to search for is how many sales and what kind of sales have salesperson X sold in a period, and if i have a name what has this person sold on witch date.
Or does anyone know about any good access sites

Hope this was understanding


Aksel

 

[KJBarrie]

Here are some bits of code that may help you. You can get frustrated until you realise that dates in queries should be US dates:

Public Function MakeUSDate(X As Variant)

If Not IsDate(X) Then Exit Function
MakeUSDate = "#" & Month(X) & "/" & Day(X) & "/" & Year(X) & "#"

End Function

Here is a part of a line (the WHERE clause) from a query that searches for dates within a span 6 days.

WHERE ShiftDate >= &quot; & MakeUSDate(TargetDate) & &quot; AND ShiftDate < &quot; & MakeUSDate(TargetDate + 6)