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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PETEHO

    Group by to get distinct values

    ...and trans_period = ''12'' group by journal_amount,journal_number,post_date,trans_period,origin order by journal_number end','?' select * from #txn_master ----------------------------------- results below small extract ----------------------------------- company_code journal_id...
  2. PETEHO

    Section Expert Formaula Button Opens but Can't see pop up Box BOXI R2

    Problem solved, schoolboy error, normaly use 2 screens but had one switched off.
  3. PETEHO

    Section Expert Formaula Button Opens but Can't see pop up Box BOXI R2

    I Open Section expert and then press the formula button, it goes to open the pop up formula box but I just cant see it. I have tried everything. Its obviously open as I can not do anything else on screen until pressing escape and I am then back in section expert. I used this last week but...
  4. PETEHO

    Converting a Wildcard in to a number

    use RC001 declare @line_amount integer set @line_amount = null select top 10 * from rec_items where (ABS(line_amount) like convert(int,isnull(@line_amount,'%'))) and rec_id = 'HWK1004' The column itself only contains numbers and is always populated however im using the code to build a report...
  5. PETEHO

    SQL STATEMENT WILL NOT RETURN RESULTS TO EXCEL FROM MSQUERY

    Just as an ODBC query from excel
  6. PETEHO

    SQL STATEMENT WILL NOT RETURN RESULTS TO EXCEL FROM MSQUERY

    ..., trans_period, post_date from ' + @dbname + '.scheme.nltranm where nlyear = 13 and (nlyear + from_period ) > (nlyear + trans_period)and origin =''NJ''and from_period != ''12''' insert into @jrns exec (@sql) fetch next from getdb into @dbname end select * from @jrns
  7. PETEHO

    SUM on a field

    I want to sum journalamt but using the part field in the group by satement but it will only let me use the posting_code field I know its probably simple but I don't write SQL SELECT journal_number, Left(posting_code,2) as part, SUM(journal_amount) as journalamt FROM...
  8. PETEHO

    Creating a Positive or Negative Field

    ...along that path, however I have something slightly amiss.I am getting and Invalid relationship operator for the following. Sum(case when Mi Suspense Analysis V\Debit Credit Ind = 'CR' then Mi Suspense Analysis V\Suspense Amt *-1 else Mi Suspense Analysis V\Suspense Amt) Any idesa Cheers...
  9. PETEHO

    Creating a Positive or Negative Field

    ...to show the value of these value field as a Debit or credit. These are running against oracle databases My field indicator is either DR or CR. I would imagine the select statment in the universe to be SUM(amount) * -1 where DRCR indicator like 'CR' else SUMAmount). Can anyone advise please
  10. PETEHO

    Not a single-group group function

    ...a single-group group function) select '01 Arrears' as arrears,a.agreement_type as Agreement_type,a.agreement_status as agreement_status ,count(*) as count,a.prb_number as prb_number,a.prb_fund_type as fund_type, sum(a.wkprem * ((to_date(sysdate,'dd/MM/yy') -...
  11. PETEHO

    FILE ACCESS DENIED

    I have some users who use a VFP routine. We had a power cut and when they try to access their routines they get the message file access denied. How can I unlock these tables. I do not use vfp but I can usually get by Thanks
  12. PETEHO

    Links for GL Tables in GP

    Thanks for that info I will have a go. I don't have the software discs to load SDK. Its the world of cost cutting. We are merging two compnies accounts accross from GP to Sage. We have 100 companies on Sage and two on GP. Sage won hands down as it needs doing by July 1st Thanks Pete
  13. PETEHO

    Links for GL Tables in GP

    I have been tasked with migrating data from a Great Plains Database to a Sage Database. I am only moving general ledger data. I was wondering if anyone had a copy or knew where I could find a diagram of how the data is linked within the GL tables. I seem to get so far then it all goes pear...
  14. PETEHO

    Excel and Business Objects

    I have created a Universe based on a single excel worksheet with 70 columns, nothing fantastic. I created the universe and inserted table,all 70 column headings are shown. to check it was reading this correctly I did a count of Rows and got the following error 'Syntax error in From Clause' If...
  15. PETEHO

    BCP UNION QUERY

    I am trying to run the following bcp union query. I have two queries on two tables that I am trying to join the output for. Individually they work but it doesn't like the UNION command. Any Ideas would be helpful @bcp "select 'SL613'...
  16. PETEHO

    MS QUERY in Excel Vanishes

    I have some users who run various MS QUERY's. I have written some and some they write themselves. Some of these queries run when you open the excel spreadsheet. You can refresh them once but then the ability to refresh dissapears and you can not edit the query. On some spreadsheets this happens...
  17. PETEHO

    VB Macro Error

    Thanks Guys All sorted. Removed the bracket and all was fine. Had my head spinning and just could think logically after a while Cheers Pete
  18. PETEHO

    VB Macro Error

    ...Range("J" & PensionRowNum).Select ActiveCell.FormulaR1C1 = "=IF(ISERROR(SUM(Permanent_Staff!AO16:AO500)/V" & BasicPayRowNum & "*J" & BasicPayRowNum & ")," & NullString & ",(SUM(Permanent_Staff!AO16:AO500)/V" & BasicPayRowNum & "*J" & BasicPayRowNum & "))"...
  19. PETEHO

    Charts and Naming

    I have a Chart which is fine, however when I create the chart it take my group name before it was formatted. My report shows groups as Feb 2007 but the chart reverts to the pre formatted version as 02/2007. Any Ideas Pete
  20. PETEHO

    Conditional Variables

    I have some users who want some extra info for a one off report.Basically they want to report on a field from the universe which is ytdspend. They want this column 7 times but the YTD amount is dependant on an account code. How do I set each column up to report differently for the same field in...

Part and Inventory Search

Back
Top