VB6 - Excell & Access

11-29-2003, 11:24 AM
Hi, Firstly Many Thanks in advance for any help/comments.

I have a VB6 application that basically adds data to a database (access). Part of this information is a date in numerical form Ie DD/MM/YYYY. What i would like to do is take this date from the VB6 app and add it to a Excell sheet. So the sheet would have a monthly view of days acros the top say 1,2,3,4 and so on. What i would like is to take the date on my app say the 1/mm/yyy and put a 1 underneath the 1 on the excell sheet. Basically i want a excell sheet listing orders on specific days and i want to add the order date using the application.

I used to run a query to see how many orders within two dates, which worked fine, but now i would like to look at a sheet of 1 month and visually see when the orders were placed ( if this helps explain)

Thanks for any help/input


11-29-2003, 07:26 PM
To be honest I'm not really sure what you're after here....

11-29-2003, 09:54 PM
I think you need a crosstab query in Access which will return a matrix of day columns, with related orders in the rows beneath. You can then return a recordset from that query using VB, and copy the results into the Excel sheet...

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum