expression format

[stuckagain1]

I have a make-table query with this as an expression--Expr1: [Enter fiscal year for letter, ie 2004-05]. When the user enters 2004-05 (for example), it becomes a binary type of field........how can i format this so that it is a text entry?

thanks!

 

[PHV]

Defines the parameter type:
PARAMETERS [Enter fiscal year for letter, ie 2004-05] Text;
SELECT ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[stuckagain1]

excellent....thanks!