Live information in access

[RGAnthony]

Hello,
Right guys, new to access but have experience with MySQL.
Basically, i have one table with a few fields, ID, Customername, Rating, Customer_email, Comments, Removalcompany.

I created a query to get all of the ratings from that table, and average them.
What i want to do now is put that average into a table and to have it only showing in one record. I have achieved this, but i would like to have it so that the number for the average rating is live.

This is to be used as a backend for a website.

Any suggestions?

 

[Ron_dK]

I created a query to get all of the ratings from that table, and average them.
What i want to do now is put that average into a table and to have it only showing in one record.

You should never put a calculated value in a table.
Just display the averaged field from the query and leave it like that.

 

[RGAnthony]

Hi thanks for the quick reply.
How do i show the value of the query in a web page coded in php?

 

[Ron_dK]

Sorry, I have no experience with webpages and such but found this :
http://www.databasejournal.com/features/msaccess/article.php/3613386

Hope that helps.

 

[RGAnthony]

thanks alot for your help.
I realised you can just call a query as if it was a table