Search results for query: *

Thanks loads, PHV. Exactly what I needed. To see it work for the first time after so many failed attempts was a beautiful thing. Thanks again. Jonathan

For instance, ideally I'd like something like this to work: (This is entered in the Criteria row of the SOURCE column) IIf([Forms]![FrontEnd]![checkbox]=-1,<10000,"*") J

Thanks, PHV. That looks similar to other answers that I found online during my trawl. The Union query is huge and I'm try to check that it works simply first in a dummy db. Is there something I can write within the Criteria row in the Design view of the query that will do the same thing...

Hi all - Any help on this much appreciated - I've searched far and wide, but just haven't found the answer that I can apply easily to my database! i) I have a pre-existing query that pulls various data from different tables; ii) I now need to, retrospectively, add a checkbox to the main form...

Thanks, Duane. I will definitely go that route for this particular project. My curiosity is still getting the better of me how it could be done the lookup way (since I spent such a long time attempting to do it! Although it's clearly not the best way to go, I'm frustrated I wasn't able to lay it...

Thanks, MaZeWorX - yes, I suppose that's an option. I've just been trying to learn through doing (I've only been using Access for a couple of months) and thought that adding a Lookup function to the 'repertoire' might be worthwhile for this and future projects. If anyone can shed a bit of light...

Hi all - Thanks for reading - any help on the below matter would be really appreciated. I've got a table where there's approx 200 'Org Strings' - the terminology we use for how our departments are hierarchically arranged (e.g. "South - HR - Admin" or "North - Planning" or "North - Area B -...

Hi everyone - I've got a spreadsheet which exists to collect data on people leaving the company based on exit interviews done. The way things are currently set up is that I have three columns devoted to the 3 top reasons for leaving (represented by various codes explained on the paper...

Many thanks for your speedy help, Skip - that worked great. I'm not sure I'd have come up with that (even if I'd had months to sit and think about it!!) Very much appreciated. All the best, J

Sorry Skip - I'm still a bit confused (easily done I'm afraid!). In A17 I have 26/09/2003 (the start of sickness). In B17 I have 18/11/2003 (the end of sickness). This formula doesn't seem to count the number of (for instance) Tuesdays within that range. Sorry..... really appreciate your...

Thanks for your response, Skip. I have a 'Start' date in Column A and an 'End' date in Column B. In this particular example, the dates I used in my first post are in row 17. I've substitued this range into the formula as such: =SUMPRODUCT((MOD(A17:B17,7)=3)*(1)) However, I'm getting the...

Hi - I wonder if anyone could help me. I'm just trying to do some calculations on someone's sick days. I've used NETWORKDAYS ok to add them all up. However, this particular lady suddenly starts to work only on a Tues, Weds and Thurs. How can I count how many Tuesdays (e.g.) in a date...

Thanks, smah - I've had a look there and am preparing to go through that list in the correct order. However, one thing I'm a little frightened of is the fact that if I go ahead as suggested, I'll have to turn off System Restore points which will delete all those I have already - which could...

Over the last 10-12 weeks, despite having BroadBand, IE6 is going incredibly slow. I click a link and it takes maybe 30 seconds for Yahoo's homepage to display all its items. I see all the "Connecting To Site..." and "Start Downloading From Site..." info in the bottom left corner (which...