week number

[Jean-Paul]

Hi,

I have a table containing names of firms and dates on which they should
be visited.

I want something like: all firms that should be visited in week number 24

Is there somebdoy out there who is able to explain?

Thanks

 

[Ken Snell \(MVP\)]

See the DatePart function; it allows you to get the week number from a date.

 

[Linq Adams via AccessMonster.com]

This SQL will create a query that will prompt you for a week number, then
return all company names and dates for visits if the date falls in the week
number entered:

SELECT YourTableName.CompanyName, YourTableName.DateToVisit, [WeekNum] AS
Expr1
FROM YourTableName
WHERE ((([WeekNum])=DatePart("ww",[DateToVisit])));

Replace YourTableName with the actual name of your table, CompanyName and
DateToVisit with the actual names of your respective fields. You can then use
the query as a basis for a form or report.