Forum Discussion

wilbur750's avatar
wilbur750
Frequent Visitor
2 years ago
Solved

How to create a calendar table with multiple rows per date

Hi   How do I create a calendar table where there are multiple rows for each date?  I have 15 council recycling collection rounds that collect from residents every week day.  I am ultimately needin...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    wilbur750  You're welcome. You could also simply go in to the Query Editor, right-click within the Queries pane, then select New Query, then Blank Query. Once done, select Query1, open the Advanced Editor on the Home tab then paste the code I sent yesterday over the existing code.

wilbur750's avatar
wilbur750
Frequent Visitor
2 years ago

Wow!  Looks like what I need.  I'll try it tomorrow when I'm back in work.  Thanks so much!  I'll let you know how I get on

Anonymous's avatar
Anonymous
Not applicable
2 years ago

wilbur750  You're welcome. You could also simply go in to the Query Editor, right-click within the Queries pane, then select New Query, then Blank Query. Once done, select Query1, open the Advanced Editor on the Home tab then paste the code I sent yesterday over the existing code.

  • wilbur750's avatar
    wilbur750
    Frequent Visitor
    2 years ago

    That works perfectly!  Now I know how to use the advanced editor as well 🙂

     

    Thanks so much!