Search results

Hi TheDBGuy INSERT INTO TblCompletedJobsAddressed (JobNo, Address, Date) SELECT JobNo, Address, Date FROM QryCompletedJobs WHERE JobNo = NotNull Dave

Hi All I am trying to append the results of a Select Query, I have read about and tried many variations, but can not get it do want I want I have a Query that is based on 2 Tables "TblCustomers" and " TblCustomersData" both Tables have identical Fields When I run the Query I would like to...

Hi theDBguy Thanks for your reply The tables are obtained from different sources "TblCompletedJobsAddressed" contains data of previous service calls to a premises that has been attended to in the past "TblCustomersNoDuplicates" contains a request to attend a premises 1. This may be the...

Hi All I am using a query to compare the "Address" field in 2 tables "TblCustomersNoDuplicates" and "TblCompletedJobsAddressed" The query below works fine but I would like to have all duplicated addresses displayed I attend households and businesses to complete service work, therefore, there...

Re: Turn off "Microsoft Access can't append all the records in the append query" Thanks The_Doc_Man your code was the answer. Thanks Isladogs for your reply

Turn off "Microsoft Access can't append all the records in the append query" Hi All I have an Append Query to add records from "TblCustomerImport" to "TblCustomers" the problem that I have is duplication of the existing records in"TblCustomers" I have tried the SQL below: INSERT INTO...

Hi All Previewed many posts over the years, finally took the plunge and joined. I have been using Access for a few years, I have learnt a lot by searching through posts, reading, videos etc, managed to work through most problems. DavRob