Recent content by Beblessed

my teacher asked me to do Access homework to change data type from Text to Boolean. Data in "Owned car" field show as Y or N so I click on Design View and change datatype of this field from "Text" to "Yes/No" , than when I saved it show a message When I back to Datasheet view, all data in...

Thank you :) Thank you so much databasedonr for your help.

After I made a report, I also wanted to show the average value calculated at the bottom of specific column. So in Design View,I added a text box on Detail section and typed Control source as =Avg([value column's name]), then it showed the average value of that column correctly, but it show...