Limit Report Field Data 1

[mmck1964]

I want to do a report on a database that records company internet use. The URL field has the comlete link like..

http://www.msn.com/

http://www.msn.com/picture/tree.1278

http://www/yahoo/com/music/thirdday.1233

And so on.
I only want to display the web site in my report like..

http://www.msn.com/

http://www.msn.com/

http://www/yahoo/com/

Not the links after the com/
Is there a way to do this?
Thanks!

 

[glalsop]

Try this:

left([YourField],instr(8,[YourField],"/"))

-Gary

 

[mmck1964]

I get a #Error on the report for that field.

 

[glalsop]

Where did you place the expression? n an unbound text box, you only need:

=left([YourField],instr(8,[YourField],"/"))

-Gary

 

[mmck1964]

I put this in the contro source for the text box.
=left([Web Site],instr(8,[Web Site],"/"))
Web Site is the field name in the database.

 

[mmck1964]

Gary,
I got it now. I was using a bound test box, not unbound like you mentioned in rour response.
Thanks!!!!!