Search results

i am working on a Crosstab query. everything works fine until i start creating or recoding variables. then i receive 2 types of errors - - 'Data type mismatch in criteria expression' and - 'Access database engine does not recognize [borough] as valid field name or expression'. now, i think...

thanks a bunch George. i am still struggling, but i think i'm almost there. just need a break... have a great weekend! l

after spending all day yesterday trying to make your concept work, i've pretty much given up. not bright enough, i guess.. if you have a chance George, could you please briefly explain the principle behind it. on the bright side, i managed to come up with my own way of doing this task. sort...

thanks George. this is pretty complicated for my level of access knowledge, so it will take me a while to make it work.. i'll let you know. l

yep. they just came up as first records in their respective inspection.. btw, there may be more or less than 3 different 'features' per inspection..

- the result of this query will be used by excel pivot table(s), and i want the excel file to have everything it needs in this dataset, hence unique identifiers; - the row will be unique because it has the same "inspection id", but different "features" (and possibly "ratings"). actually, let...

thanks george. below is the full sql statement. i just thought it was too complex, so i shrunk it to its essence. SELECT...

hi. first of all, i am glad to join this lovely forum. i've read some threads, people here are very very helpful.. now the question (please bear with me if it's too basic, i am relatively new to Access): i've created a 'select' query which does everything for me, except one thing - it doesn't...