Search results

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:

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:

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

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:

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"...

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

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:

Hi I'm great at Excel but a newbie to ACCESS 2013. Can anyone tell me how to remove all spaces from text (Postcode). I have tried a replace function but any postcodes without spaces show as an #Error I would like it as a query not VBA. Thanks for your help