Advertisement

02.20.2007 at 03:13PM PST, ID: 22402344
[x]
Attachment Details

MS Access Automatic reporting

Asked by dearness in SQL Reporting, Microsoft Access Database

Tags: access, ms, automatic, report

I have a table stored in SQL Server that saves production data, and with MS Access at 6:00am every morning I want to create a report from the table that I will be able to email automatically with no user intervention at all. The report needs to use the day befores date to query the table . The report should be saved with a reference to that same date , ie Production010107.

I have MS Access connected to SQL Server with a linked table formatted as below.

tblProduction
prodID          prodDate         ProdLine        ProdCount1   ProdCount2   ProdCount3

The main problems I have is getting the report started at the set time each day, saving the report in a good format to email, with unique name and producing the report for the day required with out user intervention.


ThanksStart Free Trial
 
Keywords: MS Access Automatic reporting
Title
1 Date interval
2 Tying unique ID to a different table
3 MS Access Report Totalling
4 unique identifier
5 Select Unique records
6 Running on Intervals
 
Loading Advertisement...
 
[+][-]02.20.2007 at 09:00PM PST, ID: 18576372

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.21.2007 at 10:47AM PST, ID: 18580911

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.21.2007 at 11:23AM PST, ID: 18581218

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.21.2007 at 12:12PM PST, ID: 18581665

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.21.2007 at 12:33PM PST, ID: 18581867

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Reporting, Microsoft Access Database
Tags: access, ms, automatic, report
Sign Up Now!
Solution Provided By: gsgi
Participating Experts: 1
Solution Grade: A
 
 
[+][-]02.21.2007 at 12:35PM PST, ID: 18581885

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.21.2007 at 12:52PM PST, ID: 18582034

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32