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

Displayin FromDate Todate

P: 10
hi all of u.I create a report n in its querry i put z criteria From n To Date,so wen u run z report it ask 4 z date.but m question is how can i display the From and To date in my report.thnx in advance.
Feb 11 '08 #1
Share this Question
Share on Google+
6 Replies


ollyb303
P: 74
You need to add a text box on your report (probably in the report header) and enter the following:

Expand|Select|Wrap|Line Numbers
  1. ="From " & [FromDate] & "  to  " & [ToDate]
You will need to change [FromDate] and [ToDate] to reflect the format in which you have entered them.

HTH

Olly
Feb 11 '08 #2

P: 10
thnx a lot Olly,i've been fightin wid it 4 som time.thnx u very much.
Feb 12 '08 #3

missinglinq
Expert 2.5K+
P: 3,532
When posting on this site please write in complete sentences, use appropriate capitalization and refrain from using texting abbreviations.

Welcome toTheScripts!

Linq ;0)>

Moderator
Feb 12 '08 #4

ollyb303
P: 74
No Problem! Glad to be of assistance rather than requiring it for a change!
Feb 12 '08 #5

P: 10
hi 2 all of u.i have a form which dispaly parameter for a report.i want zat on lost focus of z form,it close itself.hw cn i do it.thnx in advance if u cn help
Feb 14 '08 #6

missinglinq
Expert 2.5K+
P: 3,532
Spiderz78, which part of "please write in complete sentences, use appropriate capitalization and refrain from using texting abbreviations" do you not understand?

If you do this again you will be temporarily banned from posting here! If you continue to persist in this behavior after that you will be permanently banned.

Linq

Moderator
Feb 14 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.