Tomnehek

I'm using dreamweaver and attempting to connect to a Microsoft Access Database to create a dynamic page. No matter what I do I get this error when I try to connect to it and I can't find anything else online about how to fix it. Does anyone know what might be wrong?Thanks

I discovered that I can achieve what I'm trying to do by saving the table as a form and then using the form properties by placing the expressions I need in the control source. Thanks for all your help guys!

I know, which is why I find it strange that it doesn't recognize it as a field name because H and AB are most difinately fields. I don't know what it has to do with the validation expression, so I'm a bit confused.

When I tried to write [H]/[AB] into the default value, it says that it doesn't recognize the fields "H" and "AB" in a validation expression or in the table. What exactly does that mean?

I'll be honest, I'm quite new to SQL and all that good stuff so this may be sound like a dumb question. I'm in the process of creating a database of baseball statistics in microsoft access and I'd like to figure out a way to take data from multiple fields in the same table to be displayed in another field in, once again the same table. For example, I would like to have something like the Batting Average to be calculated by taking the data in the Hits column and dividing it by the data in the At Bats column automatically. This would make it much easier to update the database and it would eliminate a ridiculous amount of work. Does anyone know how I would go about doing this? Thanks a bunch!