Search results

I'm using Access 2016. When my query runs, it rounds the number up automatically. I have tried to use Formate, General Number, and setting the decimals out to 2 places, but that does not work. :banghead: The query pulls data from a linked table. Example: The data in the table is 0.6, and...

Is there an easy way, using the edit tools in Access 2016 (I'm not comfortable in visual basic) to close a secondary form when I close the primary form. Here is my design. I have a DB that combines information from read-only tables with tables I created for my faculty to track data. The...

I need to run a query where the user can enter multiple items separated by a comma. The code was working in my older versions, but I cannot get it to work in a new database. The query prompts the user for multiple class item numbers that will run class rosters for one or as many items as...

I need to pull data based on criteria from a read-only table into a table where data can be added. The read-only comes from our student management system. I built a query that pulls the data from the read table and then needs to update that data into another table that can be used to update...

My Access skills are really rusty and have to admit to being embarrassed I cannot figure this out. Here is what I need to do in a form. 1. instructor will run a popup from dependent on the item number and quarter which will bring up a class roster. 2. The input form is based on a table where...

Hello from the Sunny side of Washington State. I work in higher education, as the online systems admin and do some teaching on the side. I used Access a lot when I was in private industry, but my skills are rusty. Now I'm working on a project and a simple input form has me stumped. I sure am...