Need assistance with modifying SQL statement (in form)
I need some assistance with tweaking a query (generated which is generated via a form).
Please see attached database (zipped). In contains the following objects:
Process upon opening:
1. Open form "frmLogin"
2. Select any of the three values from the listbox
3. This will open Query1 and display the associated responses.
Here's what I need some help with:
- Tweak the SQL (in frmLogin) so that the selected value from the listbox (e.g., "Display 2-digit numbers)
is added as records (in new column [Selection]).
- Attached JPG "Query -- Current and New" illustrates the current and new query views.
Any idea as to how the SQL can be modified to achieve the new query display?