liveinhope
Well-known Member
- Joined
- Dec 16, 2013
- Messages
- 857
I have a table . 2 of the fields are land size area and building size area. both are defined in table view -> design view a 2 decimal places
I created a summary query with query wizard to show (summarised/grouped by ) city total, average min and max land area as expected a 4 show to 2 decimal places
I then used the query's design view to add the same 4 fields (ie total, average min and max ) for building size But all show with way too many decimal places
I also entered a couple of the "land area" fields (min and max) so that they show twice in the query .
the fields added to the query by the wizard show as 2 decimal places and those manually added to the query in design view shows a lots of decimal places
can anyone solve this ?
I created a summary query with query wizard to show (summarised/grouped by ) city total, average min and max land area as expected a 4 show to 2 decimal places
I then used the query's design view to add the same 4 fields (ie total, average min and max ) for building size But all show with way too many decimal places
I also entered a couple of the "land area" fields (min and max) so that they show twice in the query .
the fields added to the query by the wizard show as 2 decimal places and those manually added to the query in design view shows a lots of decimal places
can anyone solve this ?