Search results

  1. A

    sql sum as variable - how to?

    right. thank you guys!
  2. A

    sql sum as variable - how to?

    ok, one mistake is that i should use having instead of where. having that table: field condition_a condition_b 2 a b 3 c b 4 a b i'd like to receive 6. so i try to append the table with query given earlier, but this doesn't...
  3. A

    sql sum as variable - how to?

    hello, i am trying to get a sum of specified fields as a variable. i tried to do that this way: Dim db As DAO.Database Set db = CurrentDb Dim rst_tmp As DAO.Recordset Set rst_tmp = db.OpenRecordset("SELECT field FROM table WHERE field=(SELECT SUM(field) FROM table HAVING condition_a='a' AND...
  4. A

    how to get a value from combobox

    Ok. this is a stupid question, but i am in a hurry and new to vba programming. I need to collect two parameters into my vba code-wanted to do it with dialog box, but thought that getting value from a form would be better - and this is the question, how do i access the value of combobox in any form?
Back
Top Bottom