Search results for query: *

thanks for that comfirmation and info, Lilliabeth! Term date never crossed my mind. One thing about that really quickly? The HR person was hoping that I could add a field "Active Status" on the Employee that could be switched on/off. It would have "Retired, Active, Non-Active" as options...

I've been thinking since I posted this - and think I know one of the answers. I wouldn't want a form that is going to be used to input info regarding a job position, included as a tab on the input form for the employee info. Since the two are totally seperate. I know that there will be a...

Just a little background real quick - I’m an accounting person by trade and tinker with access. The HR director in the state agency I’m working in, has to maintain 22 reports that are done in Word and Excel. The reports all contain variations of data pertaining to the Employees (personal...

I'm working with a contact database (I'm self taught so I use that term "database" loosely ;) ) and, I was asked if I can create a report based on a query that will show when a customer had a visit during a month... it's a visual thing for them. So, it would look like this...

Can someone direct me to some easy to understand directions/examples of how to create a data input form that uses selection boxes? Here is a made up example of what I'm trying to do... If I have contracts that I sign with my customers, and there are 5 specific contract types which a customer...

Sounds very strange, huh?? I think it is. I have a table with city names (tblMunicipality). I have a contact table where we list cities that we visit for work purposes(tblContacts). (The city is our client so to speak). I have a third table where we list the city and the conference they...

Oh wait..just noticed one thing though... if the number of visits desired is 1 and the number of visits made is blank (because no visits have been made yet) this returns a blank field. Same with the calls. I'd like to see it do this 1-0=1 Any thoughts on that? Thanks again!

WooHoo! That was exactly what I was asking... and, it works perfectly!!!!! Many thanks! -Stefan

I had some help regarding how to count some items in a query. It's a contact log and I wanted to count the number of visits and calls made to our "clients'. Someone helped by creating a "count type" query which looked through the contact log and for each "client" would...

kpal29 - Thanks for the reply! I setup the query as you suggested and it seemed to work. I'm now having problems receiving an "Error loading DLL" message now, so haven't been able to do anything. BUT, thanks again! You answer made sense and seems that it will work! Stefan

I have a question about queries that I hope someone can help with I'm working with City/Town's of my state in a customer like capacity. We see many of the cities/towns at events and also make visits to see them. 4 tables - tblCities (info like city name, population, contact person there, also...

Okay... I'm working on redsigning my tables as FancyPrairie suggested. But, I think I'm back to my original question though. How can I make a form so that I can pick multiple staff names when more than one travels together to visit a client? With a combo-box I would have to derive every combo...

FP - Good point on the employee table. It never crossed my mind to make that a seperate table. That would definitely make the task easier. I appreciate the quick answer and pointing me in the right direction. I LOVE this forum!

Well, don't laugh - my background is actually finance (I'm a retirement advisor) and I'm self taught on tech stuff like access, html code, etc.. I'm a tech wannabe with only half the brain capacity! So, Visual basic would be outta the window for me. I have two tables - One is tblmembers (I...

I have a database where we input contacts we have with clients. Currently there is a field titled "contactedby" and we have sometimes input a visit by multiple staff as "Cindy, Don" or "Cindy & Don" but, I want to be consistent and want to be able to query how...

I have a contact database where I log a client and a contact date (Client and ContactDate fields). I then compare this table to a table of all clients to find clients that have not had a contact (null). What I'd like to do, if possible, is be able to pull the unmatched records that haven't had...

Hmm.... I was sitting here thinking about my post..and actually, I don't need to know who hasn't had a visit AND who hasn't been to a conference. I need to figure out how hasn't had a visit OR who hasn't been to a conference. That would still be the union of the two queries though...

I created a contact database where I track contacts based on visits to a customer and seeing a customer at a conference in two tables (visit and conference). I ran two queries for both tables against a customer name table and pulled the unmatched on the visit and conference tables. This...

Thanks for the help! It is working great :)

I am building a switchboard and have a button for the users to click to generate a report. Once the button is clicked, it gives the user the ability to enter a query parameter. However, if the "cancel" button is clicked on the parameter box, I recieve the "Run-time error...