[AccessD] CrossTab Form

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.