I have a staff schedule in excel that I linked to access with the the first column labeled staff and the rest of the columns afterward of the days of the week (SUN-SAT). Below those columns are the info of the staff names in the first column and the schedule info in the rest of the columns of Sun-Sat. One example of a cell block in Monday would include the following "9:00am-12:00pm Susan Wright (B)" I am trying to pull in the query design all the cells that contain (B). As (B) indicates a specific facility. I have tried wildcards *, "", [], "**", Like "", Like "**". But I never get any records back. Is it because there is too much text in the cell block? Am I not supposed to use the wildcard in all the columns? Am I supposed to use it only in one column? I'm trying to pull all the (B) throughout the week with the staff names. Is this a SQL fix? Forgive me for all my questions I've been racking my brain on this and I really don't know what to do. In trying to get my new company up to speed in modern times and leave their dinosaur age from doing everything manually. Please, please, please help 🙏
Kevin Robertson
@Reply 2 years ago
Try it like this:
Like "*(B)*"
or since (B) is at the end of the string:
Like "*(B)"
Pauline HowieOP
@Reply
2 years ago
Hello I couldn't reply to my original post but the guidance I received unfortunately is still not allowing me to pull any records/results. If anyone can help I would be forever grateful 🙏
Kevin Yip
@Reply 2 years ago
Show your complete SQL statement. Maybe something is amiss there.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.