Recent content by Skyshadow5

Thank you razchip & combo, will see what this allows me to do. Clive

Hi Duane, thanks for the reply. All the queries are Select queries simply pulling data from a variety of tables. I did try a one record table with from & to dates but made the mistake of joining it to another table; I'll try this approach again but without the join and see what happens, thank...

Thanks Andy, I guess I was trying to find a clever solution but really, if I just use the [date]-7 route, it would solve the vast majority of issues as I am going to be at work way more than not and can deal with the exceptions as necessary as I can't schedule it to run, that's not a...

Thanks for the reply Andy, although writing a Macro for this is a bit beyond me. I have 28 individual Aceess queries, I could use the Access Macro tool and run all 28 from here rather than running them one-by-one, but it's the date bit I'm stuck on. The dates will always be "the last seven days"...

Hi, I have 28 separate queries that need to be run and each one has a need to return data between two dates so my queries use the "Between [Start date] And [End date]" criteria. However this means that with 28 queries I have to manually type in the same start date and same end date 28 times...

Fascinating reading the interaction between you two, and learning so much more, thank you.

Many thanks guys for your efforts resolving this, much appreciated.

OK cool, thanks strongm.

Outlook 2010 (using MS Office 2010 Pro).

OK cool, many thanks MajP, and good luck!

Thanks for the reply MajP, I guessed this was going to be a tough nut to crack based on the lack of responses.

Desperately looking for a VBA solution to a tedious manual task. I have a requirement to count the number of emails received in a shared mailbox folder, note the date and time it was received, and then note the date and time of the reply so I can get a measure of the time taken to reply to an...

Hi, I have code that sends an email to each person in a table, the table has four columns, Firstname, Lastname, Email Address, Amount. The Amount is a total made up from one or more values. What I want to do is add to the body of the email message the results of a second table that holds the...

And it was that simple eh, I need a good slap round the head. Mind you it is 01:47 in the morning right now and I'm knackered, thank you again kind sir. Clive

Another question for you Skip (sorry), how do I count the number of values that make up the total? TIA Clive