Search results

Great - thanks for your help

That makes sense - thanks very much for your help

Hi - Is it possible to show a tick mark instead of the word "passed"? I have the character in wingdings font but not sure that can be used in this way? PassStatus: IIf([status]=0,"X",IIf([status]=1,"Passed","error")) Thanks PG:banghead:

Thanks very much - can use that too. Thanks again

Look at that - spot on! Thanks very much

As easy as it sounds I don't seem to be able to get this right. Looking for a query that will take a value say 4.5 and convert to datevalue in hours so will end up as 04:30:00 Any help appreciated. Thanks :banghead:

That's got it! Thanks very much for your help.:)

Thanks - afraid I am a bit of a numpty with access and cannot see how to construct MOD in a query string. Any example would be a great help.

Hi scratching my head to get an IIF for odds or even in numbers. Ie if its an even number state "EVEN" in column. Obviously if odd state "ODD".:confused: Any ideas please. Thanks PG

Thanks everyone for your help.. I think I have cheated - not sure its good but seems to work :eek: SHORTPOSTCODE: (Left([postcode],1) & IIf(IsNumeric(Right(Left([postcode],2),1))=False,Right(Left([postcode],2),1),""))

Hi, I have a number of short postcodes ie S43 GU10 ME8 etc etc I want a run query to return only first characters before the numbers ie.. S GU ME Any ideas please? :banghead:

I spotted a missing quote mark on your word "small" and it works - brill! you saved me a lot of time :) Thanks for you help

Hi, I am sure this is simple but cannot seem to get it right. I want to run a query that returns a "small" or "medium" or "large" etc on each respective row against another columns respective numeric value... < 500 = "small" 500 up to 1000 = "medium"...

Brillian - thanks so much

Hi, I am looking to add a column in a query that will give a Y or No to previous column data if it contains TEXT or NUMBER (It could read "TEXT" or "NUMBER" or even Y for text or N for number). Hope I have explained that properly.:rolleyes: Thanks

Brilliant, brilliant - thanks for your help! Works a treat. Cheers

Can anyone help me with this? Produce a query that returns a yes or no (Y or N) field if other text field contains particular text (with wildcard on either side). Idea is to have a column for each preset word. Hope that makes sense, Access newbie :banghead:

Thanks very much - it will come into use shortly. Cheers for that!

Brilliant! That got it first time - thanks very much for your help. :)

Hi Paul and thanks for the welcome. I am using Expr1: [Field1]=Replace([field1]," "," ") I have just revisited the problem and it appears the #Error displays when there is no postcode but at the moment the only return I am getting now is -1 ? Looking to query Postcode field 1 and...