Lab Sql

I've been using MS Access 2010 for a while now and I have big problem. I'll attach a dummy … Read more Query Creates Redundant Entries

This must be a very simple mistake. I just can't see it. My Where String: strWhere = 'tbl_f… Read more Access Openreport Not Working With Where Condtion

This is wrecking my brains for 4 hours now, I have a Table named BreakSked, and I this button to up… Read more Update Sql Ms Access 2010

I have been struggling with SQL statement when converted to VBA. Basically, I wish to add something… Read more Select Query Does Not Work When Converted To Vba - Invalid Sql Statement

I am importing an excel file into Access 2010 and the date field(CALLDATE) comes in as text(YYYYMM… Read more How To Convert A Text Field To A Date/time Field In Access 2010?

I have this query in Access: SELECT TOP 10 title, ConcatRelated('DOCTEXT','DocumFrag&… Read more How To Improve Efficiency Of This Query & Vba?

I'm trying to make an SQL query with an OleDbCommand into an Access database (.accdb). While… Read more Two Inner Joins In Oledb Sql Query

I'm creating a table B from an exisitng table A. In the table A I have a column ValDate which i… Read more Date Conversion Issue Ms Access To Sql Server