Search results

I have data that is in Format A and need the data to be like Format B. There are 400 columns in Format A and 19 rows. How can I get the data into Format B? Format A: This is the format that the data is in HRS-Billing MLTC - 14200 Indianola 3881229 18211 \+15551056305 28393 \+15551018287...

I have a file that is a system export. Some of the times are formatted in hh:mm:ss format and I'm unable to change the format. Any ideals on how this can be changed?

I've been running this query IIf([Agent Name] Is Null,"NoName",[Agent Name]) to write NoName to a Null field. Recently, the statement will not write the value in the table with the Null field. I import the table from Excel and have used the LEN statement in Excel to look for hidden characters in...

I've got a data string that has an * in it followed by a comma with data with characters after it. I need to remove the * and all of the characters to the right after it. The range of characters vary in length. Data Sample; CSQ_ACNY_Team1*, CSQ_ACNY_AllOther CSQ_ACNY_Team1* I've tried using...

Hi, My name is Charles, I'm a PMP that do a lot of reports and have use Access, know how to use the basic features but often get stuck on doing more complex queries. I live in the DFW and love fishing, racing and teaching the bible.