Search results

Thanks, couldn't see the forest for the trees. I obviously overcomplicated it and was looking for something far more complex. feeling a bit silly now, but thanks for setting me straight.

HI, I have a query [CustomerOrdersByDate] that requests user input for [CustomerID], a 'Start Date' and an 'End Date' for the [OrderDate] field. the Report works fine, however I'd like it to be able to take the Start & End dates the user has inputted when running the report, and make it appear...

I'm trying to use an append query to copy data to be further modified leaving the original tables in tact. The data is to come from two tables 'orders' & 'orders details' and append to two tables 'delivery' & 'delivery details'. Assume the following: ‘orders’ has ‘orderID-(AutoNumber)’...