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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by lindasoph

  1. lindasoph

    Excel - Compare 2 Tables

    Two excel spreadsheets: tbl1 tbl2 SSN NAME AMT SSN NAME AMT 123-45-6789 JOE 25.00 123-45-6789 JOE 25.00 123-45-6790 SUE 50.00 123-45-6700 JASON 80.00 333-45-6700 CHRIS 10.00...
  2. lindasoph

    Incorrect syntax near

    I do not understand why IF cl.SomeField = cm.SomeField is not valid. Can you please explain a little more?
  3. lindasoph

    Incorrect syntax near

    Thank-you, I placed SET as suggested: SET @hld_tracknum = ci.TRACKNUM SET @hld_gdat = ci.GDAT SET @hld_id = ci.ID etc........ NOW I have received the following error: Msg 4104, Level 16, State 1, Line 79 The...
  4. lindasoph

    Incorrect syntax near

    Can you still help with my error????? With all the suggestion I have ended up with the following code and still have the errors: Msg 102, Level 15, State 1, Line 96 Incorrect syntax near '@hld_suta'. Msg 102, Level 15, State 1, Line 130 Incorrect syntax near 'END'. <<--LAST END IN CODE This is...
  5. lindasoph

    Incorrect syntax near

    Thank-you for the valuable information!
  6. lindasoph

    Incorrect syntax near

    Thank-you for the information JonFer. Couple of questions regarding forming and IF statement - when creating an IF statement do you place a BEGIN after the IF conditions an END after the block. EXAMPLE: IF var1 = var2 AND St = State BEGIN INSERT INTO table ----- ----- -----...
  7. lindasoph

    Incorrect syntax near

    The tables and all columns and hold variables are defined. If you would like me to submit all code I can. It is just alot of work because I have to change names of items due company policies.
  8. lindasoph

    Incorrect syntax near

    Your last statement has told me I need to use a SELECT statement. So with that code in place I am still getting the same error: Incorrect syntax near '@hld_gdat'. Revised code: SELECT * FROM [XXXX_dev].[dbo].[tblImport] ci IF ci.TRACKNUM = cs.TRACKNumber AND ci.ID = cs.Id...
  9. lindasoph

    Incorrect syntax near

    I placed the suggested ideas into the code below and received a new Error: Incorrect syntax near '@hld_GDAT'. SQL Code where error is occuring: I also tried a select statement and received the same error. It seems like the if statement is not set up correctly. Could it have something to do...
  10. lindasoph

    Incorrect syntax near

    Can't figure out how to correct this error, also is the commit rollback set up correctly could not find verification or example!! Project Description: Need to run a table (tbl1) of information (ex. Name,Ssn, Amounts) through some joined tables finding out if a record exists. If a record does...
  11. lindasoph

    Print Report footer on each page that prints

    Thank-you, you have been very helpful with the information that was provided in this last post.
  12. lindasoph

    Print Report footer on each page that prints

    I am unable to resolve printing a page footer, report footer and/or group footer. I am mentioning all three types because I worked on trying to printer a footer of some sort on to each page that prints. Is this possible? The solution that was given to me: Right click on the report body, go to...
  13. lindasoph

    Still unable to place footer on each page that prints

    lbass: Thank-you for a reply. I want to print a small amount of data that I copied from the header. Answer to 2nd question: When the info is placed in the footer it prints on the last page only of the report. This works when I have created a report footer and a group footer ( all at separte...
  14. lindasoph

    Still unable to place footer on each page that prints

    I tried "infinitizon" suggestion. After right click on report body, I do not have a Report Option. I see a Report Drop down menu at the top of Crystal Reports Menu but then I not not have a Report Option from there. I am using ver 8.5 if that helps.
  15. lindasoph

    Print Report footer on each page that prints

    Tried a report, page & Group footer to print footer data on every page. Of course report and group footer data printed on last page. I need the data in footer to print on EVERY page. Worked with Section Expert check boxes with no success. Any ideas?
See more

Part and Inventory Search

Back
Top