Thanks for your help. Please see the enclosed. This is a simplified version but the result I want to get in the query is:
Sites 30
Buildings 50
Size 283
I have tried altering unique values/records but has no effect
Thanks
hi everyone - still struggling with this one. To produce a totals query (i.e. one line) that counts
4 sites
8 buildings
and sums the cost information for all the buildings/sites
as indicated by the attached pdf.
At the moment, the queries that I produce will show 8 sites and 8 buildings. Not...
I get the right number of sites and buildings from this table but not from my main database which gives me the same number (the larger one) for both.
Thanks
Hi Everyone
I am an occasional user of access. My basic knowledge is ok but beyond that I struggle.
My problem is a have a table of property information. I have a number of sites and some of the sites have a number of buildings so for example I am trying to use a query to summarise the data...