• 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)...

    Bijendersverma5 pointsBadges:
  • Calculation Combining Fields, Not Adding

    Hello, This should be really simple. I have 3 fields that calculate correctly on a form and insert the calcuation into a table. (I know, NEVER store a calcuated value, but I have a reason for doing it.) Now I'm trying to add those 3 fields and am getting an incorrect sum. Here is my string:...

    Jmclemor5 pointsBadges:
  • 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 me. i am...

    SrimanBenivolent5 pointsBadges:
  • 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.

    Nagasuri5 pointsBadges:
  • 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 yes or no. Now...

    Mutaz5 pointsBadges:
  • 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.

    Triel5 pointsBadges:
  • 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...

    Jobseeker1435 pointsBadges:
  • 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.

    OracleATE190 pointsBadges:
  • 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

    Rmaylath25 pointsBadges:
  • 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...

    VB RD45 pointsBadges:
  • Database connectivity with c++

    How to connect backend(database to C++(front end) ?

    Mkaaa15 pointsBadges:
  • 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??

    Jem5 pointsBadges:
  • 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()-...

    Nichalos825 pointsBadges:
  • 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?

    Romanov385 pointsBadges:
  • DB Web interface

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

    Jaco65 pointsBadges:
  • Date Picker

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

    Shazzie70 pointsBadges:
  • Restricting the user to insert next record

    Hai all, I have a subform which is in datasheetview mode , I have to validate the subform field s in such a way that if one of the fields is empty i will popup a msg like 'must enter a value ' then the focus should goto that field and restrict the user to insert next record till the user provides...

    Giridharrajup5 pointsBadges:
  • 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.

    Red5 pointsBadges:
  • 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...

    Bmoquin15 pointsBadges:
  • auto send e-mail

    How does one auto send e-mail from access

    Mabaxter5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following