Recent content by kikeman

Hi, I have a table called "Orders", that has a column called "OrderNum" OrderNum TimeHrs Date 1234 5 1/3/2010 5678 7 1/10/2010 1423 8 1/12/2010 5867 2 1/11/2010 4425 8 1/12/2010 5567 2 1/11/2010 ...

OleDbCommand SQLCommand3 = new OleDbCommand(); SQLCommand3.CommandText = "SELECT SUM(Tiempo_Empleado) FROM reporte_tiempo WHERE Depto = '" + AUser.Depto + "' AND ODT = '" + RepEach.ODT_Num + "'"; SQLCommand3.Connection = con...

Thanks my friend, I really need the SQL command because I am using OleDb from C# :)

Hi, Is it possible to request for a total sum of a column (number type of course). For example: I have a table A with a column "Hrs" and a column "Date" so that, I would like to SELECT the sum of all hours before certain date "myDate". TableA Hrs Date 4 11/2/2009 7...

Would that Query work if the Tables are not linked with a relationship? Thanks,

Would this work from C#? I am ussing OleDB. Thanks, Enrique.

Hi, I have two tables that are liked with a relationship: "Orders" and "Reports" with the OrderNumber column. Orders Table (PK -> OrderNumber): OrderNumber HoursForOrder 123456 47 876433 63 Reports Table (PK -> ID): ID OrderNumber HoursWorked 4 123456 5 5...

What should I put in "Validation rule"?

Hi, I have a table with a column with a float value. Is it possible to restrict from the table design that this value must not be bigger than 23.5 and in the case that someone try to enter something bigger than 23.5 it would automatically assign 23.5? Thanks, kikeman

Hi, I have a table with a column "Hrs" that is a double type. I would like to add or substract hours to the current value with a single UPDATE command. i.e: Orders Hrs Q6E4D3 2.5 I would need to add 3.5 hrs: Orders Hrs Q6E4D3 6.0 What would be the SQL UPDATE command to do...

Hi, I have a table with "Orders", these orders were inserted with certain Date/Time column called "InstTime" (I really need to store also the time): "Orders" "InstTime" 123678 12/1/2009 4:10:09 PM I would like to select the Orders according to certain Date (12/1/2009), but ignoring the...

If I want to view this info from Access2003 what should I need to do? (Entries that are in TableB but not in TableA according to the "OrderNo")

Hi, I have two tables: TableA and TableB they both have a column called "OrderNo" (same type and info, of course), I would like to delete those entries in TableB that ARE NOT in TableA according to the "OrderNo". "OrderNo" is the Primary Key in TableA, but it is allow to have duplicates in...