Results 1 to 2 of 2
  1. #1
    satendrand is offline Novice
    Windows 10 Access 2007
    Join Date
    Feb 2023
    Posts
    1

    Query not saving after adding new columns in select statement

    I'm new to Access Database. We are using forms, macro's, queries in access database for generating invoices. Recently we added new column(data type: number-double) for one of table. So we added that new column in respective existing select queries. When we submitting form, screen prompting modal window to enter new column value.



    After that when I reopen the select query, newly added column is missing in select statement.
    Modified the query using query design and SQL view, both are not working.Click image for larger version. 

Name:	AddedNewColumnInSelectQuery.PNG 
Views:	11 
Size:	12.3 KB 
ID:	49718Click image for larger version. 

Name:	ModalValueIssue.PNG 
Views:	11 
Size:	11.5 KB 
ID:	49719Click image for larger version. 

Name:	NewColumnMissing-3.PNG 
Views:	11 
Size:	14.8 KB 
ID:	49720

    How can I save modified existing select query?

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,906
    Not grasping, Sorry.
    Please post code as code, not pictures
    Show names for each piece of code.

    Have you just tried dragging the field to the query columns in design view?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Adding an IF Statement to a Select ?
    By d9pierce1 in forum Programming
    Replies: 4
    Last Post: 07-31-2019, 05:50 AM
  2. Replies: 1
    Last Post: 11-25-2016, 11:57 PM
  3. Adding a Count function to current select statement
    By johnson8809 in forum Queries
    Replies: 2
    Last Post: 02-21-2015, 07:32 PM
  4. Adding/Removing and Saving an existing query
    By MondayLon676767 in forum Access
    Replies: 42
    Last Post: 01-31-2013, 04:36 PM
  5. Replies: 9
    Last Post: 01-03-2012, 11:35 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
  •  
Other Forums: Microsoft Office Forums