Search results

Thank you very much! Ironically, I had JUST figured this out by myself, haha. Realised that I did a formula to add to names together and stole the formula for that after adapting it. Here's what I ended up with: IIf(IsNull([CountofAppointmentDate]),0,[CountofAppointmentDate]) Which is...

Hey! Having a spot of bother with my calculations, wondering if anyone can offer a quick solution! The clients in the database occasionally have a different type of session, called a "Change Interview". I've created a query which counts the total number of Change Interviews a client has had and...

Nope, can't conditional format list boxes. :/ And the work around is far to complicated, it will just have to stay how it is. One more question! Hehe... The clients in the database occasionally have a different type of session, called a "Change Interview". I've created a query which counts the...

Isskint, Sorry for the lack of reply, was my Birthday yesterday and apparently this means I can't work on this database on said day! Pfft! Today I cracked it! Figured out what I was doing wrong and how to solve all of my Diary problems, of which there were many. I may not have utalised the...

:D I'm tweaking with it bit-by-bit, but I'm not sure if I'm going to use this format in the end :banghead: Which feels silly given the amount of effort you've put into it, but I can't quite get it to work for myself. However, I do have one more question! I saw in your code that you have it...

Excellent! This is indeed something similar to what I want, however would require a few tweaks here or there, and you have over-complicated it! The clinic is only open two days a week with 3 time slots (but more counsellors (and there is an expansion coming up this year to 5 other sites, so it...

Access 2010. Did some tweaking last night, still not quite what I want but I think I know more clearly about how I want the individual bookings to look. My difficulty is in linking, as you rightfully said, the date/time/counsellors to appear in the right place, and the code for that is beyond me...

Hello! Have been writing a database for the clinic where I work over the last few days, and have completed everything that I need to except for this, which is the biggest, and I haven't a clue how to tackle it. I want a Form that across the top has a List of Counsellors (4-6 in total...

Hello from the south wales valleys! Over the last week I've found many a solution on these forums whilst trying to create a somewhat complex database for a Counselling service I work for. So, thought I may as well sign up and whatnot as unfortunately, I have a problem that is far beyond my line...