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.
How can I save modified existing select query?