• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 502
  • Last Modified:

Move fields up or down

I have 4 textboxes which have a print name, address1, address2 and address3.  I have added another textbox making it 5 total fields.  I want to be able to move the fields down or up one depending on the address2 field is not filled initially. In the stored procedures I have coalesced the Address2 if there is no Address in the Address2 field I am inserting the City, State and Zip into that field. IF there is  an address in Address2 field then I move the cit, state and zip to Address3 field. How can I move the fields up one or down one?
0
pelon_80
Asked:
pelon_80
  • 3
  • 2
1 Solution
 
TempDBACommented:
you need to check the value in Address2 and based on the presence of data, you need to write two insert statments.
0
 
mlmccCommented:
Is this in the report or in the SQL?

mlmcc
0
 
pelon_80Author Commented:
it is a report
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
mlmccCommented:
If you put each field in its own section you can then suppress the blank sections and the fields will move up.

Right click the details section in the left margin
Click INSERT SECTION BELOW
Repeat 3 times

In DetailsA put the name
DetailsB - Address1
DetailsC - Address2
Details D - Address3
DetailsE - City, State, etc

mlmcc
0
 
pelon_80Author Commented:
It okay what I did is create two formulas and according to Address 3 I put Name, Address and City, State and zip in the 2 formula and if there is a second Address field I put the Name, Address 1, Address 2 and City, State and Zip in the other formula 1
0
 
pelon_80Author Commented:
It worked for me.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now