Search results

I inserted the code in the criteria field and I got the following error when i tried to preview the report: "Can't have aggregate function in WHERE clause <clause>. (Error 3096)" Do you know what's causing it?

I see. But this means that whenever i try to open the report by itself to view all records, I will have to fill in the dates. I would want a scenario where I will be able to view the report on its own without any conditions set. Could i possibly set the date range in vb code? In this way, it...

I have a combo box that has two choices, OutletA and OutletB. When the user chooses one of the outlets, i want a textfield to be filled automatically. For example, if the user chooses OutletA, I want the textfield to display A1; whereas if the user chooses OutletB, the textfield will display B1...

Thanks a lot. Worked perfect.

How do I let my switchboard be the first thing to show when A97 is opened?

I currently have a field in my table that stores date in the format dd/mm/yy. I wish to filter reports between the date range that the users have typed. You can refer to the attachment for the sample database. Note: FilterForm1 is the form that I am referring to. Thanks, Swee