Search results for query: *

Trying to get sum of parent and child accounts from the following: ID Account Amount LeadingSpaces 13 4050.01 500 9 14 4050.06 3240 9 38 5010.01 4679.49 9 39 5010.1A 1263.97 12 41 5010.04 834.33 9 42 5010.4A 458.6 12 48 5050.01 1355.96 9 99 5430.01 1340 9 100 5430.21 1216.03 12 The Results...

Markros, what is LTD? Thanks,

Thank you!! this works perfectly!

Is there a way for me to count the number of spaces before the first character in a row? We are receiving files that have parent and child accounts and the only way to tell that it's a child account is that it's indented. thanks.

we have users who are trying to open an excel file from a trusted source. We have been able to do this up until the past few days. We are able to save the file and then open it with no problems, but we just can't open it directly. We are all local admins on our machines. the exact errors that...

Please ignore. Apparently the user was having some 'issues' and we've figured out what his problem was. Totally user error. ll

I have a user who is able to view reports that have been deployed. He is the only one in our group who is using vista, and seems it as if he is the only one who consistently has problems. His main problem is that when he runs one of the reports the data is either wrong or missing. When someone...

https://www.mysite.com/validate.cfm?ref=<<mergfield>> URL does not have a semi colon(;) in it, that was a tyop.

We have an email that will be going out to customers. In the email we have a url that has information linking that customer with a unique key. When they click on the key it should pre-populate the webform the url brings them to. I'm having a problem with getting the url being a hyperlink and...

We have several people using the same access database. They want to be able to have the employee's name automatically be added to the records that the emp is updating. Right now they are pulling the information from a drop down menu, but they are complaining that it is taking too long. Does...

one of our users is getting the following error when trying to use IM for importing a budget. Unknown Great Plains field subtype ‘1565’ I've done some searching and all I'm coming up with is old information. We are in a test invironment for GP 10. I'm thinking it has something to do with...

I’m trying to pull together some data. We have different locations enter in survey data each year. Some locations may be late in entering in their data, and some haven’t entered data for several years. I need to be able to pull the data for the last given year that someone has entered in data...

Thank you that worked perfectly. I had 'figured' it out a few days back and lost all of my work and had no idea what I had actually done to get it to work. It's all a learning process!

I have a report that contains partial information on employees. You can search by last name and it will give you all matches for that name. I have it set up so that when you click on the employee ID it 'should' link to a second report that gives an expanded view of of the employee that you...

Let me explain a little more what I'm looking for. The first example worked wonderfully when I was using only two parameters. I should have mentioned in my original posting that I am going to need to be able to search on 8 different fields. name1 name2 address1 address2 city state zip county...

I have the following and I need to have the variables 'search' for data that 'contains' the data a user enters. Eg. For either OWNNAME1 or OWNNAME2 A user types in mont and they would get records that matched Montana, and Fairmont. How can I Acheive this with what I already have? DECLARE @sql...

Integration Manager GP - Payables Can someone give me an example of the basic fields and file set up that they use for using Integration Manager for accounts payables. These are the fields we are trying to enter right now. vendor ID Account DESCRIPTION amount dr_cr amt doc...

Thanks for the reply. A big fat column of white is not what we were hoping for! :) The problem is, with so many schools, one school may not have reported in 2000, and another in 2004 and so on. So it's not as easy as just removing them from the report.

We'd like to be able to hide a column in a report when the total value of the column is zero. We have 85 schools that report various information to us, # of teachers, if they are certified, classes they teach etc. If a school didn't report to us in any given year we'd like to be able to just...