Thanks for your response. I have Access 2007, and SQL Express 2005. I started this project many months ago, then got engaged & then Married..... so I dropped...

Actually we do need it in Minutes and seconds format as this is ported to a form which list the actual times for each function, and then their scheduled time,...

Aaya is giveng us the time in Seconds, we then us 86400 to get Minutes and seconds. So I suppose I could divide the second by Avaya by 60...

Correct it is Minutes, 30 Minutes and 03 seconds.

Pete

Thanks for that Info, however I am using Access 2007 and Stored Procedures. It has a Button to create Stored Procedures. We're also on the hated Microsoft Vista OS...

I appreciate your information, however I don't understand any of it. What is CTE? That is why I came in under Novice as I have never used SQL...

Creating Columns in a Stored Procedure using Access Query Designer. Using what I know.

Pete

Sorry, nine year of Access, 3 mos. of SQL.

Here's my most recent attempt to create a computer column from several computed columns.

EMonth = DATEPART(m,dbo.employee.LGD)

EDay=DATEPART(d,dbo.employee.LGD)

These work fine,...

Sorry, In Access 2007 I am creating my Stored procedure for our SQL 2005 Database. The Da Vinci layout gives me the Tables, and from which I select the Columns...

Thank You , that worked fine. Now How do I refer to that Alias (and others) in other columns I create? Stored Procedures doesn't like to refer...

Thank You.... What would the provider be, or where could I find that information. Thanks.

Okay, here is where I demonstrate my stupidity with SQL- where do you enter the function in the Table definition? I need to collect the User Names using SUSER_NAME()....

Thanks for the information, Appreciate.

Pete

Thank You, Matt. The Leave Query (the query which is not updatable) uses one table and one query. The Table is the leave table which has a Request...

Thanks, it does. I'm a novice and need a crash course to get our Database up and running right.

By the way, how do I set a field...