Search results

Hi everybody, I'm having quiete a problem with the case instruction. I have the folowing query: Select station, count(case poc_1 when 1 then 1 end), count(case poc_1 when 2 then 1 end) From poc group by station Well Acces tells me there is a syntax error in the case instruction???Can't...

Hi, Can anybody tell me how you automatically move to a new empty record when you open a Form? Till now, I always had the last record displayed. Thanx for your help Sav

Hi, How can I change certain values of an SQL query with a macro? What I'm trying to do, is to adapt the queries to the specifications of my forms. Thanks for your help Sav

Hi, I'm trying to set a default value to field in a form. The field relates to Table 1 and I need a value from Table 2 as Default! I've tried entering an SQL query: Select Max(ID) From.... ; But it doesn't work! Maybe It's just a question of syntax?? Thanx for your help.