Search results

This seems an odd way of doing this - i would do this as follows extra field at the end of the transaction table (after currencytype) and have ExchangeRateUsed then just run an update once a month on the date range and per currency.. and bobs your uncle -

So what's good for the goose should be good for the gander ? accepting the above - kind'a rules out giving back any land for Northern Ireland to the Falklands the people who live there were not the original conquers and/or voted to stay - so any discussion needs to sort this issue out...

Move on - Boring

I must admit I didn't see this a a Anti American thing - more generalisation on the death penalty ... but if you re-read it it could/does read this way I am not anti american - I am anti double standards (that does include myself) I know that the UK has its flaws and in fact if you asked any...

First thing - Are you sure it has to be Word Spreadsheet (Excel) would be the logical choice for this Word is not a "data" friendly place to be in - - fine for pretty layout reports you can then export in to a pre-defined word document - loads of examples of this all over the place and do...

Is this a question /view on the death penalty or one countries approach to the death penalty. if your anti death penalty - then that's fine - If your pro death - that's fine - you can have a view - but your view will be slanted either way (Pro/Anti) it also depends on how you were...

And ..? what are you trying to achieve ? or bring to our attention ?

This is something I thought that I would like - and then had a re-think on it as pointed out. most inbox's are a nightmare - There are some who tidy up after themselves - better route would be move the email from that persons and drop it in to a folder that relates to that person - I do...

Cheers Paul I had a quick look - way over my head - but as long as it can be done .. If I need it , I can go down this route and figure it out If all I am getting (this is a pipeline project) is 1 or 2 files per day then its not going to be an issue - its if I suddenly got Volume files then...

Hi guys before I get to invovled what I want to do is import info from a file (either txt or xls) the file will be sent to me from a website (via outlook 2010 and access 2010) what I wanted to do is some how have Access check outlook folder for any new email (on a time schedule perhaps)...

Brian ... your formula is short (compared to my long winded one :-) but it's not quite doing it if you look at Row 56 your formula quotes 187 (column K ) but the actual number of days is 105 (column H) Once this (K column) is working - the rest is easy as it will be straight...

digesting still but "Obviously if range spans more than one tax year more work will be needed. Hope this is what you want." that's the issue - but I think what you have done - will point me in the right direction .

I am reviewing this (sorry for the delay in reverting) I will let you know if it works in the real data ... Big thanks in advance G

just uploaded a xls of the data - (no info of course ) I may have to dump in to dbase - but if i can live in xls would be easier

How many days in this range how many days in this range 06/04/12 to 05/04/13 06/04/13 to 05/04/14 06/04/2012 05/04/2013 Initials Date of Birth Level of Cover Country of Domicile Start Date Leave Date Days on Cover Annual Premium Pro-Rata Premium 14.06..15...

Either I am dumb (probably) or I have missed something the start date 01/10/12 and end date 31/09/13 how many days are their in each date range of the following tax year x (05/04/11 to 04/04/12) tax year x+1 (05/04/12 to 04/04/13) its easy if its fixed but the start date could be...

I was going to - but would be ok use date year start to tax year end = number of days

Hey guys bit of a weird one here I have been asked (Excel) to find out how many days fall in a date range simples .. however here it is start date X =01.11.12 to Y = 31.10.13 start date could be any date > 01.11.12 and end date could be any date up to 31.10.13 how many days are in the...

from what I gather - he was not the strongest of presidents -but I am sure he's a nice guy. hope - when he goes- its a peaceful exit .

politicians... good, honest, and decent person...??? no those two statements don't go together ..irrespective of whom no decent person would go in to politics