Access query empty field

Question

Hello,
I have a problem with Access and I don't know anything about SQL mode.
I need to create a price database in this software. I'm encountering an issue with the queries.
I want to execute ONE query (which will later become a form for presentation) with multiple criteria such as [What service?] then [What type of service?] then [What detail?], [For which site?] and so on. It works if I enter a word for each of the questions. However, I would sometimes like to be able to answer only one of all these questions, for example, a type of service for a given site without specifying the type or the detail. I tried pressing "Enter" when I want to display nothing in particular, but the software considers this as empty, and since it doesn't find an empty in the database, it doesn't display anything. How can I indicate that I want it to display everything if I don't impose a specific term?
I hope you can help me.
Thanks anyway.
L.

Configuration: Windows XP Internet Explorer 7.0

Laurine1985 · Accepted Answer

I found it! But thank you anyway for all your answers.  In fact, it was necessary to write on the criteria line:  As [indicate your service?] & "*"  Maybe this will help someone.  L.

Le Pingou · Answer

Hello,
Just passing by, I think you need to use a macro that will build your SQL code according to the filtering you want (check for the presence of a value in the criterion field).
--

Regards.
Jean-Pierre

Laurine1985 · Answer

I don't know how to do that. Isn't it possible to go through the usual interface? Thank you.

fmvgld · Answer

Just put * (asterisk) in place of your search criteria Access will take it as all your data.

Laurine1985 · Answer

It doesn't work with an asterisk. Actually, I don't want to use an asterisk in the criterion.
But it should be that when I run the query, I have the option to respond (if I want a clarification) or to skip the question (if I want to keep everything). And when I skip the question, it considers that as empty and thus returns an empty table instead of retrieving all the data.
Thank you for your help.

Laurine1985 · Answer

I'm sorry to insist, but it's not working.  When I respond * to my question, it doesn't display anything for me, just like when I press "enter".

Laurine1985 · Answer

I am using Access 2007.
Actually, I want that when I run the parameter query with several criteria (at least 4), I have the choice to either enter a parameter or skip the next question (if I want everything for example). When I enter * or hit enter, it doesn't display anything, whereas I would like it to show ALL when I do not specify my parameter.
For example, if I enter a "service type", I want the option to select a specific "type" or to let all of them display.
Thank you anyway.

Le Pingou · Answer

Hello Laurine85,
It would be good if you could provide a copy of the SGL code of your query.
To do this, open your query in "Edit" mode, then click on "SQL Mode" in the View menu..... make a copy and paste it into your message.

--

Regards.
Jean-Pierre

Access query empty field

8 answers

Texture issues in enshrouded

Wireless printer setup

How to install an esim on a samsung smartwatch

My surface pro 4 tablet is saturated

Problem with my sound!

Trojan horse, virus

1080p wifi surveillance camera

Infection possible

"long press issue #" on gigaset a420

Dropdowns - space issue