Search results

  1. L

    Crosstab query for 7 days in future

    Indeed! The bracketed number is for an array. I am very new to VBA etc but have quite a lot of VB.NET experience so I bring that with me I suppose. See here for a quick overview: http://www.w3schools.com/VBscript/vbscript_variables.asp Under VBScript Array Variables. Thanks once again! :)
  2. L

    Crosstab query for 7 days in future

    Thanks for all your help. My final, working VBA code looks like this. It is attatched to the subform. Private Sub Form_Load() Dim coldate(6) As String For i = 0 To 6 coldate(i) = Format(Now() + i, "dd/mm/yyyy") Next i lbl0.Caption = coldate(0) lbl1.Caption = coldate(1) lbl2.Caption =...
  3. L

    Crosstab query for 7 days in future

    Thanks for all your suggestions. I've already hit your scales ;) This is the VBA code I have so far, but I cannot for the life of me get it to produce a crosstab query in a datasheet subform. Private Sub Form_Load() Dim coldate(7) As String For i = 0 To 6 coldate(i) = Format(Now() + i...
  4. L

    Crosstab query for 7 days in future

    Got that. I'd like to display this cross tab query on a form. Which event do I attatch the docmd.runsql code to to display the query on a form?
  5. L

    Crosstab query for 7 days in future

    Great! I thought about using variables etc but had no success. I would like the headings to be dynamic. How do I use VBA to run the query?
  6. L

    Crosstab query for 7 days in future

    That's awesome thanks very much. I'd like to display the 7 date columns and all products even if the values are null. Any ideas? :)
  7. L

    Crosstab query for 7 days in future

    I have a cross tab query set up to display the quantity of products ordered each date. I want the query to dynamically show only the future 7 days as columns. So the query would return: ProductName, 10/06/2010, 11/06/2010, 12/06/2010. TestProduct, 0, 10, 25 I've tried using the PIVOT IN command...
Back
Top Bottom