Search results

I have used a sample database from the net and modified to my requirements to make a search form to search my database(enquirydb_pmcpn.mdb) for any enquiries that have been entered. I've got it working fine but I now want to extend it to search another database(enquirydb_pnashl.mdb) too. I have...

Thanks everyone for their help so far! I have a combo box on my form to select the employee's name and then i have multiple text boxes on the form that i want to automatically fill with the selected employees details (i.e phone number, fax, etc) which are located in another table called...

I have 2 tables, [Prod Code data table] & [comment table]. I want to delete all records in the comment table where the prod code does not appear in the prod code data table. Is this possible?

:mad:I have 3 tables, Table A, Table B & Table C. I need to count how many records exist in each table and append those 3 counts into 1 table in 3 different fields with the date. Column1 = Today's Date, Column 2 = Table A, Column 3 = Table B, Column 4 = Table C. Any help?

I have table 1 that has 13100 records and table 2 that has 13000 records. Both these table contain the same information except table 2 has 100 more records. I would like to append the 100 records only that do not exist in table 2 from table 1. Is this possible?

The only problem I have with that is each day I import the product table from an external spreadsheet so it deletes anything from the previous day in that table. I was going to import my spreadsheet into the product table and than update it into second table and run the comment update query off...

I am having trouble making a delete query for a table of mine. In my table i have products, Qty on hand, qty on order, reorder points. I want to add in a comment field so that i can make comments about the products that are low on stock. I than want to be able to than run a delete query that...

Thanks Thanks... Worked perfectly!!!

In my table i have a column called "del date". I want to run a Query to return only the records that have a delivery date of today and tomorrow(next weekday).