Search results

Hey everyone, I was just interested in understanding how to filter my reports so only specific columns are displayed for them. For instance, if I have a table with the columns name, country, and job title - how would one filter a report so only two of the columns will appear as opposed to the...

That did ACHIEVE what I wanted thank you for your help. One last thing, what if I wanted to combine that with say criteria to specify the starting or ending character of that word. I tried to do Like "??h*" & "2*" for example and it went all weird?

Hi there, I was just wondering how one would filter results with the criteria for a certain character, such as saying a word's 3rd character has to be the letter "h" For instance, the word "achieve" would be found with this criteria as the third letter is "h" Thank you for this help.

Thank you for the help but I'm struggling to introduce it into my database. It keeps putting Where [Surname] in the field section and the Like [Forms]![Search Guests Form]![Surname] & "*" in the criteria area Is this normal? Sorry I'm really new to access 😅

Hi everyone, Having a tough time figuring out how to add additional criteria from the input a user gives from the form. [Forms]![Search Guests Form]![Surname] I would like to search surnames that only begin with a starting letter from the user input. I tried Like "[Forms]![Search Guests...