Recent content by Jacqueline

Well now I feel stupid, I just checked the table, and the data in the table is one credit. So the query is pulling what it found from the table. I know better than to not check out my user's information before running around with my hair on fire! Thanks for making me look at the table data...

dbo_Class.Credits is the field I am pulling from the college's read-only scheduling tables. The data in the tables is 0.6, and my query rounds it up to 1. Please see my edits in the original post; I did not see the post reply button until I had copied the SQL into the first post. Thanks...

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 will take a look at this. I'm not sure it will work becaue I am working with read only tables from the student management system. Thanks, Jacqueline

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 tried relating the query both ways, and neither worked. The data would look something like this: yrq item SID B564 4110 999476666 B564 4110 999476667 B564 4110 999476668 B564 4110 999476669 B564 4110 999476670 This would come from the student roster table on the SMS read-only table. The...

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...