Results 1 to 3 of 3

Thread: Combining Data

  1. #1
    Join Date
    Oct 2004
    Posts
    2

    Question Unanswered: Combining Data

    I am using the following to combine data and show in a text box.

    =[Form]![Width] & " " & [WNumerator] & "/" & [WDenominator] & " " & "X" & " " & [Length] & " " & [LNumerator] & "/" & [LDemonimator]

    And the data shows like this: 28 1/4 X 32 3/4

    What I don't want is this 28 0/0 X 32 0/0 or 28 0/0 X 0 0/0. When the fields have 0's in them.

    Should be 28 X 32 or 28

    Is this possible? Any help is greatly Appreciated.

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    You could try replacing [wnumerator] with
    IIf([wnumerator] = 0,"",[wnumerator)

    I would put together a function to build and return a string,
    and use that function as the control source for the text box.
    Inspiration Through Fermentation

  3. #3
    Join Date
    Oct 2004
    Posts
    2
    Thank you RedNeckGeek that worked very nicely.

    I would try and write a function but not too good at code and I'm in rush to get this done.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •