Search results for query: *

Hello, I have a table with 3 fields id_person, id_event, value I need to divide all id_person(s) into deciles/quartiles. I am using ANSI SQL on Netezza and it does not support the Quartile/Ntile functions. How can I write a manual query to give me a list of id_persons, sorted in descending...

Hello, I have a table with 3 columns, where person_id is unique id. <person_id> <event_type> <number_events> 1. I need to transform this into a table with <person_id> <event_type1> <event_type2>.... <event_type-n> And under each column I need to fill the number_events for each event_type for...

Hello, I have a table with 3 columns, where person_id is unique id. <person_id> <event_type> <number_events> 1. I need to transform this into a table with <person_id> <event_type1> <event_type2>.... <event_type-n> And under each column I need to fill the number_events for each event_type for...

I have an excel spreadsheet which has a 3 columns b.) From Process c.) Process Descriptions d.) To Process I need to conver this spreadsheet to a flowchart in excel or visio, or any other MS.OFFICE platform. If the above format is not possbile to be converted but you know of another way to...

This maybe a very elementary question, but I don't know how to set it up. I need to develop a form, so that people can fill it, submit it and it will populate values in a database. ( I can do this part). However, I need to put this form on the web, so people can click online and it can populate...

1.) In Excel VB Editor, is there a way to code a subroutine, to open an external .exe file. 2.) If the above is possible, the external .exe file is an internal company program with a text prompt like DOS (or UNIX), IS THERE A Way I can have the computer run a key combination like CTRL+X or...

any way to code a subroutine to check if a folder is present or not. i know how to make the folder, but it doesn;t work if its already there...

I have some code that I wrote in Excel 2003, which doesn't really involve Excel, I was wondering if there's a way I can convert this code into a .exe application file, and make that .exe a scheduled task or something like that. ??

How can i convert some VB code to a standalone .exe program.

I need to write a standalone program or a function/macro built in excel or word to do some string replacement in a very wierd text file. This file looks something like this.... HRBATL22DEC0500-0659$EV¥L<enter>HRBATL23DEC0500-0659$EV¥L....(unicode text characters). It is a series of dates and...

I have a table that has a column with shift, and a number of different fields, like say VAL1, VAL2, VAL3....VAL10. I built a query that groups the totals for each "VAL" by shift. This gives me all the information but in horizontal format. However, I need to build a report in vertical format...

In Access when you design a query with groupped totals, the result shows , for eg. - SumOf<FieldName>. Is there a way to edit this title ?

IS there a way to use the table field description for Forms. So that instead of the field name it shows the field description, like say for a survey or something ?

Is there a way I can use a fieldname in a query. Like I have a table with Section Number and Section Names. I also have a table with Question Number and Section Numbers. Then I have a table with Question Number, and names of different categories. These categories are the fieldnames for a...

I have the following code in a macro that extracts data from a folder on a shared drive. With ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;J:\Airport Customer Service\Analyst\Coop\Herby Folder\HERBY PROGRAM\HRBDATA.TXT" _ , Destination:=Range("A1")) .Name = "HRBDATA" End With How do I...

What statement should I write in a macro to open an external .xls file. Any directions / precautions for the path would also be helpful.... Right now, my macro can't open the file, it assumes that the file is open and then "activates" that window. Please let me know ASAP.

This isn't that much a technical question as much as I need a recommendation for setting up queries and reports in a database. The main table consists of 3 fields, Date, Shift, Area. and then fields for various numbers. I need to find the best way to set up a query / reports, that calculate...

In my company there is a program that pulls information from various systems. This "information pulling" I have to execute every Monday and Thursday for 7 days in advance. Its like forecasts and stuff. I used to enter each day's commands in the system manually, but I discovered a "macros...

When you place an Excel spreadsheet in Page Break Preview to view only the populated cells, a "Page 1" Text appears in the background. How do I remove that. Or ensure that only that 1 page is shown.

I have a file that processes data for the current week, and has a set of numbers, say two columns, one with date and one with the number. However, every Monday and every Thursday, I have to use this data processing file and copy the numbers for this week and paste them in an archive Excel...