Search results

  1. K

    If BLANK (NULL) in a SELECT statement

    Thanks all I ended up using: SELECT tblDealsTeamreport.[CIBR Deal ID], tblSalesTeamreport.[Team Member Name], tblDealsTeamreport.[Associate Name], IIf(IsNull(tblNamesCIBRtoSF.[SF Name]),tblDealsTeamreport.[Associate Name],tblNamesCIBRtoSF.[SF Name]) AS [New Associate Name]...
  2. 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...
  3. K

    Change of code between 2003 and 2007 to import xls files to Access

    Thanks will give it a try
  4. K

    Change of code between 2003 and 2007 to import xls files to Access

    Thanks I tried a few of those solutions and none would work when executed. I'm very new to Access Macros and probably messed up the code. Any further help would be greatly appreciated.
  5. 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()...
  6. 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...
Back
Top Bottom