Search results

Bob Thanks for your code. This still gives a column in which the value is not "yes". I had posted in comp.databases.ms-access and learnt that a query cannot "decide" to leave out a column but the sql below does give me the answer by listing the columns which have a "yes" in one column and...

Bob apologies for the name error. Your sql works except that it shows "no" in the btec_intro column and I am hoping to be able to not show those columns with "no" in them. ? Cheers Geoff SELECT the_2011.school_name, the_2011.btec_intro, the_2011.btec_first_unit1...

Bob I seem to be missing the point! The sql is below but this lists all the schools and I want to just give results for Greens School and not to show columns if the entry is not "yes". ??! Cheers Geoff SELECT the_schools.school_name, the_2011.btec_intro, the_2011.btec_first_unit1...

Thanks for your reply. I have tried entering "yes" in the criteria but have just realised the error in my thinking! Any column may have just one "yes" in it and all the other entries will be "no" - but that column will have to be there. How can I generate queries for each individual record...

Hello I have a table with some 20 columns one of which can have the text "yes" in it or is left blank. I would like to have a query which only shows those columns with "yes" in them. At the moment I see all the columns, those with and those without the "yes" ... By the way I changed from...

I did think I had the brackets as follows and Access didn't accept it - well it does now and this seems OK! WHERE (((best_2011.start1) Between DateSerial(Year(Date())-1,Month(Date()),1) And (DateAdd("m",1,(DateSerial(Year(Date())-1,Month(Date()),1))-1))) AND (...

I have changed the table name so now have WHERE (((best_2011.start1) Between DateSerial(Year(Date())-1,Month(Date()),1) And (DateAdd("m",1,(DateSerial(Year(Date())-1,Month(Date()),1))-1))) AND ((best_2011.btec_first_unit1)="yes")) OR (((best_2011.btec_first_unit2)="yes")); This is wrong...

I thought the sql following would be right but it isn't !? Geoff WHERE ((([0-BEST-members-web-subscriptions-and-cds].start1) Between DateSerial(Year(Date())-1,Month(Date()),1) And (DateAdd("m",1,(DateSerial(Year(Date())-1,Month(Date()),1))-1))) AND...

Thanks for thr above - I am now trying to extend this to get those records in this month a year ago where field1 ="yes" or field2 ="yes" etc, The sql following does not do this. How do I change it? Cheers Geoff WHERE ((([0-BEST-members-web-subscriptions-and-cds].start1) Between...

Hello I have a table with a date field in it and would like to be able to find those records which have a date in the same month as now, but 1 year ago. Is it possible to have a general query which will work regardless of which actual month is the current month? DateAdd() has been suggested...