Update: Hello again,
ok - after lots of swearing and mouse banging i worked out that you can do that in the main form properties. 1. create a query and save it. (with your "AS" field) 2. Main form properties ( "Content Type" -> query (NOT mysql command - just wont accept things like 7 < 8 returning false/true) 3. "Content" -> the query name that you saved. 3. Now you can put in a text box the "AS" field (from drop down list) I am happy with that - pause - Well - i was happy with that but this way the form is read only (cos of query result). So the question is - how can you (can one?) do that without the form being read only? Walter ########## original message ##################### Hello, i am using the base program as an frontend for mysql via the odbc driver. Using forms, i cannot work out how to do the following: is it possible to somehow enter something like =datediff(outdate,indate) in the datafield of an textbox in a form and if yes - what format does the string need to be? Thanks for any help Walter --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
