Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Format for Invoice
Ok what you need to do is check to see if the strings are empty and if they are do not display the comma or antyhing else. If they aren't show what you need to show. IF TRIM(address1)+ TRIM(field2) + ...etc = '' THEN stringvar := '' ELSE Show full address string Does this make sense...You...- jrp7442
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Format for Invoice
What you could do is just create another if statement. IF TRIM(TRIM(Add1) + TRIM(Add2) + TRIM(Add3)) + TRIM(City) + TRIM(State))<> '' THEN (use the last line you have already) ELSE '' If this doesn't help let me know and I can look at it again. But given your description, I believe this...- jrp7442
- Post #2
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Creating a AutoInteger in a make-table query
Hey guys....Help Needed I am trying to create a table using a make-table query. This table will sent to a text file. Howeer, I need a sequential in-file number that will keep track of the record number it is on. Does anyone have any ideas how I can tell a query to create a Counter inside...- jrp7442
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Access Designer
When you go to select the application you want to run in Access. Hold down the shift key as you double click on the file or shortcut icon until the database is loaded completely. You will know when it is finished, because Access will be open is your system tray.- jrp7442
- Post #3
- Forum: Microsoft: Access Other topics
