Search results

Dear all, I have the query below that return a table like: PLOTNR; period,Value, ID, Basal_area/ha, Basal_area/ha, perc_BA_sp What I want to is to add another field that rank the perc_BA_sp by PLOTNR descending (thus highest perc_BA_sp values rank one etc.) could someone help me out of this...

HI Namlian, thanks for the feedback and for making the SQL more readable....as said I'm not an sql master :) Anyway, at the beginning the prob was "data type mismatch in criteria expression", then I discovered that there where empty field in Trees_2eBosinv.DBH_mm and Trees_2eBosinv.Height_m...

Hi There! I’m working on an (quite messy) access database not made from myself and I get an invalid procedure call in the query below . The behaviour is really strange, at least to a non expert of access as myself. Basically the query worked fine in a previous version of the database but after...