Search results

Thanks for your advice - I'll give that a go. Wisso

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...

This works but doesn't in my main database Thanks

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...