Search results

SOLVED :) SELECT a.Month, a.MonthLabel, COUNT (a.ID) AS aCount FROM ( SELECT admin.ID, dimDate.Month, dimDate.MonthLabel FROM admin INNER JOIN dimDate ON (dimDate.keyDate >= admin.sDate AND dimDate.keyDate <= admin.eDate) OR (dimDate.keyDate >= admin.sDate AND admin.eDate Is Null) GROUP BY...

Hi, I am trying to get active member count by month in MS Access. Table looks like this: admin ID firstName sDate eDate 1 Adam 01/01/2015 01/04/2015 2 Ben 01/02/2015 15/04/2015 3 Carl 01/02/2015 13/03/2015 4 Don 13/01/2015 Required output would be like this...

Hello, I am looking for a way to send an access HTML report in the body of an email instead of an attachment. Is there an easy way to do this ? Sending them as attachment is very straight forward but I was unable to find any information on how to send it in the body of a mail It appears that...

Thank you John, you are great. Works nicely and I learned a lot by going through the example. Much appreciated :) ***** After digging a little more I found this: .allenbrowne.com/ser-27-01.html which is an excellent solution too

yes that works great - there wouldn't be a way around using a second form to enter the data ? like in this way - you enter data not in the table/cboBox - a popup msg appears asking to confirm if you want to enter new value - value is added to table upon confirmation & cboBox updates :)

Hello, Thank you very much for the fast response. I probably was not quite exact when describing my problem. I have to tables, accounts and countries. The form is based on accounts (basically a customer database) and contains a combo box that gets it's data from the table countries. What I...

Hello Everyone :) I have issues to get the following working. I have a form with a Combobox that gets it's data from the table 'countries' and stores information in accounts. Now I would need data entered in the cobobox to be checked against the table 'countries' if the data already exists...