Search results

  1. A

    Adding query fields to a subform when the subform contains fields from a table

    Hi guys, since I'm not an expert with Access, I'm having lots of trouble with it. I want to create a form that contains a main form and a subform, and when the forms are filled out, they update information to two tables. So far, I've created a main form that can update info to the...
  2. A

    Iff and DateDiff

    IIf(day()>ReturnDate, DateDiff("d", day(), ReturnDate), 0) . . . I intend it to be: "If today's date is > ReturnDate, Find the difference between Today's date and the ReturnDate, Otherwise, return '0' as the number of days." Could somebody tell me why this formula isn't working out for me? It...
  3. A

    Query with counts, '0' values, and a calculation

    Hi guys, I tried looking up other threads in this forum for some problem similar to mine, but no luck. I'm trying to build a query that could calculate the # of available products in stock. It seems simple when you think of it, but I couldn't get the results that I needed and couldn't...
Back
Top Bottom