Re: PARAMETER

With the help you have given me, so far I have been able to sort the
dates properly, give a value of 1 through 12.

I can enter this criteria: >"1" And <"9"and it works great; however,
this does not recognize >"1" And =<"12". Also it does not recognize
10, 11, or 12 if I just type >"3". So I guess I am still looking for
help for the criteria and parameter.

If I put this into criteria >="01**" And <="12**" for field:
Format([Birth Date],"mmdd"), it recognizes all but "12


If I type >="01**" And <="1231" then it works great. Now with this,
can someone help me with a parameter that will except these entries as
such?

HELP!

Thanks,Debbie

.

Relevant Pages

  • One More Formula Question
    ... I need to get a specific total from the following criteria. ... in 2 columns and need to get a total based upon specific entries in the ... doc's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1434 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Formula help
    ... I need to get a specific total from the following criteria. ... in 2 columns and need to get a total based upon specific entries in the ... doc's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1434 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • RE: query problem in report - repost
    ... Sort: ... "rfrench" wrote: ... >> putting them in the blank rows below 'criteria', ... Prev by Date: ...
    (microsoft.public.access.reports)
  • Q: Table within a table
    ... has other tables as entries? ... Does anybody have an idea of how to do this sort of thing? ... Geoff ... Prev by Date: ...
    (microsoft.public.vb.database.ado)
  • i cant format textbox as number!
    ... i want to sort the data given particular criteria ... barkiny's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=20397 ... Prev by Date: ...
    (microsoft.public.excel.programming)