Sample Header Ad - 728x90

How to design a query to pop up input with two text boxes in MS Access

1 vote
1 answer
199 views
I ask this question while I could not find any similar question neither on Google nor DBA Stackexchange, this question might be duplicated.
I wrote this query in MS access to check for first name and surname. But every time I run the query, I see two little input boxes which come after each other. I want to change my query so that I enter first name and surname in One/Single input box.
How can I design something like this?

Here is what I achieved up until this point:
SELECT tblGuests.firstname, tblGuests.surname
FROM tblGuests
WHERE (((tblGuests.firstname) Like "*" & [Enter Firstname] & "*") OR ((tblGuests.surname) Like "*" & [Enter Surname] & "*"));
Asked by Mr JJ (11 rep)
Apr 26, 2021, 09:01 AM
Last activity: Jun 19, 2025, 12:05 AM