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 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. brendasql

    Assistance Needed Using a SQL Where Clause

    Thanks for responding xwb! This worked...[thumbsup]
  2. brendasql

    Assistance Needed Using a SQL Where Clause

    Hi All - New to C++ and I am having problems with the syntax. I have been able to make a ADODB connection string to work and I can do a "Select Field from Table" to return the results. Please note that at the moment I only have one record in the table so it only returns this one record, however...
  3. brendasql

    Need help with formula to sum where field is distinct

    I wanted to update you on the status of this. Thanks to LBass's suggestion I was able to figure out the solution. I created 2 Running Totals, the first was a SubTot on companies - distinct count and evaluate using formula and then RESET on change of Group - COUNTY. This runing total I placed in...
  4. brendasql

    Need help with formula to sum where field is distinct

    Thanks LBass, but this only gives me the grand total. I need this count per county level as well. Any other suggestions?
  5. brendasql

    Need help with formula to sum where field is distinct

    Hello - I need assistance with a subreport. I can have multiple clients per companies and mulitple companies per county. I am able to get my distinct count of both the companies and clients by county but I am unable to sum the contacts that were made within the a set timeframe. Example of data...
  6. brendasql

    Making changes to the CustName and Address

    Hello All, I was wondering if any of you knew if I could make changes to the custname and adrsCode using sql instead of doing all changes to the Customer Maintenance Card in GP. I can see the items that I want to change in these tables RM00101 and RM00102. The whole purpose of wanting to make...
  7. brendasql

    How to correct Sales applied to wrong customer?

    Hi All! My problem is that a customer card was created twice for the same customer. The first card was created 6 months ago and then 6 weeks ago someone created a new card for this same customer and gave them a new number. Sales orders and invoices have been applied now under both customer...
  8. brendasql

    Admin Account that can Mirror User Account

    I think that this would make it easier for him to see what they are doing. I really don't think that this is possible and of course he doesn't like my suggestion to sign in as them......he has a copy of everyone's passwords and their user names. He has been rather upset since he discovered that...
  9. brendasql

    Admin Account that can Mirror User Account

    Hi all, My boss wants to have an admin account and password that will allow him to sign into any users computer and view/work as if it was them logged in. He does not want to sign in as the Network Administrator and have to explore through their MyDocuments Folder, and favorites folder. He wants...
  10. brendasql

    Beginng and Ending balance in GL Trail Balance

    Thanks Lyle! It is not the greatest news but it definitely points me in the right directions.
  11. brendasql

    Beginng and Ending balance in GL Trail Balance

    Can someone tell me where the beginning and ending balances come from that are display in the GL Trail Balance report. I am trying to create a short version of this report that can be pulled using Crystal as a daily Cash Report. I have located my journal entries, but I am totally lost trying to...
  12. brendasql

    Adding a second page for Terms to Invoice Form

    Victoria, That's real interesting. I have created several reports in CrystalXI, which is being used as a stand-alone. All of these reports are for summary of sales, and a few for inventory. I will start trying this option now. Thanks! Brenda
  13. brendasql

    Adding a second page for Terms to Invoice Form

    Thanks for responding David. No we do not have Modifier or VBA, so I guess that means that we are stuck with doing things the way that we are for now. Brenda
  14. brendasql

    Adding a second page for Terms to Invoice Form

    Does anyone know if this can be done in GP9? I am trying to modify the blank invoice form to include a second page that would be the Terms and Conditions of Sale. Currently users are loading pre-copied sheets with the Terms and printing the invoices onto the sheets that way. I would like to...
  15. brendasql

    How to make sense of it all?

    Xomp, Go for it! Install that copy of SQL and have yourself a ball. I have an Assc degree in CIS and never learn the first thing about SQL in school, but my first job was as a VB6 programmer and our database was in SQL7, since then I have work in SQL2000 and now in SQL2005. I have also...
  16. brendasql

    What populates the GL10110

    Thanks. I still do not understand why my report is not the same as the information in this table. I have written a command in Crystal to pull from the sales transaction line items (SOP30300) and selecting the sum(QTY) for my number of items sold and SUM(XTNDPRCE) for my total sales. I believe...
  17. brendasql

    What populates the GL10110

    I was wondering if anyone could tell me what tables are used to populate the GL10110. The GL10110 table is used to populate the Summary Inquiry Report. I have a crystal report that I created to show our sales by customer class and my sales figures are not matching the General Ledger Summary...
  18. brendasql

    Appears to be stuck as Queued

    No, No Alerts and it is not requiring a new disk. Also, I just purchased new disks. What I working on are my daily backups and I am backing them up to a Rev disk. I hope that I am explaining this correctly. Thanks again Brenda
  19. brendasql

    Appears to be stuck as Queued

    I am running Veritas 9 Exec and have been having some issues with jobs failing. I have been working through all the Failures and I tried a Test Run and it was successful, so I decided to Run Now. It has been stuck as Queued for the past 2 hours. I am afraid that this is going to have a Time Out...
  20. brendasql

    Smartlist Results Double the Actual Qty

    Thanks for responding! At least I can now be sure that I didn't do anything wrong. Maybe the next upgrade will take care of this bug.....[noevil]

Part and Inventory Search

Back
Top