Hi,
I wonder if someone might be able to help me please.
I'm fairly new to MS Access, and everything I know is self taught so please
bear with me.
I have put together a query which consists of a few fields. Some of these
have parameters which I've added to them. This in turn feeds a report.
The problem I have is that I don't always want to key in the parameters i.e.
I want to see all the data instead of it being filtered.
I have seen a very similar post on this site, with a possible solution, but
for the life of me can't get it to work i.e. where I can just click 'Go' and
it gives me all the data, but by typing in the parameters it give me the
filtered data. I just wondered whether someone could provide me with a bit of
guidance please.
The code is:
Like IIf([Year] Is Null,"*",[Year])
Where 'Year' is the field name. I have then changed this to 'Surname',
'Forename' and so on and so forth for my other fields and I have typed this
into each criteria line for the different fields.
I get all the data when I don't key the parameters in, which is obviously
what I want, but when I do I can't get the filtered data.
Any ideas please?
Regards
Chris
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200801/1