Search results
-
K
If BLANK (NULL) in a SELECT statement
Hi, I have the below code from the SQL view of access: SELECT tblDealsTeamreport.[CIBR Deal ID], tblSalesTeamreport.[Team Member Name], tblDealsTeamreport.[Associate Name], tblNamesCIBRtoSF.[SF Name] FROM (tblDealsTeamreport INNER JOIN tblSalesTeamreport ON tblDealsTeamreport.[CIBR Deal... -
K
Change of code between 2003 and 2007 to import xls files to Access
Hi, I found a great bit of code which imports xls files to Access but it only works in Access 2003. Apparently the Application.Filesearch is not present in 2007. Does anyone know how what code I would use to do the same function? I'd greatly appreciate any help. Function ImportXLSFiles()...- kknb4591
- Thread
- Replies: 4
- Forum: Modules & VBA
-
K
How do I write a query which checks if a value from 1 columns is in another column
Hi, I am trying to create a query where I check whether a value from one column is in another and if so bring back no result. E.g: ID Name1 Name2 1 Bob Bob 1 Bob Bill 1 Bob Dave 1 Bob Keith 2 Dave...