Recent content by robwilsonirl

I went with BrianWarnocks approach and mostly have what i need SELECT account, [Process Name], [Date/Time] FROM statsdata WHERE account in ( SELECT account FROM statsdata GROUP BY account HAVING (Sum(IIf( [Task]="sweep",1,0))>minTasks) AND (Sum(IIf([Process...

Apologies, folks. I have been sidetracked with other work and haven't had a chance to get back to this yet. Hopefully i will in the next week or so. Just wanted to say thanks for the replies and i will definitely get to them, try them out and revert : )

@jdraw - this is just a single table imported from Excel. So, i don't have any relationships diagrams. I will need to manipulate (rename, remove sensitive data etc) the table, as i wouldn't be able to post some of the data. But, i will try and get a modified table up today/tomorrow @pbrown...

Sorry, i'll try explain it a bit better. There are more than just Sweep tasks. But i am only interested in extracting tasks of type Sweep. This is why i am showing the task column in my example. There can be 1 to many tasks in a Process. The data i have is usgae data extracted from a fund...

Hi I've an access query which i am trying to write but getting very confused and am considering writing it as a VBA macro. If anyone could help with the SQL query, i'd be very grateful. My issue is as follows. I have users who run processes for a given account. Each process contains a...

Hey everyone I'm in IT for 17 years now. Started off on Pascal on a VAX (for younger folk, this is a DEC mainframe - not a vacuum cleaner/hoover!). Stayed on a VAX/Alpha and "progressed" to Cobol, DecForms and Oracle RDB. While staying on mainframe over the years, i picked up some VB and VBA...