Search results

  1. C

    Delete record from one side of select query

    The bottom post of this thread exactly sums up my situation: http://www.accessmonster.com/Uwe/Forum.aspx/access-gettingstarted/5482/Deleting-Records-does-not-Delete-Records Cases (1): Events (many) and Events (1): Payments (0-1) i.e. each event optionally has a payment. (The Cases table is not...
  2. C

    Latest event for each case

    AKA 'another subquery question' I know the answer is almost certainly here, but I've been wrestling for a long time and I'm stuck. If someone wouldn't mind showing me how to make it work with my specific tables I'd be really grateful: I have a table of Cases and a table of Events, each Case...
  3. C

    Enter text info but return id to table

    Hi all, I'm sure this is a totally amateur question, sorry, but I'm a totally amateur access user, so I have limited options. I am tryoing to create a very small call-logging database. I have a table for calls and a table for people who might make the calls. I need each call to have the...
Back
Top Bottom