Search results

  1. A

    Using Derived Column in Where Condition

    Can you please explain how to use nz and iff?
  2. A

    Using Derived Column in Where Condition

    I am making queries using VBA in Access. I have one query temp3 that returns several records with columns ID, Diff etc. I would like to filter the results of temp3 further using the condition temp3.[Diff] <> 0 I could not use this condition within temp3 because Diff is a derived column. So I...
  3. A

    Multiple dependent combo boxes

    Hi I have a date field. I have two combo boxes. One for year and One for month. I have already written code for the year combo box to show only the unique years represented in the date field. I am now trying to make the month combo box show only months present in the year selected. Also the...
  4. A

    Form Filter Question

    I have a form that has four combo boxes FromMonth, FromYear, ToMonth, ToYear I have a dropdown list for each of them. I am doing it this way, because the data comes in once every month. So only month and year are relevant. I use the following code to convert them to date format: fromdate =...
  5. A

    Problem with Update Command in Access

    Thanks ! That worked... The two variables was a typo and I did call my table 1.
  6. A

    Problem with Update Command in Access

    I am trying to populate the SaleDate column in my table using the UPDATE command. Dim mydate As Date mydate = DateValue("01/" & strmonth & "/" & stryear) MsgBox ldate (shows date in mm/dd/yyyy format correctly) When I try to use mydate in the UPDATE statement, I get the error: too few...
Back
Top Bottom