I have a table which contain names and dates identifying events, plus, a tickbox which identifies if the event is valid or not:
| name_one | date_one | invalid_one | ... ...
I use reports for a long time now, and it's printing out great.
Now, here is what I want to do-
I display all dates, whether they are valid or not. I would like to add, in the end footer of the report, a count which will write how many VALID dates I have. So if we have 5 rows, and two are checked under invalid, I would like it to display: "Valid Dates: 3".
I have no idea of how I can run a query, and display it's result. knowing that, will solve this issue for me, as I know how to write this query.
The thing is, I don't know how to run a query, and then write the results on the report, how do I call query outputs from a report?
Thank you all in adavnce, it's very important and urgent for me, can't thank you enough!
I can't thank you enough guys. I got everything working now and i'm super happy, thank you !!
I have another slight issue, I hope i'm not getting on your nerves here
I'm using a simple query to get rows between two dates, the dates in my database are formatted as : dd/mm/yyyy.
The query goes, theoretically: select all, from table, where bla bla bla, BETWEEN #01/11/2004# and #30/11/2004#.
The problem is, I got both dates setup just fine, but when the query is created, the first date is getting swapped, instead of 01/11, I get 11/01.. it's like it's confusing between the dd and mm. I format the dates, I msgbox the variables and I get the correct dates, I tried and did everything, but when the query is created, it's always the wrong date format.
Do I have to convert all my dates into mm/dd/yyyy, or there is a simple solution for this somewhere?
I tried your idea of removing the #'s, and it did seem to work, although now it displays 1/11/2004, and not 01/11/2004, and the format is dd/mm/yyyy, so that little zero in the front is my problem right now