Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Posts
    1

    Question Unanswered: User Input Date Saved As Binary Type In Table

    Hello there. I am trying to take a user defined date range (start date and end date) in a sub query and output the results in a spreadsheet from the main query. The problem I'm having is when I output the results, the start date and end date fields are blank. When I attempt to write the results to an Access Table, the table saves the 2 fields in "binary" format and the data in the fields is blank. Does anybody have any suggestions as to how to fix this?

    Thanks.

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    ...and you're sure the 2 fields where the data originates are Date type?
    What format are they stored in?
    Could you post your SQL?
    Inspiration Through Fermentation

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •