I need some help on queries. I need to create a calculated field in query form to add to my below create table statements. I would like to calcualte “days on current level” column from “date of current level” to today's date. Also I need some sort of trigger, or stored procedure to add, i'm blank on that one. If my existing statements are garbage, let me know as I'm always willing to learn better.
CREATE TABLE Customer (
PersonID int PRIMARY KEY,
CREATE TABLE Subscription Status (
FreeorPaid varchar(255) PRIMARY KEY,
CREATE TABLE Progress On Levels (
CurrentLevel int PRIMARY KEY,