Exporting & retaining field type

I have a select query with many fields. One of the field uses a
function -

LengthService: IIf(False,0,losactives([activeemp]![empdate]))

The field should function as a numeric field. When I export it to
excel, I can sort it numerically. However, when my coworker exports
the same query, this field appears in excel as a text field, and she
can't sort it properly. Any ideas? I'm not sure if this is a result of
excel or of access. Any help is appreciated.

.

Relevant Pages

  • RE: (Excel 2007) Query Data in Database?
    ... are both headers of the Sheet in Excel, ... Is the ADDRESS field to much for the Microsoft Jet database engine? ... When you do a query you should be selecting the columns You want to ... the sort has to be one of these columns. ...
    (microsoft.public.excel.programming)
  • RE: Query on Date range does not qualify the Year
    ... Now that you brought up the point of an alphabetic sort, ... So what is happening is that Excel during the query determines the data type ...
    (microsoft.public.excel.programming)
  • Week Number
    ... When i transfer the data into an excel, this field is shown as "ww" not ... I'd like to query the data by week number but that is also not possible ... and i guess thats because this field holds the date information behind ... Can you pls help me to sort out above problems. ...
    (microsoft.public.access.queries)
  • Re: Problem with repeated access to the datasource (Excel Spreadsh
    ... > sort of query in Access to combine the data from the spreadsheets into a ... You can certainly get data into Access in a number of ways (link to an Excel ... table, import data from an excel table, write a query that explicitly ...
    (microsoft.public.word.mailmerge.fields)
  • Re: save ~50,000 record table sorted from one million record table
    ... Excel is a spreadsheet, an excellent one. ... You can create a Query on your 1M+ table; ... clauses you want to sort the ...
    (microsoft.public.access.tablesdbdesign)