Results 1 to 7 of 7
  1. #1
    Rxp is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    15

    Access To SQL Server Migration

    After migrating from access back end to sql server,one of my report is not working in access front end...
    Error: Datatype mismatch in criteria expression
    I have only one expression in this report i.e =Format$([DtTraige],"Long Date',0,0) and I have no idea about this...please Help!!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,862
    Try using the Format property of the control instead Format function in expression.

    A side note, should that spelling be DtTriage?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Rxp is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2012
    Posts
    15
    Thanks for your reply June7. I am new to this so I have no idea about it. 'DtTraige' is actually a column name in access table where date is stored at the back end.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,862
    Triage is a real word so I thought the field name was indicative of 'date of triage'.

    Did you try the Format property?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Rxp is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2012
    Posts
    15
    So, just replace format with format property? This is my job at work and I am very new to access.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,862
    Format property is a setting you will find on the Format tab of the Property Sheet dialog when you have a data entry control selected in design view.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    Rxp is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2012
    Posts
    15
    Thanks June7, I used a format property and it works now.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access 2010 to SQL Azure migration
    By Aurelius7 in forum SQL Server
    Replies: 6
    Last Post: 06-18-2012, 10:15 AM
  2. Replies: 3
    Last Post: 05-07-2012, 07:57 PM
  3. Migration to web
    By thbaig1 in forum Access
    Replies: 1
    Last Post: 11-22-2010, 10:04 AM
  4. Migration from Access 2003 database to Access 2007 database.
    By cyclus2 in forum Import/Export Data
    Replies: 1
    Last Post: 09-10-2010, 11:43 AM
  5. Replies: 0
    Last Post: 04-16-2009, 01:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums