Search results

This makes sense, but the data will not be kosher this way. If for example amount is a required field then you're forced to create 2 extra transactions with amount that's <> 0. I know, you can put $0.01 in the amount field for both of them and it won't cause any trouble but ... not kosher...

Damn, I thought this was what I did, but I wiped it out and did it again and it worked this time :) Thanks a bunch!!! :D

I know how to code, just not in SQL. ;) I did try this before but what ends up happening is Access creates another column in the query and even if I do enter customer_id, it returns all of the records withing the date range I entered. :(

That's awesome. :D Now, I'll throw a wrench into this. What if I had another field (say customer_id) and I need to have a parameter on this field in the same query and this should also be optional? Say if customer_id and start_date are entered I want the result set to have all records with this...

Hi, I have a table with a date field (suppose invoice_date). I want to see all invoices in a given date range. Good so far, I can use BETWEEN. What if I want to let users to be able to skip entering Start Date or End Date or even both? If Start Date isn't entered as a parameter and End Date...