Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2005
    Location
    Minnesota
    Posts
    42

    Unanswered: code in query change table field date/time from number

    I have a problem with the AB table that I converted the record date and accept date to date/time. Open form to see the parameter problems that show up. The previous programmer had the these dates in number format but I changed it to date.

    See attachment and form for the parameter expr problem that I am trying to fix.
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2003
    Location
    Romania
    Posts
    32
    Hello,

    Take care, your field has an extra space inside: "Accept_ Date".
    You should avoid spaces inside field names.
    The same for "Record_ Date".

    Florin Profeanu

Posting Permissions

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