By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,060 Members | 1,906 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,060 IT Pros & Developers. It's quick & easy.

DataGrid + Access-DB - display date-values grouped by date and time?

P: n/a
Hi folks,

I have a table in an Access-DB that has a date-field (date + time). I'd
like to use a DataSet + DataGrid to achieve a grouped/hierarchical display
where the user would work his/her way from years to months therein (rows
with items only) and finally the data-rows themselves.
My first idea is to setup a DataSet containing virtual tables, but I'm
wondering as to how I could split up the date from the database into date &
time (and whatever comes below that level) because VBA-functions such as
DatePart() and Format() won't be available, thus I'll only be able to query
the date-field as a whole. How would I get years and months separated and
into the DataSet?

Any hints on where to start?

TIA & cheers,
Olaf
Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Olaf,

What you ask is in my opinion certainly not the best part of Net, however
have a look at this. And link than deeper to datetime.

http://msdn.microsoft.com/library/de...ormattopic.asp

I hope this helps,

Cor
Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.