Hi all,
I have a dataabase that contains orders of products. I have a report that will show for any given month the number of order and deliveries for each day. To do this I have seperate queries that count the no of orders, deliveries and cancellations on each day. I then pull these queries into another query along with a table that contains all the dates for that month and link them on the date field.
The final query works fine in 2000 but when I convert the application to 97 this query stops working. Is it somthing to do with the date formats and reginal settings. In the 97 version the order/delivery/cancellations count queries work - it is just the final query when the dates table is introduced.
Thanks in anticipation. - MIKE
I have a dataabase that contains orders of products. I have a report that will show for any given month the number of order and deliveries for each day. To do this I have seperate queries that count the no of orders, deliveries and cancellations on each day. I then pull these queries into another query along with a table that contains all the dates for that month and link them on the date field.
The final query works fine in 2000 but when I convert the application to 97 this query stops working. Is it somthing to do with the date formats and reginal settings. In the 97 version the order/delivery/cancellations count queries work - it is just the final query when the dates table is introduced.
Thanks in anticipation. - MIKE
