G Guest Mar 9, 2006 #1 We receive a CD with 100,000 calls/records; would like a preformatted report that summarizes call by department, or type call, etc.
We receive a CD with 100,000 calls/records; would like a preformatted report that summarizes call by department, or type call, etc.
J Jeff Boyce Mar 9, 2006 #2 How does the data get from the CD into Access? What is the table structure? Are you quite confident that someone else's query will refer to the fields in your table? Try this... First get the data into Access. Then create a query that returns all of the data (and sort/group fields) you're interested in. Then use the report wizard to create a formatted report, summarizing how ever you choose. Regards Jeff Boyce Microsoft Office/Access MVP
How does the data get from the CD into Access? What is the table structure? Are you quite confident that someone else's query will refer to the fields in your table? Try this... First get the data into Access. Then create a query that returns all of the data (and sort/group fields) you're interested in. Then use the report wizard to create a formatted report, summarizing how ever you choose. Regards Jeff Boyce Microsoft Office/Access MVP
