Search results

Hi Paul, with your hints I managed to be able to filter everything I needed. The idea was to have a table with: Users, System, Profile, Date Then filter and remove all users that I found in AD Get this results and filter against the systems I don't want in the results And get the results and...

Thanks pbaldy, it seems that is the issue. When I added the tables in the FROM clause, it worked, but just because they actually only have one record, as soon as I added a second record to one of the tables, it just ignored and all the records came on the SELECT result. I believe that its...

Hi, I´m an access Newbie, so sorry if I´m asking anything stupid :D I have this working query: INSERT INTO TB_SISTEMAS ( LOGIN, SISTEMA, PERFIL, DATA ) SELECT Left([dbo_BACKUP_ACESSOS.LOGIN],255) AS LOGIN, dbo_BACKUP_ACESSOS.SISTEMA, Left([dbo_BACKUP_ACESSOS.PERFIL],255) AS PERFIL...