Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 displaying user entered data

Author  Topic 

msugradus
Starting Member

40 Posts

Posted - 2007-06-25 : 09:52:26
I have a procedure that allows a user to enter two dates to run a query. I would like to display those dates on the generated report underneath the title. "5-01-07 to 5-31-07" How would I do this?

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-25 : 10:03:08
Are you using Access?
Try format function there

Format(date1,"dd-mm-yy")+" to "+Format(date2,"dd-mm-yy")

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

msugradus
Starting Member

40 Posts

Posted - 2007-06-25 : 10:58:15
Yes, I am using Access. I need to know how to get the date to display on the generated report. I would like it underneath the title and above the column headings. Is this possible?
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-26 : 01:18:53
I think it is better you post this in ACCESS forum

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -