Search results

Hi guys! In my latest adventure "new query" I get tangled up with sorting week numbers A to Z. I use an expression field to convert a date to a week number. Works fine, except when I sort the query on the week number field the weeks go 1 11 12 13 14 15 16 17 18 19 2 20 21 ect. I used Opened...

This should be easy! Right? I have a series of dates with events that occured on those dates. Some events were extended, others were not how do I get a running total, cumulative total, for all records in the RunTotal column? Opened Date Open Issues CountOfExtended NotExt RunTotal 5/21/2007...

My main query has a list of events with the corresponding dates that they occured. I want to create a second query that shows Monday’s date of the current week and the Monday date of the preceding 51 weeks. How do I get my second query to show the dates for 52 consecutive Mondays starting with...

I have events with the dates they occured in my table/query. I want to present them in a pivot chart with one axis representing the dates for each monday of the current week back to monday 51 weeks ago. How do I get my query to show the dates for 52 consecutive mondays starting this week and...