Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 19th, 2005, 11:48 AM
Registered User
 
Join Date: Dec 2005
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default 1. Subform = String, Chronological Date order



Hello,

Can an expert please help with 2 issues I have:

1. I have a subform that is displayed in datasheet view.
Example:
Dog
Cat
Bird

Is it possible to display this as a string? Example: Dog, Cat, Bird?

2. I have a report with months displayed as Jan 05, Feb 05, etc., is it possible to put these in chronological order?

Kindest Regards,
Nancy

 
Old December 20th, 2005, 08:33 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

You could display this as a string, but you would be better off using a text box instead of a subform. The recordsource for the text box would have to be a query that you set up that looks for the parent form PK in the query criteria like "[Forms]![YourFormName].[PKFieldName]"

For the report, right click on the report and select Sorting and Grouping. Find the date field, or add it, and then select ascending.

HTH

mmcdonal
 
Old December 21st, 2005, 06:50 PM
Registered User
 
Join Date: Dec 2005
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

Thanks for responding. I'm relatively new to Access so could I get a little more detail please.

The current subform's recordsource is a SQL that runs a comparison of job competencies that relate to a specific job selected from a combo box on the same form. Will any of these processes change if I change the subform to a text box?

You mentioned I could convert the current subform to a string but a text box was better, what is the downfall to converting the subform to a string instead of the text box?

Regards
Nancy






Similar Threads
Thread Thread Starter Forum Replies Last Post
ORDER BY Date Columns.... seananderson Access 8 March 16th, 2007 05:35 AM
problem displaying records in order of time ,date method PHP Databases 3 July 25th, 2006 08:16 PM
* where date >= '"& dateVar &"' order by date wrofox Classic ASP Databases 5 February 24th, 2005 10:11 AM
Displaying time in chronological order mg1966 Classic ASP Databases 3 January 24th, 2005 02:11 PM
Order by on a subform bjackman Access 1 January 16th, 2004 01:22 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.