Recent content by chainedtodesk

i had a server crash, and needed to rebuild an sharepoint server. on this intranet sharepoint we had three reports that were inherited. they look to an sql db and show snapshots of daily data. i recovered the wwwroot folder from the original server and added it to the new one. installed all of...

thanks Andy, that was the answer worked like a champ. thanks much

i am trying to execute the following "IIF" statement but get errors, i have a calc to figure out number of days a ticket is open. then there is a ct field that i need to add to that, but sometimes there isnt a ct and its null, so i thought i should be able to add the iff statement that if the CT...

created a query in access to get all my data buckets as needed and was able to get the process to work, couldnt get where statement to work will try to revisit when this time pressued project is complete. thanks all

I have an access query that gives me a count by days buy type, i want to create a line graph from this, with a line for each type. i can get a single line to work just by the dates and counts, but i cant get it to generate anything if i try to add the type in the code. the attached code works...

i have a macro that pulls data from a specific access table, i do not want to add more updates to the access DB but would instead like to update the macro. the file has now accumulated two years worth of data and the grid is very cluttered so i would like to only pull the current year, but no...

i have a table that has 3 years of data in it. the data is broken out by a salesman, a product type, sales dollars, year. i was able to use a cross tab to get the records to disply as needed for management, but now they are requesting a difference column either dollars or percentage but it needs...

is there anyway to update an as400 table with info from an MS Access db. i read several posts on lots of sites saying journaling needed to be turned on and that the table on the 400 could not have a keyed field i have done all of this but still receive the #7800 error everytime i try to post the...

okay thanks, i will try it with the summary formulas.

i have a process that creates an excel chart, i would like for the chart to not have the filter pivot table options. these are gray buttons to the top/bottoms/sides based on the pivot table. CODE: Sub chart_share1() Start_Row = 13 Chart_Name = "NEW PRODUCTS BOOKINGS" Counter = 1...

thanks all for your responses, i will try all suggestions a post which one works best for this application.

i have to create a pick list for an order system, and what i have to do as part of this is generate labels. some items have multiple quantities. so example is (ItemNbr, ItemDesc, Qty) 123456 SamplePart 3. i would like the query to dup that particular line into the label table 3 times, then move...

problem solved, thanks for all that helped: here is the working code: UPDATE RKBOOKTEST SET (JQCHNB) = (SELECT RKBOOKUPD.JQCHNB FROM RKBOOKUPD WHERE RKBOOKTEST.JQCVNB = RKBOOKUPD.JQCVNB AND RKBOOKTEST.JQCANB =...

problem solved, thanks for all that helped: here is the working code: UPDATE RKBOOKTEST SET (JQCHNB) = (SELECT RKBOOKUPD.JQCHNB FROM RKBOOKUPD WHERE RKBOOKTEST.JQCVNB = RKBOOKUPD.JQCVNB AND RKBOOKTEST.JQCANB =...

i have a table that an occasional user will not populate a major field, and i need to catch this before it goes any further. i tried the following code for an update prior to pushing this data out but the query fails. the two tables are large and have multiple records but the main links are...