join tables with nested select count and group by
hi i am having three tables : state, agencydetail, parentdetaills i am running following queries but i am getting wrong result plz help me out where is the problem select state.state,count(ag.agencycode) as registag,count(ff.agencycode) as reportag,count(inp.regno) as incpwait,count(interp.regno) as intercpwait from state left outer join (select distinct agencycode,state from agencydetail) ag on state.state=ag.state left outer join [...]

Answer Question   |  July 29, 2008  6:28 AM
Database programming, JOIN statement, SELECT statement

Access 2003 – adding values to a specific record via a query
i have a situation where i have a table whose fields are : -Date reference: is a number which repredents a date in the Date Table (this way it is easier to manupilate dates) -value of payment: the monetary value of the payment that has to be paid at that date -Paid: here i enter [...]

Answer Question   |  July 24, 2008  11:45 AM
Access 2003, Database programming, Microsoft Access

Informatica MAP creation to RESTART
I have to develop maps which execute extracting and loading data. If, because of any reasons MAP failed with any errors have to fix and restart the same MAP, this time it has to start processing data where it got failed. Please let me know how could I develop map satisfying in both situations.

Answer Question   |  July 24, 2008  11:41 AM
Data mining/analysis, Database programming, Informatica

Error In SQL SERVER DataBase
am trying to insert four varchar(50) values in a table which is with a primarykey column id_number. i didnt check : “True” to the null field . so it should not allow null values in table. but while am trying . it allows null values. including primary key column. how is possible ? pls help [...]

Answer Question   |  July 28, 2008  9:41 AM
Database programming, NULL values, Primary keys, SQL Server errors, VARCHAR, Visual Studio, Visual Studio 2008

Report Question-Is it possible to get a “new user” report when the only date is used also for date they used services?
Is it possible to get a “new user” report when the only date is used also for date they used services? The only fields in the table are Student ID, First Name, Last Name, Date of service and hours used.

Answer Question   |  July 22, 2008  7:49 PM
Access reports, Database programming, Database reporting, Microsoft Access

How to access and use subform data/calculations
Access 2007 Database; Employee Info; Form:Sick Days Docking/Pay. I created a form with a subform that keeps track of Employee sick days. It transfers totals from the subform onto the main form…Then the main form does a couple calculations on those amounts…But I need to access that information in a report for each employee. Reports [...]

Answer Question   |  July 29, 2008  1:23 PM
Access 2007, Calculations, Database programming, Form, Microsoft Access, Parameters, Reports, Subform, Variable fields

Storing values into a 2-Dimensional Array
Hello, Here I’m directly passing the crystal reports parameters through the code, and generating the report but for some obvious reason, I want the records to be stored first of all into a 2-dimensional array and from there writing it back onto Crystal reports. Note : The reason why I’m looking for 2-Dimensional array is [...]

Answer Question   |  July 17, 2008  7:14 PM
2D arrays, Arrays, Crystal Reports, Database programming, Microsoft Access

How to deploy database application built on VB 6 and Oracle?
I am developing an application with VB 6 as front end and Oracle 8i as back end. I need to run my application in other systems also, so I need to export the table structures of my application to other systems. How can I do this? Thank you.

Answer Question   |  July 16, 2008  3:51 PM
Application deployment, Database programming, Oracle 8i, VB

open a file in access by clicking button
I have several directory paths in a list box and I want to highlight one and double click on it and have it open the file

Answer Question   |  July 9, 2008  5:05 PM
Database programming, DropDownList, Microsoft Access

Create a PL/SQL block that will insert new records into the StoreRoom_info table. The PL/SQL block must use substitution variables to prompt the user
Create a PL/SQL block that will insert new records into the StoreRoom_info table. The PL/SQL block must use substitution variables to prompt the user information. Check that the Region_id is between the values 1,2,3,4 or 5. If not found, the block must display a user friendly message notifying the user that an invalid Region_id is [...]

Answer Question   |  July 8, 2008  7:04 AM
Database programming, PL/SQL

Database connectivity with c++
How to connect backend(database to C++(front end) ?

Answer Question   |  June 26, 2008  4:25 AM
C++, Database connectivity, Database programming

storing multiple fields iin jsp into a single column in th table
i have one text filed and a select field.I have to concatenate both of them and store into a single column in the table. how do i achieve this??

Answer Question   |  June 26, 2008  9:19 AM
Concatenate, Database programming, JavaServer Pages, JSP, Web development

Report -Conditional Format with multiple conditions: Access 2007
I am trying to generate a report that will change the font to different color if of a date field but the total number of days will change if another field = ?. So basically if [TYPE] = CHILD then DATE()-30= (red font), and DATE()-31 BETWEEN DATE()- 60= (yellow font) and DATE()-61 BETWEEN DATE()- 90=greenfont) [...]

Answer Question   |  June 24, 2008  10:39 AM
Access, Access reports, Conditional formatting, Conditional statements, Database, Database programming, Microsoft Access

DB Web interface
What would be the easiest language to use/learn if I want to create a web interface for my Access DB?

Answer Question   |  June 6, 2008  7:26 AM
Database frontend, Database programming, Microsoft Access

Date Picker
Can I create a Date Picker (enabling users to look up a date from a calendar) in Access 2003 forms?

Answer Question   |  June 5, 2008  2:11 PM
Calendar control, Database programming, Date Picker, Microsoft Access

Numeric Field to be left aligned
I have declared a numeric field with lenth 15,2, the same to be displayed left aligned. By default it is displaying right aligned.

Answer Question   |  May 28, 2008  12:36 PM
Database programming

auto send e-mail
How does one auto send e-mail from access

Answer Question   |  May 22, 2008  1:59 PM
Database programming, Microsoft Access

Updating Tables
Hello, I am trying to create a “yes/no” field, that automatically updates when the conditions have been met. Presently, I have two tables that have been created and have a relationship between them. In the first table, is the “master” table. In the “master” table, I have a field called “All forms received?” which is [...]

Answer Question   |  May 22, 2008  1:30 PM
Database programming

replace field with count variable in foxpro
Hello, in Foxpro 6, I need to replace a field with the count from a memory variable when an invoice # is the same. The database lists the detailed line items of the invoice and the invoice # next to them. So, if invoice 56 had two items, I would need 1 in the count [...]

Answer Question   |  May 21, 2008  4:49 PM
Database programming, FoxPro, SQL, VB, Visual Basic

Aggregate data
Can I manipulate aggregate tables at the census tract level? In essence, could I create dummy variables, such as: white, black, hipanic, other for 100 census tracts? Or is this only possible with individual level data?

Answer Question   |  June 14, 2008  5:42 AM
Census Tract data, Database, Database programming