Page 3 of 3 FirstFirst 123
Results 31 to 32 of 32
  1. 09-09-2016, 02:53 PM #31
    Grant Shea
    Grant Shea is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Feb 2015
    Posts
    30

    Data type mismatch in criteria expression
    Reply With Quote Reply With Quote
  2. 09-09-2016, 03:10 PM #32
    rpeare
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    ooops

    field name has a space in it (avoid spaces in field names)

    CurrentDb.Execute "UPDATE TempEasyCategories SET Subcategory = '" & [Combo2] & "' WHERE [Question Number] = 1;"
    Reply With Quote Reply With Quote
Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Select from query that excludes records based on a field criteria, but retains null..
    By Bdowns in forum Queries
    Replies: 1
    Last Post: 08-31-2012, 01:56 PM
  2. How to make report based on random selections from query
    By MLS31612 in forum Reports
    Replies: 8
    Last Post: 03-19-2012, 08:50 PM
  3. Delete Duplicate Records Based on Criteria
    By chadd in forum Queries
    Replies: 2
    Last Post: 02-07-2012, 04:24 PM
  4. Select Random Records Based on Conditions
    By access123 in forum Queries
    Replies: 1
    Last Post: 10-27-2010, 10:25 AM
  5. Counting records based on specified criteria
    By GrnISSO in forum Queries
    Replies: 2
    Last Post: 10-04-2007, 03:07 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums