Windows 10 
Access 2016
Hello!
First and foremost, I'm extremely new to MS Access, and sort of new to coding in general; I do have experience with Matlab, C, and some Excel. I'm currently attempting to build a database for a summer job, and am now getting into the stuff that requires a little more than YouTube tutorials and a vague idea of coding syntax. I've got a whole bunch of questions, not all of which I can clearly articulate, but ANY help with ANY of them would be absolutely awesome (including links to places where I can do some research; anything at all). Thank you in advance!
1. I have a calculated standard deviation field, and I'd like to make it give some kind of error message if it's higher than the spec limit. I've found the data validation buttons, both the rule and the text that'll pop up, but having tried it, I'm missing something, or not doing it right. In excel, I'd just make the cell turn red if the SD is higher than value X, but I'm a little stuck with Access. I want the rule to be that if the SD is greater than 3, SOMETHING happens.
2. I want to make a line graph on a couple of fields I'll call 'average' and 'lot #'. X axis is the Lot #, and y axis is Average. I found the wizard for it, and I can sort of look through the property window and make sense of it, but no data shows up when I switch to print preview of the report, nor when I try to mess with the row source. Somehow a query builder popped up, and I added the two fields I need, but when I switched to the datasheet view, it was completely blank.
3. where can I find references for SQL syntax? I have a feeling it's more common to build up these things with code rather than the layout views, but that would require even more research than the rest of this stuff.
Reply With Quote
