Search results

  1. A

    Export Access Query to an existing excel file specifying range

    Hi Guys! Here's what I'm trying to do. I'm trying to export one of my queries to an excel file. But the thing is, that excel file is preformatted already and I only want to transfer the result to a specified range which is the source data of one of the graphs in the excel file. I did this...
  2. A

    SQL Query to Create Summary

    Hi Guys! It's me again. From one of my tables, custinfo, i want to generate a summary of records. What I mean is I want to count the total number of records, count those who doesn't have address entries, count those who doesn't have credit records. So in presentation, I want to have this...
  3. A

    Select records from one table that does not exist in another table

    Hi Guys! Need help in putting up SQL string. I have two tables. The first one contains customer information. Primary key is custno. The second one contains customer logins, primary key is also custno. What I want to do is to view customer information that does not have customer logins. Is it...
Back
Top Bottom