Search results

Trying to make this code work, don't know how to filter as it prints identical all reports. Private Sub cmdExportPDF_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim MyPath As String MyPath = "C:\Reports" If Len(Dir(MyPath, vbDirectory)) < 1 Then MkDir (MyPath) End If Dim...

Trying to Compare 2 fields Status with answers Yes or No, from 2 Tables PipeLine and Pipe, and get the fields that don't match, what am i doing wrong? SELECT PipeLine.[Project Name], PipeLine.[Capacity DC], PipeLine.[Project Num], PipeLine.[Status] FROM PipeLine LEFT JOIN Pipe ON...