Recent content by leebo1973

Again, thanks So I have a column called Project Fee, which has all the values I want to bracket. Have created the table with the 3 columns as suggested How do I get the Bracket Result in the query??

Thanks I dont understand where I am supposed to typr the bot about STartNumber>= etc???

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

i wanted the query to be a Make Table query

Clever, thanks If i run the query as a Select query it works fine, but whn I try to create a Table I get the subscript error again. If i just click End it eventually works???

Great, thanks I've managed to get that bit working. However some of the results are blank. ANy idea's 95 Willian Road, Hitchin, SG4 OLS has returned a blank result

am just running a query against the data that I included in my original post Thanks

am now getting Subscript out of range and its highlights the following: tmpPCode = tmpArr(pLoc - 1) & " " & tmpArr(pLoc)

thanks now getting the following: Compile Error: only comments may appear after End Sub, Ed Function or Ed Property at the following: 'UK Postcode Public Const rgxZIP_UK = "(?:(?:A[BL]|B[ABDHLNRST]?|" _ & "C[ABFHMORTVW]|D[ADEGHLNTY]|E[CHNX]?|F[KY]|G[LUY]?|" _...

have copied everything as suggested and saved as a module have also copied all the code for the other module When I debug though I get Complie Erro: Arguement not optional, and it highlights the rgxValidate text

forgive me am fairly new too this, so havent done what you ahve suggested as dont know how to????

Thanks Keep getting an Undefined function error