Search results for query: *

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

Thank you Skip, after changing my results table to have the upper and lower criteria values in cells of their own to allow the "less than" and "greater than" signs to work, I named my ranges with their correct titles ("Value" was just a place-holder as was "Comp" to protect the privacy of my...

OK so the attachment didn't work. Comp Value Comp 0-200 201-400 401-600 AAAAA 117.33 AAAAA 200.13 0.00 0.00 BBBBB 84.00 BBBBB 207.40 219.38 0.00 CCCCC 40.00 CCCCC 40.00 208.08 413.17 DDDDD 187.32 DDDDD 382.32 343.36 0.00 EEEEE 263.44 EEEEE 235.45 263.44...

I need some help please. I'm using Excel 2003 to return some values from a large spreadsheet. The values need to be summed but only if matching 2 criteria. Column 1 holds a company name (there are 5 different names), column O holds the value. I need the sum of values where column 1 matches 1 of...

I'll give it a try and let you know, thanks Hugh.

Thank you Hugh, you're a star. I guess when you know, you know. I've added the code and it works a treat (and commented you at the end of each change/addition, credit to you, not me bud). I can use this in some of my other projects as well, thanks again.