dz2k7 Not only User Local time Yesterday, 22:39 Joined Apr 19, 2007 Messages 104 Apr 19, 2007 #1 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? Last edited: 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?
boblarson Smeghead Local time Yesterday, 22:39 Joined Jan 12, 2001 Messages 32,059 Apr 19, 2007 #2 You posted this in the wrong forum category, so I moved it for you. You don't post questions to the samples category.
You posted this in the wrong forum category, so I moved it for you. You don't post questions to the samples category.
R RoyVidar Registered User. Local time Today, 07:39 Joined Sep 25, 2000 Messages 805 Apr 19, 2007 #3 Try either enclosing in [brackets], or for instance the InStr function Like "*[*]*" InStr([MyField];"*")>0
Try either enclosing in [brackets], or for instance the InStr function Like "*[*]*" InStr([MyField];"*")>0
dz2k7 Not only User Local time Yesterday, 22:39 Joined Apr 19, 2007 Messages 104 Apr 19, 2007 #4 it works! thank you it looks like it's a good place to ask questions