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: *

  • Users: brendasql
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. brendasql

    Smartlist Results Double the Actual Qty

    I am using GP9 and I received an emailed from one user saying that when she would export her smartlist results to excel that only half the items were being exported. I tried several and so far I can only see this problem in Purchase Line Items. At the bottom of the smartlist results grid the...
  11. brendasql

    Order being transferred to Invoice

    Hi, I have an order that was transferred to an invoice, but only 2 out of the 3 items on the order was invoiced. The user assumed that it was hung up and they have now VOIDED the order. Is there a way to unvoid the order. I can see both the order and the invoice in the SOP30300 table. And what...
  12. brendasql

    Share Email Account

    Hi, I am having a problem with sharing an email account. I have followed all the necessary steps for sharing and giving permissions and it works great, except it the owner is out of the office and their pc is off. Any suggestions? The intent of sharing this email account was because of...
  13. brendasql

    Can you perform field updates using sql query analyzer

    I am rather new to using Great Plains, but I have used sql 7 and sql 2000. I was wondering if I could perform a update query on RM00101 table to update the userdef1 column and the comment1 column? I have a spreadsheet that contains some key information on our customers and I would like to update...
  14. brendasql

    Need report to show last year sales and this year and the variance

    Hi, I'm trying to create a report that will be display as a crosstab. I would want the customers as my rowheaders and my column headers to be LY/MTD, TY/MTD, and var% (this being (TY/MTD - LY/MTD)/ LY/MTD) group by month. I have tried writing a command to give me the qty for 2005 and 2006, but...
  15. brendasql

    Adding Command creates database warning error

    Hi, I am trying to add a sql command in Crystal X1. After I create it and finish linking to tables I receive an error "More than one datasource or store procedure has been used in this report. Make sure that no SQL expression is added and no server side group by is performed. " When I refresh...
  16. brendasql

    Can not compare dates

    I am trying to do a validation check on dates entered by my users. This date can not be greater than today’s date. The problem is comparing the whole date (MM/DD/YYYY) Example Values Current date = ‘07/13/2005’ Input Date1 = ‘07/13/2050’ Input Date2 = ‘07/11/2050’...
  17. brendasql

    Update TABLE(B) because of changes made to TABLE(A) using trigger

    This is my first experience with triggers so any help would be great. I am trying to figure out how to write a trigger that will update a column in Table(B) based on changes to a column in Table(A). I thought I should place the trigger on Table(A) and that the trigger should be something like...
  18. brendasql

    Random Generate Number

    I have a LostFocus sub routine that will generate a random ID number for adding a new record. When the user clicks the command button Save New it gives the user an error if this number already exist in the table. I did not use the auto random numner in ACCESS because users wanted a unique number...
  19. brendasql

    Problem with Comparing dates

    I am having a serious problem trying to compare dates. I am trying to compare a specific month like someone's birthmonth to another specific month like one that has been stored as an Issue date. An example of the problem is that I have a person with a birth month of February (2) and an Issue...
  20. brendasql

    How to get a Random Sample of 10%.

    I am trying to retrieve a list for a random audit of new entries in our database. The list (report) needs to be 10% of the total new entries. I have written a store proc to retrieve my number for the 10%, but I'm having a hard time trying to input this into another store proc or in VB6 code. My...

Part and Inventory Search

Back
Top