Search results

bimp bamp bump

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...

Thanks for such a thorough answer, What a moron, I'll tell him. Not so: but based on your feedback, I will forgo the cases with blank events, as all cases should have events. I will produce a separate audit query for cases with no events. 3 - Great, thanks. 4 - Understood, tip for the future...

Thanks for your help, both, this is terrific - I was underestimating the complexity of the query. namliam, I didn't mean to cause offence, sorry, I think perhaps you overestimated my ability - I had no idea from your first post that you were intimating something as in-depth as what CXL & you...

Hi guys, Please find attached an example showing what I'm looking for. As before - each Case has 0 to many Events, I'd like an extract of all Cases showing the latest Event (including details of that Event) for each Case - where a Case has no Events it should show the Case with blanks in the...

Hi namliam, thanks for your suggestion, but by: I did mean to show the event details, not just the date of it. Hi Trevor, Thanks for your input, I'm sure you've seen it before, to protect the innocent I'll need to create a new db with just this info in, I was hoping not to need to do that...

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...

This is perfect, Chris, thank you very much.

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...