MS Access

php: MSAccess copy contents into another table

May 30, 2012
By

// erase table $drop_sql = “DROP TABLE tBSI_counter”; $pt_result = odbc_exec($conn, $drop_sql); // copy table into another $esrd_sql = “select * into tBSI_count from qBSI “;

Read more »

MS Access: Query – get part of the date only

March 23, 2012
By

I was looking for this all over. To get only the month or the year of the date in MS Access query: CDate(DatePart(“m”,) & “/15/” & DatePart(“yyyy”,)) and to find the Age of a person based on dates: DatePart(“yyyy”,)-DatePart(“yyyy”,)

Read more »