Recent content by crogers111

I had something similar happen a while back when going from dual monitor to single monitor and it was indeed floating offscreen. IIRC using the Windows key + arrow keys resoloved

Needed to adjust one formula in the event the record date was a Sunday @WeekBegSunday if Weekday({tbl_WorkingData.Date}) <> 1 then {tbl_WorkingData.Date} - (Weekday({tbl_WorkingData.Date} -1)) else {tbl_WorkingData.Date}

Still testing but I have a series of formulas that I believe will accomplish what I need... //Saturday after RecordDate @WeekEndingSat {tbl_WorkingData.Date} + (7 - weekday({tbl_WorkingData.Date})) //Sunday Prior to RecordDate @WeekBegSunday {tbl_WorkingData.Date} -...

I've searched the forums I have these formulas that give me the Sunday to Saturday date range I need that each date falls in: {tbl_WorkingData.Date} + (7 - weekday({tbl_WorkingData.Date})) {tbl_WorkingData.Date} - (Weekday({tbl_WorkingData.Date} -1)) but they obviously fail for the begining...

Thanks for the feedback. Apologies if the above was not clear. Sorry for using the word 'weeks' creating ambiguity. Let's call it 'date ranges' Each date range begins on Sunday or the first day of the month for the first date range Each date range ends on Satruday or the last day of the...

CR2011 Access 2007 I'm looking to create formulas to define/group each week in a month given the month's start date via a parameter. @BegDate Each week begins on Sunday or the first day of the month for the first week Each week ends on Satruday or the last day of the month for the final week...

Open 'Field Explorer' (View | Field Explorer ) Right click the 'Formula Fields' option and select 'New' Give the formula a Name. e.g. GroupingFormula In the Formula Workshop double click each data field you have listed but add a concatenation operater (&) in between each field e.g...

You could create a formula that concatenates all 10 columns and then insert a group using the newly created formula. then place all fields in the GH or GF

...and suppress details sections

Not in a place to test, but this should work. Add a Grouping on {Event_no} place your fields in GF2 This should show records for the largeest (maximum) Event_No per deal.

CR 2008 I need to group my data (I think) so that I can create 2 seaparate line charts, one for 2012 data and one for 2013 data (without using a subreport). Each Chart should have 2 lines, one for 'Actual' one for 'Budget' The dataset contains only 2 years of data (?Year and ?Year - 1) based...

CR 2008 I've poured thru related threads about excluding weekends and holidays but haven't been able to get this working quite right. Given the last working day of the month, (which I'm calculating in the report for the current month, see formula below) I need to increment days (both postive...

As Ian states, I would check for conditional suppression. In Design mode, locate the section that has the data fields. To the left of the section, right click the section name in the gray area and select 'Section Expert' On the Common Tab, locate the check box for 'Suppress (No Drill Down)'...

Thanks for the tip, I didnt' get a chance to try it but will keep it in mind next time. I reworked the report to use a command and the report runs and is delivered in a few seconds.

CR XI (11.0.0.2495) SQL OLE I have a report that I'd like to change to use a command. I've changed datasources plenty of times but not to a command and am hoping I'm just missing something. I'm basically following the steps from this thread...