Search results

I have the following code which for some reason ended up dropping the source table, any ideas why that happened? Sub ImportBookingsTable() Dim db As DAO.Database Dim sourceDB As String Dim sourceTable As String Dim destinationTable As String ' Set the source database and...

I have what should be a simple query: SELECT qry_receipt_bay_progress_2.[Cases Expected], qry_receipt_bay_progress_2.[Cases Receipted], qry_receipt_bay_progress_2.[Packs Expected], IIf( [VP] = 0, 0, -Int(-([Cases Receipted] / ([VP] * [SP]))) ) AS...

I have 2 queries `qry_tbl_crt_bookings_by_container` which prompts the user for a container number and a second query which I want to count some values from the first query: SELECT qry_tbl_crt_bookings_by_container.Container, (SELECT Count(*) FROM (SELECT DISTINCT PO FROM...

I have no idea why this is failing, I simply want to make the background red if the Date is before Today. The results I am getting are all over the place.

I'm trying something quite basic I assume but it's not working. I want to append the contents of an access table to an excel file or create the excel file if it does not exist. So far I either get errors or the excel file is overwritten instead of the data being appended. This is my full code...