<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=Windows-1252">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<title>Message</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
p
{margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.emailstyle17
{font-family:Tahoma;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.emailstyle19
{font-family:Arial;
color:navy;}
span.EmailStyle22
{font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The report is created and then it shows up
in drop down list. The user then picks the report and is given
several tabs where they can pick the criteria they want to filter on and what
kind of filter, and, or, between, like, in/not in etc, etc. Or the really
savvy user can write their own SQL statement to use as a filter (usually I hide
this ability for fear of user overload). I have never addressed the
issues of sorting so I don’t know if it is built in but I believe a
little tweaking could add that ability. It is really an amazing little
piece of work at a wonderful price – FREE!</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<div>
<p class=MsoAutoSig><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'>Nancy Lytle</span></font></p>
<p class=MsoAutoSig><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'><a href="mailto:N_Lytle@terpalum.umd.edu">N_Lytle@terpalum.umd.edu</a></span></font></p>
<p class=MsoAutoSig><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'>301-249-0137</span></font></p>
<p class=MsoAutoSig><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'>301-675-3661 (cell)</span></font></p>
<p class=MsoAutoSig><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'> </span></font></p>
<p><font size=3 color=navy face="Times New Roman"><span style='font-size:12.0pt;
color:navy'> </span></font></p>
<!-- B101699BBFB441a0907FA9947EFDF6C1 -->
<div class=MsoNormal align=center style='text-align:center'><font size=3
color=navy face="Times New Roman"><span style='font-size:12.0pt;color:navy'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'>I've stopped <strong><b><font
face="Times New Roman">329</font></b></strong> spam messages. You can too!<br>
Get your free, safe spam protection at <a
href="http://www.cloudmark.com/spamnet?v1">www.cloudmark.com</a><br>
<a href="http://www.cloudmark.com/"><span style='text-decoration:none'><img
border=0 width=224 height=41 src="cid:image001.gif@01C2EC9D.EC13B3D0"
alt="Cloudmark SpamNet - Join the fight against spam!"></span></a><br>
<br>
</span></font></p>
</div>
<!-- A0C0A2D1C85242f096A170281367BF11 -->
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b>
accessd-admin@databaseadvisors.com [mailto:accessd-admin@databaseadvisors.com] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Andy Lacey<br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, March 17, 2003 3:26
PM<br>
<b><span style='font-weight:bold'>To:</span></b> accessd@databaseadvisors.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [AccessD] Report
Writer</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=blue face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:blue'>So, Nancy, you still
write the report but then give them the ability to put in their own select
criteria? Is that right? Can they specify own sort sequence too?</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<p style='margin-right:0in;margin-bottom:12.0pt;margin-left:.5in'><font size=2
face="Times New Roman"><span style='font-size:10.0pt'><!-- Converted from text/plain format -->Andy
Lacey<br>
<a href="http://www.minstersystems.co.uk/">http://www.minstersystems.co.uk</a></span></font></p>
<blockquote style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt;
margin-left:3.75pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<p class=MsoNormal style='margin-right:0in;margin-bottom:12.0pt;margin-left:
.5in'><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>-----Original
Message-----<br>
<b><span style='font-weight:bold'>From:</span></b>
accessd-admin@databaseadvisors.com [mailto:accessd-admin@databaseadvisors.com] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Nancy Lytle<br>
<b><span style='font-weight:bold'>Sent:</span></b> 17 March 2003 20:03<br>
<b><span style='font-weight:bold'>To:</span></b> accessd@databaseadvisors.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [AccessD] Report
Writer</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>Check out RFil (</span></font><font
size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:blue'> </span></font><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'><a
href="http://www.mile50.com/access/rfil/">http://www.mile50.com/access/rfil/</a></span></font><font
size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:blue'> </span></font><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>). It is a set of
forms, etc that you add to your front end and it will take a report and let the
user slice it or dice it on what ever criteria (fields) are in the
report. I add it to just about every Access DB I create that has report
requirements.</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<div>
<p class=MsoAutoSig style='margin-left:.5in'><font size=3 color=navy
face="Times New Roman"><span style='font-size:12.0pt;color:navy'>Nancy Lytle</span></font></p>
<p class=MsoAutoSig style='margin-left:.5in'><font size=3 color=navy
face="Times New Roman"><span style='font-size:12.0pt;color:navy'><a
href="mailto:N_Lytle@terpalum.umd.edu">N_Lytle@terpalum.umd.edu</a></span></font></p>
<p class=MsoAutoSig style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<!-- B101699BBFB441a0907FA9947EFDF6C1 -->
<div class=MsoNormal align=center style='margin-left:.5in;text-align:center'><font
size=3 color=navy face="Times New Roman"><span style='font-size:12.0pt;
color:navy'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal style='margin-right:0in;margin-bottom:12.0pt;margin-left:
.5in'><font size=3 color=navy face="Times New Roman"><span style='font-size:
12.0pt;color:navy'>I've stopped <strong><b><font face="Times New Roman">325</font></b></strong>
spam messages. You can too!<br>
Get your free, safe spam protection at <a
href="http://www.cloudmark.com/spamnet?v1">www.cloudmark.com</a><br>
<a href="http://www.cloudmark.com/"><span style='text-decoration:none'><img
border=0 width=224 height=41 src="cid:image001.gif@01C2EC9D.EC13B3D0"
alt="Cloudmark SpamNet - Join the fight against spam!"></span></a></span></font></p>
</div>
<p class=MsoNormal style='margin-left:1.0in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'><!-- A0C0A2D1C85242f096A170281367BF11 -->-----Original
Message-----<br>
<b><span style='font-weight:bold'>From:</span></b>
accessd-admin@databaseadvisors.com [mailto:accessd-admin@databaseadvisors.com] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Mark Boyd<br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, March 17, 2003 2:28
PM<br>
<b><span style='font-weight:bold'>To:</span></b> AccessD@databaseadvisors.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> [AccessD] Report Writer</span></font></p>
<p class=MsoNormal style='margin-left:1.0in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:1.0in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>I am curious if anyone has developed
an Access report writer.</span></font></p>
<p class=MsoNormal style='margin-left:1.0in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>I need to design one for a client
that can create customizable reports from SQL data.</span></font></p>
<p class=MsoNormal style='margin-left:1.0in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>I would have them use the built-in
report wizard, but they want to be able extract records based on specific
criteria.</span></font></p>
<p class=MsoNormal style='margin-left:1.0in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>Before starting from scratch, I
wanted to see if there is already something out there to point me in the right
direction.</span></font></p>
<p class=MsoNormal style='margin-left:1.0in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:1.0in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>Thanks,</span></font></p>
<p class=MsoAutoSig style='margin-left:1.0in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>Mark Boyd</span></font></p>
<p class=MsoAutoSig style='margin-left:1.0in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>Sr. Systems Analyst</span></font></p>
<p class=MsoAutoSig style='margin-left:1.0in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>McBee Associates, Inc.</span></font></p>
<p class=MsoNormal style='margin-left:1.0in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p style='margin-left:.5in'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>---<br>
Incoming mail is certified Virus Free.<br>
Checked by AVG anti-virus system (http://www.grisoft.com).<br>
Version: 6.0.461 / Virus Database: 260 - Release Date: 3/10/2003</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p style='margin-left:.5in'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>---<br>
Outgoing mail is certified Virus Free.<br>
Checked by AVG anti-virus system (http://www.grisoft.com).<br>
Version: 6.0.461 / Virus Database: 260 - Release Date: 3/10/2003</span></font></p>
</blockquote>
</div>
</body>
</html>
<BR>
<P><FONT SIZE=2>---<BR>
Incoming mail is certified Virus Free.<BR>
Checked by AVG anti-virus system (http://www.grisoft.com).<BR>
Version: 6.0.461 / Virus Database: 260 - Release Date: 3/10/2003<BR>
</FONT> </P>
<P><FONT SIZE=2 FACE="Arial"> </FONT> </P><BR>
<P><FONT SIZE=2>---<BR>
Outgoing mail is certified Virus Free.<BR>
Checked by AVG anti-virus system (http://www.grisoft.com).<BR>
Version: 6.0.461 / Virus Database: 260 - Release Date: 3/10/2003<BR>
</FONT> </P>
<P><FONT SIZE=2 FACE="Arial"> </FONT> </P>