Recent content by duthiev

HI: Sounds intriguing! Would you be able to elaborate? Thanks!

Thanks! I'll see if that can be done.

It's a lottery (i.e. random) in order to ensure the employees in different departments are equally distributed amongst contacts. Thanks!

Hi again: I looked at Dlookup and I'm not sure this would work. Each day, the contact for a department changes. For example, on November 30, new employees in Sales would be assigned Mary. On December 1, new employees in Sales are assigned Fred. So, there's no connection between department...

Thanks for the feedback. I'm not sure how to use a recordset or Dlookup, but I'll explore.

Thanks for the speedy response! I'm not sure if I understand you; however, I want to avoid having to select the contact for each new employee. I might get 300 employees each day. Is there anyway we can get Access to evaluate the first two fields (date, department) and automatically select the...

Hello: Is there (simple) way that I can populate a field based on the values of two other fields? For example, in a list of new employees, if a new employee starts on Nov 30 and works in the Administration Department, his human resources contact is Mary. If a new employee starts on Nov 30 and...

Thanks! I ran separate queries, created reports for each, and then pulled them together into one report. Great idea.

Thanks. Any suggestions on how to build the query? I have tried to count clients on more than one field but to no avail.

I have several tables relating to clients joined by a common field: Client ID. I have created a number of queries each of which displays the number of clients for a particular field. For example, I have one query that counts that number of male and female clients, another that counts the...