Easy problem...help anyone?

Question

Help from anyone appreciated... I create a new Access DB using ADOX.CatalogClass, and then add tables to that DB via a Command object and "CREATE TABLE"... After creating several different tables, I want to define the relatsionships between the tables. What is the best way to do this and how? How do you load an entire DB of empty tables into a DataSet object? I thought the best way would be to bring the newly created empty DB into the application locally via a DataSet, then monkey around with the DataSet relatsions and then update the DB I am clueless at this point Scott

Answer 1

Dear try this


Select UserCode,
Cast((DateDiff(mi,Starttime,EndTime) / 60) As Varchar(8)) + ':' +
Cast((DateDiff(mi,Starttime,EndTime) % 60) As Varchar(2)),Starttime As [In Time],EndTime  As [Out Time ]From tblLogIn

Answer 2

Hi,

Note that when you use the HH will give the date difference in hours. But it needs something like entire different between two dates.

I think get the seconds or minutes and find the differences, so you can calculate the actual time different by diving the minutes.

Answer 3

Hi
use datediff like

select

sum(Datediff(hour,StartingDate,EndingDate)) from ItemDiscount