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...

"Knowing what you don't know" Truth is if you know you don't know you know more than most, and by default, you have defined the parameters of what you don't know. So you do know something about the unknown - even if its less than you would like to know, you know where to start...If you choose...

For example, if we make a table with one field which has a default value of NOW(), a second field with a default value of Now()-7, a third with Now()-14... we end up with a 52 field record with today's date in the first field and consecutive fields 7 days earlier than the last, through 52 weeks...

I understand. I was hoping that someone had a solution like a table that calculated 52 mondays from this monday back and that I could use that to add to my current query so that the existing event dates would be grouped in the combined query by Date>last monday and Date<next monday.

Although I appreciate your help what you have suggested is a bit beyond me. Any chance we could do this with say a table that has a default of Today() and use the Query push the 52 dates through?

Thanks for the feedback. I'm still working on it.

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...