Remove Comma - Microsoft Access Forum - Computer Learning Zone


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Remove Comma

Michelle Seidelin

5 years ago

Hello Richard,

I am writing to you to ask you is there a way of removing the comma between as and the number of minutes example you will stay here
=[WholeHoursWorked] & " Hour" & IIf([WholeHoursWorked]=1,"""s") & ", " & [MinutesLeft] & " Minute" & IIf([MinutesLeft]=1,"","s")

	Michelle Seidelin OP @Reply 5 years ago
Correction to previous title how do you remove the comma between hours and minutes in timesheet video

	Richard Rost @Reply 5 years ago
Just literally delete the comma character.

	Alex Hedley @Reply 5 years ago
Before `=[WholeHoursWorked] & " Hour" & IIf([WholeHoursWorked]=1,"","s") & ", " & [MinutesLeft] & " Minute" & IIf([MinutesLeft]=1,"","s")` After `=[WholeHoursWorked] & " Hour" & IIf([WholeHoursWorked]=1,"","s") & " " & [MinutesLeft] & " Minute" & IIf([MinutesLeft]=1,"","s")`

	Michelle Seidelin OP @Reply 5 years ago
Hello Richard I know you have to remove the comma but I can't figure out which, rows so many commas and the statement just trying to figure out which, is the one that you have to remove

	Alex Hedley @Reply 5 years ago
I added an example to show you where to remove it

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View