Substitute This For That
Jan 11, 2005
All of our book numbers have the # symbol in front of them. I want to run a query that shows the same book number but replaces the # symbol with an *. I don't want the actual fields to be changed in the database, i just want them to show up in the query that way. I know in excel you can use the substitute function, i.e. substitute(A1,"#","*") is there a similar function in access? I do not want to change the data in my tables, just be able to export the query showing the * instead of the #. Any ideas?
View Replies
Apr 19, 2007
I have asterisks "*" in a table in Access
The table is huge and Excel can't deal with it.
I tried ~* but it doesn't work in Access.
So what would you do?
View 3 Replies
View Related
Mar 10, 2007
I have designed a data entry form in MS Access 2003. One function I find frustrating is when I want to find a particular record while using this entry form. If I use the Edit>Find facility, for instance, looking for someone with the last name "Jones", eg, I must page through all the Joneses in the database by using either the "Next" button or by pressing the "Enter" key. This works but if I pass by the Jones I am looking for, I have to go all the way back to the first record and then slowly repeat the above process to find the Jones record I was looking for in the first place.
I am wondering if there is some VBA code somewhere that would pop up a table, for example, of all the Jones records in my database. Then I could simply click on the Jones' record of interest in this pop up table and go directly to this record in my data entry form.
Thanks in advance for any help you can give me.
View 1 Replies
View Related
