Search results

Hi, This is probably a simple question, but I'm very new to Access. Let's say I have some subject names and scores for each going horizontally as follows: Subject Test1 Test2 Avg English 10 8 9 Physics 9 7 8 Now, under those, in the footer, I'd like to...

There's no problem putting in the word "Null" instead of "" in the calculated numerical column back in Excel (if I've understood you correctly), but when I tried to import into Access, I got two tables of import errors. Is there something I'm doing wrong? In case I was unclear earlier, the...

I agree with you wholeheartedly but the problem is that my data is being imported from an excel calculated spreadsheet. It doesn't seem possible to create a null value entry in Excel because all the data is calculated. At most a zero value "" can be produced in a cell, but then Access will not...

I have the following situation: 1. A Homeroom table which includes student id, academic year, and homeroom. 2. A Student Grades table which includes student id (linked to Homeroom table), term, academic year, progress grade (15 pts), and progress grade (A-F). The contents of these tables are...