Recent content by jmthompson

Thank you for your reply. Ok now I am lost I have tried the DateDiff everyway possible I think and I am just not getting it. I am a access novice. I understand the datediff and the "N" but where do I need to go to get this to run properly. I am sorry I am such novice.

Hello! I am having a problem that I just cannot seem to get around. I have looked through the other posts and found part of my answer but let me go ahead and explain it all. I have a form that has different fields for Open Date, Open Time, Close Date and Close Time. I am trying to do a query...

Thank you very much for your reply. Here is what my query looks like I have a section in my form that is called contact method choices are email, phone, walk over etc.. There are 6 of them. Well when I do my query first I get my count of how many have been used (broken down for each one). Next...

Hi! I am just plain stuck. I am trying to run a query to show me percents of different fields let say I have Contact method of 6 diff types and I want to run a percent on the use. How can i get this done I have tried a couple of ways and I just cannot get it figured out. Please Help!!!

I have read just about everything on the site about emailing through access and some of it works and others do not. The problem I am having is I want to send out on email to a customer that pulls the email address from the form also included I want the customers first and last name in the body...

Hello All! I am sitting her banging my head against this computer, I have read some of the questions about email and access and all have been very helpful and everything has worked. The problem that I am having is that I want my email to to be populated by the info in the form such as the email...