morning all
I have a list of values that I would like to put easily into bands like
0-100
101-200
201-300
If there something easy I can do, and i have values ranging from 0 to 25,000
Thanks
hi all
I have a list of what should be sequentaia numbers, but I am finding instances were a number seems to be missing
Is there a way to query the whole dataset and find all missing instances without having to trawl he list?
Thanks
Lee
morning all
I have the following data set:
Name Date Start PostCode EndPostcode
I have sorted the data by Name and Date
I want to be able to say that if the Name is the same as the Previous Record, and the Date is the same as the previosu record, then the Start PostCode is the End...
Hi all
I have a list of dates on which tasks were performed.
I want to be able to see if there is a pattern, i.e. lots done on a Monday
Can I extract the Day from the date, and return a value Monday, Tuesday, Wednesday etc??
Thanks
Hi all
I have a table with a string field included for an address.
Some rows have postcodes and some dont
How can I extract the PostCode values from the field please??
Thanks
Good afternoon
I have a list postcodes and need to work out the distance between them.
Can anyone recommend a good program, or has anyone done something similar please?
THanks
Good afternoon
I have a list of project, each of which have dates which work were carried out on them. Each project can have more than one date. I want to be able to find the last date that any work was carried out, and then calculate how many days have passed since that happened.
All help...