G
Guest
Hi, I am having problems setting up e-mail function in my report. I will be
querying for data in the database then I will create a report based on the
result of my query but I can not set up my e-mail system because my company
is using Lotus Notes rather than the compatible MS Outlook that I can set up
in Access.
1. Can I set up my report to be e-mailed using Lotus Notes? If, I can how?
2. (Basic question about query) I am try to query in my database a date
range (i.e. between "01/26/2005" And "01/26/2006") if those dates don't
exist in my database I can use (i.e. >= "01/26/2005" And <="01/26/06") I
don't know why after using both examples above does not give me accuate
results even using # rather the ". It also includes result of 01/26/2010
also. I need to find in my data base 6 months, 1 year time period where
products will have expiration dates.
Thanks a Bunch. Kyle
querying for data in the database then I will create a report based on the
result of my query but I can not set up my e-mail system because my company
is using Lotus Notes rather than the compatible MS Outlook that I can set up
in Access.
1. Can I set up my report to be e-mailed using Lotus Notes? If, I can how?
2. (Basic question about query) I am try to query in my database a date
range (i.e. between "01/26/2005" And "01/26/2006") if those dates don't
exist in my database I can use (i.e. >= "01/26/2005" And <="01/26/06") I
don't know why after using both examples above does not give me accuate
results even using # rather the ". It also includes result of 01/26/2010
also. I need to find in my data base 6 months, 1 year time period where
products will have expiration dates.
Thanks a Bunch. Kyle