Search the Community

my focus is across a whole 3 years (156 weeks) of data, beginning January 1st 2011 (or nearest date) and ending December 31st 2013 (or nearest date) – so while we are looking at 3 years total, we will only end up with 52 weeks in our clean version of the data, labelled Week 1 to Week 52 (and not dates).there will be items in this list that launched before 1st Jan 2011, for which part of the launch year will show up in the period we’re focused on. In order that data percentiles (will be calculated at later stage) are not clouded by this, we also need to move any part year data from launches preceding 1st Jan 2011 to the relevant column. To illustrate by example, an item launched in July 2010 will have 26 weeks in 2010 (that fall outside of our 3 yr window) and 26 weeks that fall inside our 3yr window, but the first week we see is actually week 27 of that item’s launch, and not week 1. So the 26 weeks of data that fall into our window, should be shifted out to align with week 27-52 of the ‘clean’ data columns – does this make sense? So i want to have another column next to the WeekNumber column, which will give me the correct number (from 1 to 52) to place the sales value for each product. If then you do a pivot as shown in http://i.imgur.com/VZVIlPb.jpg by arranging the weeknumber column in the Pivots Column area and Sales Value in Pivots Value area, you will see the sales values are then shifted properly to fit the 52 columns. So for each Product, 1] if the sales data starts from 1st week (W 2011 01) and its total weeks count is < 52, then it means some weeks sales data lying in previous year. So this data needs to be numbered to correct week (between 1 to 52), by finding its column: (52 - count of weeks containing data for that product + 1).2] if the sales data does not start from 1st week (W 2011 01) and its total week count is < 52 then move it to 1st week (W 2011 01) column in 1 to 52 weeks i.e. number it as 1, 2, .....<=52.3] if the data starts from 1st week and is 52 weeks data then keep it as it is showing from 1 to 52 weeks. i.e. number it as 1,2,....52. Hope this makes sense. see the linkback for further clarity. http://stackoverflow.com/questions/23825905/shifting-156-weeks-sales-figures-to-52-weeks

How to grant access to only selected passcode? And to need to login into Disqus profile ( http://disqus.com/ ). 1.- So I give user a passcode that he than uses to access member-only stuff (so, it's a closed site) 2.- and later on he uses his/her Disqus profile to be part of community. 3.-and to have pc/ device remember that passcode was already inputted (like on Steam where you have to give you pc/ device a name) Thank you

So I made a menu but I don't know how to strech it from left to the right side...tried everything I could think of. So my question is does anyone know how to do it? Problem pic: Code so far: #access { background: #000; display: block; float: left; margin: 0 auto; /* width: 940px; width: 700px;*/ font-family:"Dekar Regular", Helvetica, Arial, Verdana , sans-serif; font-size-adjust:0.49; font-weight:normal; font-style:normal; padding: 0;}#access .menu-header,div.menu { font-size: 13px; margin-left: 0px; /* width: 928px; */}#access .menu-header ul,div.menu ul { list-style: none; margin: 0;}#access .menu-header li,div.menu li { float: left; position: relative;}#access a{ /* all links */ color: #FFF; display: block; line-height: 36px; /* is 44 but becuase of the 4px border it has to 4 less / height of the link boxes was 38 */ padding: 4px 10px 0 10px; text-decoration: none; width: 222px; /* menu item width, dose not include include the 1st and last item */ border-bottom-width:4px; border-bottom-style:solid; border-bottom-color:#000; font-size:21px;}#access ul ul { /*display: none; ----------- NONE TOUCH DEVICES ONLY */ position: absolute; top: 44px; /* match height of #access a 38 */ left: 0; float: left; /* width: 180px; width: 238px;*/ z-index: 99999;}#access ul ul li { /* min-width: 180px; width:238px;*/}#access ul ul ul { left: 100%; top: 0;}#access ul ul a { /* child items in the menu */ background-color:#000; /* line-height: 1em; */ line-height: 40px; /* is 44 but becuase of the 4px border it has to 4 less / height of the link boxes was 1em */ padding:0 0 0 10px; /* padding: 10px; */ /* width: 160px; width: 238px;*/ height: auto; width:300px; /* wider so that big game names fit in the menu */}#access li:hover > a,#access ul ul :hover > a { color: #ED2739; /* background-color:#666; */}#access ul li:hover > ul { /*display: block; ----------- NONE TOUCH DEVICES ONLY */}#access ul li.current_page_item > a,#access ul li.current_page_ancestor > a,#access ul li.current-menu-ancestor > a,#access ul li.current-menu-item > a,#access ul li.current-menu-parent > a { color: #ED2739; /* background-color:#666; */}* html #access ul li.current_page_item a,* html #access ul li.current_page_ancestor a,* html #access ul li.current-menu-ancestor a,* html #access ul li.current-menu-item a,* html #access ul li.current-menu-parent a,* html #access ul li a:hover { color: #ED2739; /* background-color:#666; */}#access .menu>ul>li:last-child a{ /* last element of the menu is a different width */ width: 178px; /* 154 */}#access .menu>ul>li:first-child a{ /* last element of the menu is a different width */ padding-left:5px;}

I made an update query that generates a google maps url link in a hyperlink type column based on the address in other columns. When I click on the generated link it works and opens my browser to the address in google maps but after I close & reopen access it doesn't work anymore even after using the query again, it acts like normal text but the url is underlined and the pointy finger shows. I'm guessing the function that determines if a string is a url is looking at the code instead of the result of the code . I am using access 2007 btw. UPDATE Property SET Property.Notes = "https://maps.google.com/maps?q="+Replace(Nz([Park Address],"Address")," ","+")+",+"+Replace(Nz([Park City],"City")," ","+")+",+"+Replace(Nz([Park State],"State")," ","+")+",+"+Replace(Nz([Park Zip],"")," ","+");

Hi all, Sorry tried to attach but the upload failed. Anyway I have the above code to connect to my Access database. Now my database has 3 tables: People, Address and Contact. Currently the only way I know to display all three tables is to have 3 vars, loops etc. I was wandering if there was a better way to display all 3 Access tables? PS, all 3 tables have an ID field which I only want to display once (ID is primary key in people and a foreign key in the other two). Any help would be much appreciated