Results 1 to 2 of 2
  1. #1
    Dano60 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2015
    Posts
    32

    Changing result of a value in a query result

    Hi guy's,

    This might be easy for you to explain!!

    I have the result from a query that return a value for the length of pencils that I sell, let's say value 6. Now I do not carry that size no more, I would like to create from that query a table that I would give in default value the available size and that 6 value would change to the next available higher size.

    Can I do that from a macro and how would I do that?



    Thanks!!!!

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You should be able to use an Append Query (or Make Table Query) to create new records from one Table and add them to an existing Table (or create a new Table).
    But we would really need more details to help you with the specifics of how to do that in your scenario.
    If you could provide actual samples of what your data looks like, and what your want the new records to look like, that would go a long way towards that.

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

Similar Threads

  1. Query Result Help
    By chaddresnick in forum Access
    Replies: 1
    Last Post: 06-30-2015, 02:34 PM
  2. Could not see a query result
    By alobi in forum Access
    Replies: 2
    Last Post: 02-04-2013, 02:42 AM
  3. VB ADO Query Result Set
    By Bedsingar in forum Access
    Replies: 5
    Last Post: 09-05-2011, 10:45 AM
  4. combine query result
    By Fenvy in forum Queries
    Replies: 1
    Last Post: 06-22-2011, 05:02 PM
  5. Evaluate result of sql query
    By Tyork in forum Programming
    Replies: 2
    Last Post: 11-09-2010, 05:41 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
  •  
Other Forums: Microsoft Office Forums