Recent content by dmschenk

I'm not sure what I'm doing wrong here but the numbers don't average out correctly all the time. There are basically two "sets" of values. When I add numbers to the "first" set of values the average is correct. When I add numbers to the "first and second" set of values the average works...

It looks like I was mistaken... if either the first or second "Val" is empty then the calculation fails. There is a good chance that this combination can happen.

Wow that was simple!! Thanks so much for your quick response!!!

I am a bit of Access newbie and am taking over a report card system for a church school. I am having an issue with the pre-existing database for creating report cards. I am trying to add a GPA calculation however I am running into length of calculation issues. There are 48 classes in a course...

How can I make Print Preview the default view for a report straight out of the switchboard? Currently when you click to open a report it opens in report view and you have to right click to select Print view. In design view my report says the default view is Print Preview but that is only for...

Awesome!!!!! That did it! Thanks

I'm trying to create a report that populates some of the text fields from specfic cells from a table but can't seem to figure out just how to do it. If this were PHP I would have something like: (SELECT myTitle FROM myTable WHERE id="12") But I am not seeing this in Access for a text field...