John H. Rodgers on sun 8 mar 98
-- [ From: John H. Rodgers * EMC.Ver #2.5.02 ] --
I am starting to keep a database of glazes I use using MS Access and I have
a report generation question on how to create a report that shows only those
fields(chemical names) that have a quantity listed. If no quantity is shown,
or is zero, I don't want the field name to show or print.
Not exactly directly clay but for me its related to my records management
in clay. If someone could help, I would appreciate it. Unless this is of
interest to the membership, and requested to be kept on the list as a thread
, please respond by E-mail off the list so as not clutter things up with a
bunch of computer stuff.
Thanks,
John Rodgers
In Alabama
Scott B. Earl on tue 10 mar 98
John:
This is one way that I have used. Another may work as
well. When you enter the data base, click on the query tab.
Make a query that includes a field criteria that reads:
<>"" And <> "0"
(There is NOT a space between the quotes.)
Interpreted, this would read "Include this if the cell
contents are greater than or less than nothing AND the
cell contents are greater than or less than 0."
Next, build your report based on the data delivered by this
query. This is done in the properties dialog box of the
report.
Hope this helps.
Scott
> ----------------------------Original message----------------------------
> -- [ From: John H. Rodgers * EMC.Ver #2.5.02 ] --
>
> I am starting to keep a database of glazes I use using MS Access and I have
> a report generation question on how to create a report that shows only those
> fields(chemical names) that have a quantity listed. If no quantity is shown,
> or is zero, I don't want the field name to show or print.
>
> Not exactly directly clay but for me its related to my records management
> in clay. If someone could help, I would appreciate it. Unless this is of
> interest to the membership, and requested to be kept on the list as a thread
> , please respond by E-mail off the list so as not clutter things up with a
> bunch of computer stuff.
>
> Thanks,
>
> John Rodgers
> In Alabama
>
______________________________________
Best Regards,
Scott B. Earl
Communication Certification Laboratory
801.972.6146
sbe@cclab.com
______________________________________
Neil Berkowitz on wed 11 mar 98
Scott B. Earl wrote:
>
> John:
>
> This is one way that I have used. Another may work as
> well. When you enter the data base, click on the query tab.
> Make a query that includes a field criteria that reads:
> <>"" And <> "0"
> (There is NOT a space between the quotes.)
> Interpreted, this would read "Include this if the cell
> contents are greater than or less than nothing AND the
> cell contents are greater than or less than 0."
>
> Next, build your report based on the data delivered by this
> query. This is done in the properties dialog box of the
> report.
>
> Hope this helps.
>
> Scott
>
> > -------------------------Original message----------------------------
> >
> > I am starting to keep a database of glazes I use using MS Access and
> > I have a report generation question on how to create a report that
> > shows only those fields(chemical names) that have a quantity listed.
> > If no quantity is shown, or is zero, I don't want the field name to
> > show or print.
> >
I'm replying to the list as a whole in case others were intrigued by
using Access in this way. I'd suggest one of three different
approaches, which should avoid the complexity of the query and would
produce a cleaner, more readable report.
The first approach is to review the structure of the tables involved.
Do I undertand that you have a field for each possible material? If so,
you might consider having a separate look up table for the materials and
a recipe table with fields like Material1, Measure1, Material2,
Measure2, and so on. You would pick the values for the Materialx fields
from a combo box getting with the materials lookup table as its source.
(You could even add a field to the lookup table to filter the display
for glaze materials, clay body materials, etc.) In the Measurex fields
you would enter the quantity information for the that material. This
should make designing and reading your reports much easier, and it would
allow you more possibilities in expanding your data to include things
like materials inventory, costs, etc.
A less sound approach is to retain your structure and write a module to
that would assign values to a two-dimensional array. One dimension
would be for the material/field name, the other for the field value/
measurement. As with the first approach, it allows a report where you
do not have to deal with objects for each material but only for the
variable first material, second material, etc. It does, however, retain
an underlying structure that will unnecessarily limit future use and
scope of your data.
If there are reasons why it would be useful to have recipes in both my
format and yours, a third approach is to use a form createbased on my
structure and have it create a record in the old table when it adds a
record to the new.
Maybe after all the best approach is to sample an off the shelf glaze
analysis program and take advantage of the additional features they
provide.
Feel free to contact me off-list for further discussion.
--
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
Neil Berkowitz
neilmber@ix.netcom.com
http://www.netcom.com/~neilmber/
| |
|
