Gents,
is there any way to group by week.......
Gents,
is there any way to group by week.......
if by your very brief question you mean you have a date field which you want to convert to a week, then yes - use the datepart function to group on - see this link https://www.techonthenet.com/access/...e/datepart.php
make a form with 2 text boxes, txtStartDate, txtEndDate.
make a query to pull the data based on the range of the 2 boxes.
select * from table where [MyDate] between forms!myForm!txtStartDate and forms!myForm!txtEndDate
i have also added quick pick radio buttons to fill in the boxes faster. (see photo)