[AccessD] CrossTab Form

Thanks for the suggestion, but the client is moving away from Excel 
for these reports.

David

At 6/03/2008, you wrote:


>This is probably not the answer you are looking for, but if are 
>willing to use Excel for Pivot table work you will get a much better 
>result.  However that may not suit your, or your client's useability 
>requirements.
>
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of David Emerson
>Sent: Thursday, 6 March 2008 1:45 PM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] CrossTab Form
>
>
>I have an Access XP form (from a legacy database) that is based on a
>crosstab query.  Across the top are a list of products.  Down the
>first column are a list of headings: Opening Balance, Stock In, Total
>Stock, Stock Out, Stock Out Percentage, Closing Balance etc (there
>are 25 rows in total).  The data is gathered from a number of other
>tables and queries which are linked only by the product code and are
>in different formats, and then placed in a temporary table for the
>crosstab.  The number of fields is consistent - there will always be
>the same products, and the same headings (therefore the use of a
>cross tab is not for flexibility of changing products, but to get the
>data into the required format).  There are 16 products and 25
>headings, therefore 400 fields of data.
>
>Most of the rows are standard numbers but some are percentages.  The
>problem is that all rows are formatted the same way with no decimal
>places.  This means that the percentage rows only show whole
>percentages (the numbers are calculated so that 2.75% is stored as
>2.75 and shows as 3).  What I am looking for is a simple solution
>where I can format each row of data on the continuous form to suit
>the type of data.
>
>The sledgehammer way is to create a table with one row and a text box
>for all 400 fields.  This would then be used on a form which is set
>out in a row format.
>
>I suggested that the form be turned around so that the products are
>down the side and the headings across the top (in standard Access
>fashion) but this is not the format the client wants.
>
>Is there any easy way around this?
>
>Regards
>
>David Emerson
>Dalyn Software Ltd
>Wellington, New Zealand
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>This email and any attachments may contain privileged and 
>confidential information and are intended for the named addressee 
>only. If you have received this e-mail in error, please notify the 
>sender and delete this e-mail immediately. Any confidentiality, 
>privilege or copyright is not waived or lost because this e-mail has 
>been sent to you in error. It is your responsibility to check this 
>e-mail and any attachments for viruses.  No warranty is made that 
>this material is free from computer virus or any other defect or 
>error.  Any loss/damage incurred by using this material is not the 
>sender's responsibility.  The sender's entire liability will be 
>limited to resupplying the material.
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com