Search results for query: *

Hi, I'm looking to find out if there is a relatively easy solution to an audit we are about to complete. Essentially, what is required is a list of all users, the groups they are associates with (bearing in mind it may be more than one) and the folders they have access to (again, bearing in mind...

I changed one of the bands descriptions during writing this, which is why one says middle and the other says minimum performance. James

Hi, I have worked on and searched long and hard to come up with a solution to the vlookup(true) Excel function in Access. May of the solutions I have found meant using several queries/subqueries to get to the right results. Luckily, I stumbled across this while looking through the built in...

Hi all, I am trying to get the below piece of code to work, but it keeps hanging whenever one of the spreadsheets is opened by someone else. There is a password on each of the sheets, so I know it's not that thats causing issues as it opens the first few and then as soon as theres a...

Thanks, Just managed to work out another solution as well ={SUM(K3:AA3/X!A$2:Q$2)} should have used a tad more lateral thinking before jumping the gun and going for a snazzy function.... Thanks james

Hi, I'm trying to find a away to create the opposite function to SUMPRODUCT, ie SUM..DIVISION??, presuming that there isn't one out there already (I haven't managed to find one so far) I figure the best way is to look at the actual coding sat behind the SUMPRODUCT function, if anyone knows it...

Hi, I'm trying to output a file to our department Sharepoint site, but am coming up with problems. I have added the sharepoint site into my network places and have tried using the Proc Export function: PROC EXPORT DATA= ruser2.rdu_logout OUTFILE=...

Hi all, I know this has probably been answered before, but i'm trying to get my head round some of the previous answers. I have a crosstab query linked into a select query. The select query has a parameter criteria in place. Now, this works all well and good when performing the select query on...

Hi, i found a problem at work today that i could do with a hand on if possible. I've found a few #error results in a calculated field, which i would like to be blank. Having a background in excel, i know there's a way there of using if(iserror(...., but this doesn't appear to be the same in...

thanks lupins, does that work if the data is all from the same table

Hi, wondered if you may be able to help. I'm looking to run a report on a table that i currently have set up. When i run any kind of report, each line on the report is dedicated to one record. What i'd like to do is have numerous records on one line. for example currenlty, the report comes out...