Search results

That makes a lot more sense than what I was trying to do. So the query would have some sort of property that tells us how many entries it returns and if it's 0 we just move on to the next query... I'll have a tinker with this in mind when I'm back in work. I knew all the different pieces of...

Hi, I recently volunteered to set up a database to be used by my employer to handle calling clients who have booked an appointment. We book these clients in advance to be called within a 2 hour window, but do not give a specific time in most cases. The database will have a form where a user...

I should add that priority and timed clients will have a TimetoCall field set to a later time to control when they are given to another user. So if we try a priority client at 18:10 and make no contact the field will be set to 18:30, and that field will be checked to prevent the priority clients...

Hi, I have a list of client stored in a table "Clients". I would like a form to present a user with the next client in the list at the click of a button, but there will be some exceptions: Some clients will be given priority, and should be moved to the top of the list although they may not...

Hi, First off apologies for another one of "these threads", I'm hoping somebody can give me some pointers on how to approach a project. I need to create a database that will be updated daily with a list of clients to be contacted for telephone appointments. I have set up a table ("Clients")...