Microsoft Access counting part of a field
I have a field that I need to count per group. The field contains whole numbers and decemal numbers. I only want to count the whole numbers. The field is a text field, because there is a chance the actual text can be a value. I tried using IIf, but could only put one condition; the field [...]
Answer Question
| March 1, 2010 7:50 PM
Microsoft Access
I have a field that I need to count per group. The field contains whole numbers and decemal numbers. I only want to count the whole numbers. The field is a text field, because there is a chance the actual text can be a value. I tried using IIf, but could only put one condition; the field [...]
Answer Question
| March 1, 2010 7:50 PM
Microsoft Access
SQL for Microsoft Access
I have crated the below SQL statement. I works fine. and it gives me the required “RTCDate” I need, that which is difined at the Where statement of 3 - 2010. The other constraints are that I need all my 79 product line numbers. and the “1″ is those product line numbers that are active and current. So all the above [...]
Answer Question
| April 5, 2010 12:24 PM
Microsoft Access, SQL
I have crated the below SQL statement. I works fine. and it gives me the required “RTCDate” I need, that which is difined at the Where statement of 3 - 2010. The other constraints are that I need all my 79 product line numbers. and the “1″ is those product line numbers that are active and current. So all the above [...]
Answer Question
| April 5, 2010 12:24 PM
Microsoft Access, SQL
Sql Query For My sql
I have two database tables Employee and salary Where Employee maintains details about employee And the salary table maintains data about Payroll entry. Iwant the query for Select the employees who have not got salary for a particular month I have already tried this select employee.empid , salary.empid , employee.name from salary , [...]
Answer Question
| June 2, 2010 10:15 AM
MySQL, SQL Query
I have two database tables Employee and salary Where Employee maintains details about employee And the salary table maintains data about Payroll entry. Iwant the query for Select the employees who have not got salary for a particular month I have already tried this select employee.empid , salary.empid , employee.name from salary , [...]
Answer Question
| June 2, 2010 10:15 AM
MySQL, SQL Query
MySQL Access Denied error
I have installed mysqlcc-0.9.4-win32. After giving user name, password etc and add connection, connection is sucessfully added. But when trying to connect to the website the following error is displayed ERROR 1045: Access denied for user ‘epfkeral_epfkera’@’117.206.11.168′ (using password: YES) How to solve this problem.
Answer Question
| February 23, 2010 4:17 PM
MySQL, MySQL Access Denied error
I have installed mysqlcc-0.9.4-win32. After giving user name, password etc and add connection, connection is sucessfully added. But when trying to connect to the website the following error is displayed ERROR 1045: Access denied for user ‘epfkeral_epfkera’@’117.206.11.168′ (using password: YES) How to solve this problem.
Answer Question
| February 23, 2010 4:17 PM
MySQL, MySQL Access Denied error
MS-Access linked table to AS/400 file – can’t retreive field descriptions/headings
I have created a linked table in MS-Access 2003 over an AS/400 file. It works pretty well so far. The problem I have is I only get field name and type. I don’t get any field description or heading information form the file. Any suggestions on how I can retrieve the descriptive info as well?
Answer Question
| March 1, 2010 7:46 PM
Access 2003, Microsoft Access, OS/400
I have created a linked table in MS-Access 2003 over an AS/400 file. It works pretty well so far. The problem I have is I only get field name and type. I don’t get any field description or heading information form the file. Any suggestions on how I can retrieve the descriptive info as well?
Answer Question
| March 1, 2010 7:46 PM
Access 2003, Microsoft Access, OS/400
SQLRPGLE – Result Set
I have an SQLRPGLE program [PGMA] containing the following: D ResultSet DS D Qualified D Occurs( 9999 ) D AAuUserId 10 D AAuValFr 10 C/EXEC SQL C+ CALL XXDLIB/PGMB (:##BegNo, :##EndNo, :##UserID) C/END-EXEC PGMB has the same DS structure defined as in PGMA and successfully populates the DS ResultSet in PGMB How do I get SQLRPGLE [...]
Answer Question
| February 26, 2010 2:37 PM
AS400 Data Definitions, Data structures, Programming, RPGLE, SQLRPG, SQLRPGLE
I have an SQLRPGLE program [PGMA] containing the following: D ResultSet DS D Qualified D Occurs( 9999 ) D AAuUserId 10 D AAuValFr 10 C/EXEC SQL C+ CALL XXDLIB/PGMB (:##BegNo, :##EndNo, :##UserID) C/END-EXEC PGMB has the same DS structure defined as in PGMA and successfully populates the DS ResultSet in PGMB How do I get SQLRPGLE [...]
Answer Question
| February 26, 2010 2:37 PM
AS400 Data Definitions, Data structures, Programming, RPGLE, SQLRPG, SQLRPGLE
The most-watched IT questions this week: Feb. 16, 2010
1. JHite ran into an Outlook 2003 display name issue for contact with multiple email, and XENOPHON22, Mrdenny and Carlosdl helped out. 2. Windows Server 2003 is giving a member some installation trouble, and MrDenny offers some advice. 3. Can you block Exchange 2007 admins from viewing other admin’s mailboxes? No, according to Technochic and [...]
Answer Question
| February 17, 2010 3:36 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
1. JHite ran into an Outlook 2003 display name issue for contact with multiple email, and XENOPHON22, Mrdenny and Carlosdl helped out. 2. Windows Server 2003 is giving a member some installation trouble, and MrDenny offers some advice. 3. Can you block Exchange 2007 admins from viewing other admin’s mailboxes? No, according to Technochic and [...]
Answer Question
| February 17, 2010 3:36 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
Auto-Populate an Access form using a table of values
I’m having a little bit of a dilema. I don’t even know if it can be done, but I thought I’d give it a shot. I’m pretty new to Access so I’ll try to be as clear as I can be, but I think this will get confusing. I have Multiple tables and a form for adding [...]
Answer Question
| February 17, 2010 8:56 PM
Access 2003, Access forms, Microsoft Access
I’m having a little bit of a dilema. I don’t even know if it can be done, but I thought I’d give it a shot. I’m pretty new to Access so I’ll try to be as clear as I can be, but I think this will get confusing. I have Multiple tables and a form for adding [...]
Answer Question
| February 17, 2010 8:56 PM
Access 2003, Access forms, Microsoft Access
Database Track Payment Information
I need some expert advice. I need an application to track payment information. The payments are actually stored on the AS400 and the payment arrangements are stored currently on paper. I was considering using Access and setting up an ODBC/OLEDB driver to my AS400 to collect the most update to date payment information. Is this [...]
Answer Question
| February 16, 2010 2:46 PM
AS/400, Database, Microsoft Access 20007
I need some expert advice. I need an application to track payment information. The payments are actually stored on the AS400 and the payment arrangements are stored currently on paper. I was considering using Access and setting up an ODBC/OLEDB driver to my AS400 to collect the most update to date payment information. Is this [...]
Answer Question
| February 16, 2010 2:46 PM
AS/400, Database, Microsoft Access 20007
SQL Access Query
I am using the book SQL for Microsoft Access. and the below statement is from the book and for some reasone I am getting a sytex error on the word “Udate” Why would that be? CREATE TABLE Manufacture ( ManufactureID INTEGER CONSTRAINT ManfID PRIMARY KEY, ToyID INTEGER NOT NULL, CompanyName CHAR (50) NOT NULL, [...]
Answer Question
| February 16, 2010 11:00 AM
Access Datasheet, Access query, Microsoft Access, SQL, SQL Access, SQL Query
I am using the book SQL for Microsoft Access. and the below statement is from the book and for some reasone I am getting a sytex error on the word “Udate” Why would that be? CREATE TABLE Manufacture ( ManufactureID INTEGER CONSTRAINT ManfID PRIMARY KEY, ToyID INTEGER NOT NULL, CompanyName CHAR (50) NOT NULL, [...]
Answer Question
| February 16, 2010 11:00 AM
Access Datasheet, Access query, Microsoft Access, SQL, SQL Access, SQL Query
Still having trouble with IIF in Access 2007
If I type in the criteria block Is Not Null [Br _extended=”true” />then only those people who have a position assigned to them are listed and the position is listed. These are the people who get 25 points. What I need to do is to replace the position with “25″ in simple terms, if any [...]
Answer Question
| February 15, 2010 6:15 PM
Access 2007, Data base design, IIF, IIF function, IIF statement
If I type in the criteria block Is Not Null [Br _extended=”true” />then only those people who have a position assigned to them are listed and the position is listed. These are the people who get 25 points. What I need to do is to replace the position with “25″ in simple terms, if any [...]
Answer Question
| February 15, 2010 6:15 PM
Access 2007, Data base design, IIF, IIF function, IIF statement
MS Access 2007, IIF and Null expressions
Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometimes contains a value and but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25”. [...]
Answer Question
| May 9, 2013 1:25 PM
Access 2007, IIF, Microsoft Access, Null Expressions
Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometimes contains a value and but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25”. [...]
Answer Question
| May 9, 2013 1:25 PM
Access 2007, IIF, Microsoft Access, Null Expressions
How To Train For Help Desk Role?
Is there any software/on line training I can purchase to learn this role? My background is in IT operations ie AS400/Mainframe etc… I realise that I am back in the classic IT Catch 22 situation of no experience = no job interview.
Answer Question
| July 9, 2010 11:29 PM
Careers, Helpdesk training, IT careers, IT Help Desk, IT training
Is there any software/on line training I can purchase to learn this role? My background is in IT operations ie AS400/Mainframe etc… I realise that I am back in the classic IT Catch 22 situation of no experience = no job interview.
Answer Question
| July 9, 2010 11:29 PM
Careers, Helpdesk training, IT careers, IT Help Desk, IT training
Trouble with IFF MS Access 2007
Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometime contains a values but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25” I Believe [...]
Answer Question
| February 16, 2010 1:30 PM
Access 2007, IIF function, Microsoft Access
Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometime contains a values but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25” I Believe [...]
Answer Question
| February 16, 2010 1:30 PM
Access 2007, IIF function, Microsoft Access
Career Path
What is Career Path of a Software Engineer,Working in Software House or Industry,Which Job is Better?
Answer Question
| October 20, 2010 5:13 AM
Careers, Certifications, IT careers
What is Career Path of a Software Engineer,Working in Software House or Industry,Which Job is Better?
Answer Question
| October 20, 2010 5:13 AM
Careers, Certifications, IT careers
MS Access Networking
Which TCP port(s) can I use to monitor access database queries over the WAN?
Answer Question
| February 12, 2010 4:20 AM
Microsoft Access, TCP Ports, WAN
Which TCP port(s) can I use to monitor access database queries over the WAN?
Answer Question
| February 12, 2010 4:20 AM
Microsoft Access, TCP Ports, WAN
Wrkqry for join files
Hi, can you help me how to join the two files but the two fields are not the same length e.g. 1st field (left side) is 9 (ex. A005B2589 job#) and the 2nd field (right side) is 11 (ex. A005B258901… the last two digit 01 is for partial#), kindly advise if it’s possible? Thanks and regards…
Answer Question
| October 18, 2011 8:57 AM
JOIN statement, WRKQRY
Hi, can you help me how to join the two files but the two fields are not the same length e.g. 1st field (left side) is 9 (ex. A005B2589 job#) and the 2nd field (right side) is 11 (ex. A005B258901… the last two digit 01 is for partial#), kindly advise if it’s possible? Thanks and regards…
Answer Question
| October 18, 2011 8:57 AM
JOIN statement, WRKQRY
Link between Access & Crystal
How do I link between Database and Crystal report to make a report paper?
Answer Question
| February 10, 2010 3:42 AM
Crystal Reports, Microsoft Access
How do I link between Database and Crystal report to make a report paper?
Answer Question
| February 10, 2010 3:42 AM
Crystal Reports, Microsoft Access
in Access 2003, adding data in a table affect queries?
Hi, I am using Access 2003. I am working on a database that already exists. I want to add a name of a location in a field in some existing tables. Basically I want to add a name of a location to a field that is a drop down list of locations. There are queries [...]
Answer Question
| February 9, 2010 10:37 PM
Access 2003, Access Tables, Microsoft Access
Hi, I am using Access 2003. I am working on a database that already exists. I want to add a name of a location in a field in some existing tables. Basically I want to add a name of a location to a field that is a drop down list of locations. There are queries [...]
Answer Question
| February 9, 2010 10:37 PM
Access 2003, Access Tables, Microsoft Access
.nsf file error
While i am trying to open the replica folder in notes, it gives me a message “Database is corrupt – Cannot allocate Space”. I am using Lotus notes 7. Have tried nfixup,nupdall & ncompact. Did not help. Any other resolution that can be tried.
Answer Question
| May 1, 2012 3:36 PM
.NSF files, Database replication, Lotus 7.0.2
While i am trying to open the replica folder in notes, it gives me a message “Database is corrupt – Cannot allocate Space”. I am using Lotus notes 7. Have tried nfixup,nupdall & ncompact. Did not help. Any other resolution that can be tried.
Answer Question
| May 1, 2012 3:36 PM
.NSF files, Database replication, Lotus 7.0.2
