Dear friends, I deal with a very strange case. I have a report, dependent on a union query. In that report I have a text box with data source : =Format$([Item];"mmmm yy"). Item is a “field” from union query that’s can be either a date or an item. So, if the value is an item, I get the name of the item & if the value is a date I get the date like this: December 05. Now, when I run my db from my desktop pc everything works ok. But when I run it from my notebook, I cant put the above text box on my report (asks me about Format$…) so I put just the “field” from the union query and I get the name of the item or the date like this: 12/1/2005. Nota bene that both of my machines (desktop & notebook) run WinXpPro & MsAccess 2000. I am really confused! Any ideas? Thanks in advance Bill
------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/I258zB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
