Assign a serial number for each group
I want to assign a serial number for the below data using the Access query or by using SQL for Access DateItems Sold2/1/20135462/1/20138975/1/20132565/1/201310325/1/20137858/2/20136548/2/20131211 I want the output like as below: S.noDateItems Sold12/1/201354622/1/201389715/1/201325625/1/2013103235/1/201378518/2/201365428/2/20131211 Can anyone help me?
Answer Question
| February 25, 2013 9:59 AM
Microsoft Access 2002, SQL 2000
I want to assign a serial number for the below data using the Access query or by using SQL for Access DateItems Sold2/1/20135462/1/20138975/1/20132565/1/201310325/1/20137858/2/20136548/2/20131211 I want the output like as below: S.noDateItems Sold12/1/201354622/1/201389715/1/201325625/1/2013103235/1/201378518/2/201365428/2/20131211 Can anyone help me?
Answer Question
| February 25, 2013 9:59 AM
Microsoft Access 2002, SQL 2000
About CRTPGM command
I have a module which has a copy book in it and when I am creating a main PGM with the command CRTPGM by giving the module name itself as the PGM name and binding the service programs, I am getting an error which says that the procedures which are defined in the copy book [...]
Answer Question
| February 25, 2013 7:04 AM
AS/400, CRTPGM
I have a module which has a copy book in it and when I am creating a main PGM with the command CRTPGM by giving the module name itself as the PGM name and binding the service programs, I am getting an error which says that the procedures which are defined in the copy book [...]
Answer Question
| February 25, 2013 7:04 AM
AS/400, CRTPGM
Global address list in OWA Exchange 2013
I am using Exchange Server 2013 and our remote users are using Outlook web access 2013. The global address list is empty and the email address of the users are not available. How can I add all the users in the global address list? Can you please give me a guide or procedure on how to [...]
Answer Question
| February 25, 2013 6:53 AM
Microsoft Exchange Server, Microsoft Outlook 2013
I am using Exchange Server 2013 and our remote users are using Outlook web access 2013. The global address list is empty and the email address of the users are not available. How can I add all the users in the global address list? Can you please give me a guide or procedure on how to [...]
Answer Question
| February 25, 2013 6:53 AM
Microsoft Exchange Server, Microsoft Outlook 2013
A manufactured part was over reported
A manufactured part was over reported, so now I show 20 parts available in MAPICS that do not exist. How do I fix this?
Answer Question
| February 25, 2013 11:16 PM
MAPICS, POWERLINK
A manufactured part was over reported, so now I show 20 parts available in MAPICS that do not exist. How do I fix this?
Answer Question
| February 25, 2013 11:16 PM
MAPICS, POWERLINK
Lost paper
MS Word lost my document. I didn’t save it…what do I do now?
Answer Question
| February 25, 2013 11:03 PM
Microsoft Word, Microsoft Word documents
MS Word lost my document. I didn’t save it…what do I do now?
Answer Question
| February 25, 2013 11:03 PM
Microsoft Word, Microsoft Word documents
Why is my internet so slow?
So here’s my story. I have an AMD quad core running Windows XP 32-bit that has 4 gigs of RAM and a 100 Mbps NIC. My internet is slow, but only in certain circumstances. If I get on YouTube, it takes 5-10 minutes to load a 2 min video in 720p. Its the same with [...]
Answer Question
| February 25, 2013 10:22 PM
Internet access, Internet connection, Internet speed
So here’s my story. I have an AMD quad core running Windows XP 32-bit that has 4 gigs of RAM and a 100 Mbps NIC. My internet is slow, but only in certain circumstances. If I get on YouTube, it takes 5-10 minutes to load a 2 min video in 720p. Its the same with [...]
Answer Question
| February 25, 2013 10:22 PM
Internet access, Internet connection, Internet speed
Science graduate wants to learn SAP
I am a Science graduate with 10 years of experience of sales coordination in finance field . Currently I am working as Customer service executive with a production company. I want to learn SAP and want to grow in the field. What are the opportunities and which module is good for me? Please suggest.
Answer Question
| February 25, 2013 5:34 PM
SAP, SAP Career
I am a Science graduate with 10 years of experience of sales coordination in finance field . Currently I am working as Customer service executive with a production company. I want to learn SAP and want to grow in the field. What are the opportunities and which module is good for me? Please suggest.
Answer Question
| February 25, 2013 5:34 PM
SAP, SAP Career
Wireless printer connect / disconnect
Why does my Epson all-in-one wireless printer constantly connect & disconnect to my Belkin N server?
Answer Question
| February 25, 2013 4:56 PM
Belkin, Epson, Wireless printers
Why does my Epson all-in-one wireless printer constantly connect & disconnect to my Belkin N server?
Answer Question
| February 25, 2013 4:56 PM
Belkin, Epson, Wireless printers
How to play SV5 file? Which player play SV5 file format?
How to open SV5 file format? Which player plays SV5 format and which converter converts SV5 file?
Answer Question
| February 25, 2013 2:06 PM
.SV5 file, Windows 7
How to open SV5 file format? Which player plays SV5 format and which converter converts SV5 file?
Answer Question
| February 25, 2013 2:06 PM
.SV5 file, Windows 7
Name in Gmail account
Name in settings>account>edit info is Linda Davis. Name people see when they receive my email is Linda David, which is not correct. How do I correct this?
Answer Question
| February 25, 2013 12:43 PM
Gmail, Gmail accounts
Name in settings>account>edit info is Linda Davis. Name people see when they receive my email is Linda David, which is not correct. How do I correct this?
Answer Question
| February 25, 2013 12:43 PM
Gmail, Gmail accounts
PST file export
I have transferred my e-mail PST files from my Windows 7 desk top at work and would like to read them on my Macbook Pro. I downloaded a PST bridge program but still cannot open the e-mails on my Macbook
Answer Question
| February 25, 2013 10:32 AM
.PST files, MacBook
I have transferred my e-mail PST files from my Windows 7 desk top at work and would like to read them on my Macbook Pro. I downloaded a PST bridge program but still cannot open the e-mails on my Macbook
Answer Question
| February 25, 2013 10:32 AM
.PST files, MacBook
Code review checklist for AS/400 application
Hi, As part of Unit Testing process documentation, I need to prepare ‘Code review checklist’ for AS/400 application. Request the members to please share the same.
Answer Question
| February 25, 2013 6:17 PM
AS/400, AS/400 applications
Hi, As part of Unit Testing process documentation, I need to prepare ‘Code review checklist’ for AS/400 application. Request the members to please share the same.
Answer Question
| February 25, 2013 6:17 PM
AS/400, AS/400 applications
BA with MBA
I did my BA in degree and the next thing I had done was my MBA in Finance. Can I do SAP FICO and get a job in Finance sector?
Answer Question
| February 25, 2013 8:18 AM
SAP Career, SAP FICO
I did my BA in degree and the next thing I had done was my MBA in Finance. Can I do SAP FICO and get a job in Finance sector?
Answer Question
| February 25, 2013 8:18 AM
SAP Career, SAP FICO
Query in subfile with SFLNXTCHG
I have a subfile with an option F8 to clear all the records. When F8 is taken, I will clear all the fields and will update the SFL record format. After F8, if an enter is taken, I want to update the file with the blank values. But the problem is since am not typing [...]
Answer Question
| February 25, 2013 4:34 AM
AS/400, AS/400 Subfiles
I have a subfile with an option F8 to clear all the records. When F8 is taken, I will clear all the fields and will update the SFL record format. After F8, if an enter is taken, I want to update the file with the blank values. But the problem is since am not typing [...]
Answer Question
| February 25, 2013 4:34 AM
AS/400, AS/400 Subfiles
NIF files
I have a new Google Chromebook and I need to open nif files is there an app for that in the Google store?
Answer Question
| February 25, 2013 3:52 AM
Chromebook, nif file
I have a new Google Chromebook and I need to open nif files is there an app for that in the Google store?
Answer Question
| February 25, 2013 3:52 AM
Chromebook, nif file
Excel formula program
Hi, I’m trying to do a table where I need to calculate how much commission I’m paying for a company. Before 35,000, I pay 35% commission after 35000 I pay 10%. The formula I have right now is =(IF(F9>=35,F2:F8*0.1,(IF($F$9<=35,F2:F8*0.35)))) and it works, but… I don’t want the whole column to change to 10% because I [...]
Answer Question
| February 25, 2013 1:59 AM
Microsoft Excel 2007, Microsoft Excel formulas
Hi, I’m trying to do a table where I need to calculate how much commission I’m paying for a company. Before 35,000, I pay 35% commission after 35000 I pay 10%. The formula I have right now is =(IF(F9>=35,F2:F8*0.1,(IF($F$9<=35,F2:F8*0.35)))) and it works, but… I don’t want the whole column to change to 10% because I [...]
Answer Question
| February 25, 2013 1:59 AM
Microsoft Excel 2007, Microsoft Excel formulas
Why limit CLI access on AS/400?
A little background… I am new to the compliance and auditing field and recently introduced to the AS/400 system and I am constantly seeing in best practice environments that the CLI be restricted from most users and or at least limited capabilities set to *YES. To the point… The system administrator for the AS400 is [...]
Answer Question
| February 25, 2013 12:13 AM
AS/400, AS/400 - CL Command, AS/400 security
A little background… I am new to the compliance and auditing field and recently introduced to the AS/400 system and I am constantly seeing in best practice environments that the CLI be restricted from most users and or at least limited capabilities set to *YES. To the point… The system administrator for the AS400 is [...]
Answer Question
| February 25, 2013 12:13 AM
AS/400, AS/400 - CL Command, AS/400 security
Window keyword in display file
I have a program that displays a list of items and when one is selected it pops a window with detailed information. When I select an item, my window will not display. Is there a configuration/setting somewhere on the AS/400 that would keep the window from displaying ?
Answer Question
| February 25, 2013 10:18 PM
AS/400, AS/400 Display File
I have a program that displays a list of items and when one is selected it pops a window with detailed information. When I select an item, my window will not display. Is there a configuration/setting somewhere on the AS/400 that would keep the window from displaying ?
Answer Question
| February 25, 2013 10:18 PM
AS/400, AS/400 Display File
IT help desk first come first serve
Why is it good or bad to operate an IT support services system (help desk) on a strictly, first-come, first-served basis?
Answer Question
| February 22, 2013 9:17 PM
IT Help Desk, IT support
Why is it good or bad to operate an IT support services system (help desk) on a strictly, first-come, first-served basis?
Answer Question
| February 22, 2013 9:17 PM
IT Help Desk, IT support
RPGLE SETLL / READE for update getting record lock on different key
We are encountering sporadic unexpected record locks with update files using: setll (Key1) MasterFile; // Partial key. dou %eof(MasterFile); reade (Key1) MasterFile; if not %eof(MasterFile); // [Stuff] update MasterFmt; endif; enddo; Looking at the problem record by RRN, its key does not match Key1. It’s not even the next sequential key value in the file. [...]
Answer Question
| February 22, 2013 8:59 PM
READE, Record lock, RPGLE
We are encountering sporadic unexpected record locks with update files using: setll (Key1) MasterFile; // Partial key. dou %eof(MasterFile); reade (Key1) MasterFile; if not %eof(MasterFile); // [Stuff] update MasterFmt; endif; enddo; Looking at the problem record by RRN, its key does not match Key1. It’s not even the next sequential key value in the file. [...]
Answer Question
| February 22, 2013 8:59 PM
READE, Record lock, RPGLE
