Returning Nulls

  • Thread starter Thread starter G Swinton
  • Start date Start date
G

G Swinton

How can you include nulls in a result when you want to
leave the criteria optional:- I have tried Like [enter
name] & "*" but this shows everything EXCEPT nulls?
 
Many thanks. Worked a treat.
-----Original Message-----
Take a look at the article at
http://support.microsoft.com/default.aspx?scid=kb;en- us;209261.

The technique there should do the trick for you.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com


How can you include nulls in a result when you want to
leave the criteria optional:- I have tried Like [enter
name] & "*" but this shows everything EXCEPT nulls?
Click to expand...


.
Click to expand...
 
You're welcome.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com


Gill said:
Many thanks. Worked a treat.
-----Original Message-----
Take a look at the article at
http://support.microsoft.com/default.aspx?scid=kb;en- us;209261.

The technique there should do the trick for you.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com


How can you include nulls in a result when you want to
leave the criteria optional:- I have tried Like [enter
name] & "*" but this shows everything EXCEPT nulls?
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top