Search results

  1. R

    Automate an export

    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
  2. R

    Importing a query

    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
  3. R

    error in a query

    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 ?
  4. R

    Changing values in a query

    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.
  5. R

    xml output from an access table

    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...
  6. R

    XML Output

    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...
Back
Top Bottom