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?