select field by parameter

[rudwan]

hi
i have Table1 , consist of :
ID autonumber
MyMonth - text
Amount - number
MyMonth contain month's names like :
jan-05,feb-05,mar-05 ... etc
now , i would like to run a query to return only the
field which has current month and its amount ,
i have function called : current_month , this return name
of the current month as posted in MyMonth field
but when i select id,current_month(),amount from table1
it didnot introduce value of current_month(), it asked for
its value
how i could select the specific field from that table ?

 

[[MVP] S.Clark]

Try something like:

Select * from Table1 where MyMonth = Format(date(), "mmm-yy")