Search results for query: *

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

SQLBill - the other 3 fields that i am drilling by are needed to make the exact match when updating the record with the JQCHNB = 0, they are the other specific identifiers to the main records which have several other data buckets that may not be similar

SQLBill, i run the select statement and it returns just the 12 records that are 0 (zero) at this time, which are the ones that need to be updated. i then added the "AS" portion to the select and again it returned the 12 recs. i then retried the update code with the AS included as well but still...

thanks for that response, i tried that and recived the following error "Column qualifier or table T1 undefined." i also tried to just use JOIN instead of INNER but same error.

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

based on your IF statement theory wouldnt something like this get you what you need for a solution. Dim sub1, sub2, sub3, sub4, sub5, ttlSUB As Variant If (Not IsNull(Me.Text1)) Then sub1 = Me.Text1 Else sub1 = 0 If (Not IsNull(Me.Text3)) Then sub2 = Me.Text3 Else sub2 = 0 If (Not...