Search results

Hello, I have a query that I use to export in an xml type format. Is it possible to automate this so you don't have to select the database, then table, then highlight the query then go to file, export, choose xml etc ? Many thanks in advance

I have a query written on one PC. How can I transfer that Query to another PC ? I assume that it is all held in the actual database itself ? Many thanks in advance. Rowan

Fantastic That is great. Just one thing though the tag doesn't say surname but expr1 as pasted below. Is there anything I can do about that ??? <?xml version="1.0" encoding="UTF-8" ?> - <dataroot xmlns:od="urn:schemas-microsoft-com:officedata" generated="2004-04-23T18:10:01"> - <person>...

Sorry about that Perhaps I could explain what I am trying to do. I am trying to export data into an xml file through a query. The problem that I am having is that if say the surname field is left blank the xml tag does not get output. I need to force say a blank into the field so that the xml...

Help What I have got is a field called surname. If it is null I want to ouput a " " Can you help ?

I have the following in the criteria for the surname field... =IIf(IsNull([surname])," ",[surname]) but I get the following error...... Compile error in query expression. Any ideas ?

In a query I am outputing a field called employee_number. If the field is blank (null) what would I put into the expression of the query to fill it in with say the value "10" ? Help would be appreciated.

Hello, I have written a simple query that just selects 3 fields from a table. I want to export the query results into an xml file. I have no problem in doing that but I notice that if a field is blank in the table it does not output the XML tag as in <\empty_tag> Can someone please let me know...

Hello, I have written a simple query that just selects 3 fields from a table. I want to export the query results into an xml file. I have no problem in doing that but I notice that if a field is blank in the table it does not output the XML tag as in <\empty_tag> Can someone please let me know...