Recent content by brendasql

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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