1. Home
  2. Database Software
  3. Simple Question About Programming?

Discuss in my Forum

Simple Question About Programming?

By admin Posted in: Database Software

I run a report in my access database and it asks for StartDate, EndDate and InjuredPerson. How do I get it so that this info is displayed in a label at the top of the report? so for example, if i enter startdate as 01/01/2010, end date as 31/12/2010 and InjuredPerson as Staff, what do i do for the label to display a message like “Staff accidents between 01/01/2010 and 31/12/2010″
thanks for help

«
»
  1. Tdz Says

    You need to concatenate the string with the variables:
    PHP:
    $msg = “Staff accidents between” . $StartDate . “and” . $EndDate;
    echo $msg;
    JAVASCRIPT:
    msg = “Staff accidents between” + StartDate + “and” + EndDate;
    document.write(msg);
    As simple as that!

  2. AnalProg Says

    Look at the details of your report and you will find that the fields are used to access the Access database. Look at the way they are used.
    Now go to the report and add a text label. Make the content of that label a concatenation of the three fields plus any text that you might want to access.
    If you don’t want the hassle of concatinating the information then just add multiple labels.
    Have fun.

Leave a Reply

You must be logged in to post a comment.

More Interesting Things

Database Software

©2011 Softwares Reviews, All rights reserved.