14 day blocks of data

[aids2]

I need a query that sorts data into 14 day blocks and then displays the results in a stacked bar chart?
The data is continuously updated so I require the query to constantly sort the data without any changes to the original query.

 

[dhookom]

How about sharing something about your chart Row Source and "14 day blocks"? Do the blocks correspond with full weeks or are they relative to the current date?

Duane
Hook'D on Access
MS Access MVP

 

[PWise]

create a digits table 1 field type number from 1 to .....


run this query

SELECT  Digits.DigitID, DateAdd("d",[digitid],Date()) AS Dateval, Int(([DigitID]-1)/14) AS groupnum
FROM Digits;

 

[PWise]

forgot to include code for digit table

Sub DigitTable(MaxNumber)
Dim Mydb As Database
Dim Num As Long
Set Mydb = CurrentDb
Mydb.Execute "Create Table Digits (Digitid INTEGER CONSTRAINT Digitid PRIMARY KEY)"
For Num = 1 To MaxNumber
    Mydb.Execute "Insert Into Digits (Digitid) Values (" & Num & ")"
Next
End Sub