Search results for query: *

Have a table with column that contains random integers. Need to reassign a portion of these integers based on certain criteria. I want to start from s specific number then increase the counter by one. Am working with something like this but when I try to increase the counter it will not allow...

Have one table with vendor information in it. The vendor may be in this table duplicate times, their fed id number is the same but their index is different. Want to update the index to the lower index number when the fed id number matches. Example : FED ID VendID 123-45-6789 8939...

Am using CRXI. Have a database in Sql 2008 , have 2 tables, The first table (Data) has a column for counselors - this column is an integer that ties back to our user table where the actual name is stored. Example in the Data table counselor = 2. In the User table then 2 is the PK with a column...

Have a cross tab report that shows auditor names in the rows and results in the columns. The results are in 3 categories (Fail, Pass, Pass w/comments). These then total per auditor. I need to find the percentage passed (passed includes passed w/comments). I can create the formula to do all of...

Am using Crystal XI, Have a group on a clientid, within that client am listing different sources of income for them, could have zero to multiple codes and also duplicate codes. Want to display based on one code, in this instance "c" but also only display if this is the only amount. I am able...

Need some assistance on how to proceed with this, have looked at it so long have confused myself by now. Have a query that returns me payments on hold. The query looks like this : SELECT p.scode Property, t.scode TenCode, rtrim(t.slastname) + ', ' + rtrim(t.sfirstname) TenName...

can have numerous inspection dates per client, want to select the top record from each client and display. For instance may have : ClientNo Name Type Date 1 Smith annual 2/1/08 1 Smith annual 2/1/07 1 Smith Initial 2/1/06 2 Doe Annual...

Have 2 queries I am trying to join together. I used the second one as a subquery in the first but am not getting the results I need. Not sure how to get it to segregate based on proeprty since you can't use Group By in the subquery with more than one item returned. The Output from the Queries...

Scripting is not my thing but am trying to write one, have got it so it will log into our application and now i need to select a menuset, just have no idea where to begin on that. Any help is appreciated. My login script looks like this : Set IE = CreateObject("InternetExplorer.Application")...

Have a column in Table A, want that column to be set to the value in another column that resides in Table B. Example : Table A.user_Field = Table B.Client_Num They would be related on a primary/foreign key Table A.HTenant(FK) = Table B.hmyperson (PK) What is the best way to go about this? A...

Am writing my first script and want to be able to login to a website using my login and password. Have found lot's of useful items through here but can't get the login id and password to get entered. It appears that the focus is not being set on the website. It will open the webpage but keeps it...

This is my first time trying to write something in ASP.net so please bear with me if I don't explain it correctly. I created a view in SQL and attached it to a sql data source in my ASP page and displayed it using a data list. I ran the page and the information comes back no problem with the...

I have 2 tables with client information from 2 seperate sources. One table contains all of our clients we know for sure the other we know some are missing and would like to find out which ones are missing. I would like to be able to list all the clients from Table A then match all the clients...

I am using Crystal Reports 9, and have a report that is grouping by month. Within each month is client detail. If the client detail appears twice within that month based on 2 fields being alike (tenant and dtpayfor) I am suppressing the detail with the following formula : ({@sTenant} =...

Using CR9, Have a report that is grouped by a client number, within that have various other information including a status number. Want to show the groups that have only status numbers of 3. Data looks like : Client # Name Status 1 Joe 2 1 Joe 3 2...

I would like a script that when the person opens the spreadsheet they are propmted to choose a source file from a directory location. Once selected the files in this folder are then copied to another static folder.

I need to know how to write a script that when the end user opens the excel spreadsheet, they will be prompted to select a source folder (in a specific directory)once selected the files in that folder will be copied to another static location.

I am using CR9, I am taking a date input from a user, with that date I am selecting a list of criteria from a SQL view. The main component is called lease date. So if a client selects June it will pull back all data that was paid in June and those clients starting lease date, which could be...

Am using CR9, have about 40 lines of data. One data attribute contains a number which represents a number of months. Want to take this number subtract it from the current month and add a counter of +1 to that month and loop until that number is zero then move onto the next line. Continue this...

I have a report that evaluates a change in rent from one line of data to the next and calculates the difference. The report is grouped by a client ID and uses the following formula: If (previous ({vwRentChanges.ContractRent}) < {vwRentChanges.ContractRent}) and ({vwRentChanges.ClientId} =...