• Access 2003 Query

    I have a table (tblRents)with the following fields: RentID, LeaseID, StartDate, EndDate, RentalRate, TenantID and LessorID. For each lease entered, there could be several rent rates, each entered seperately with it's own RentID. I am trying to write a query that will give me each rent rate for the...

    kgonzales20 pointsBadges:
  • how to display 10records in the browser again when we press the next button it will display 10 recors

    I am creating a form with three fields eno,name,salary and search button. I may or may not enter the values to the text fields and then press the search button. Here based on the values the query will generate and execute now the 10 records are display if may available otherwise it will display...

    suneelkumar15 pointsBadges:
  • Date format in table

    I record dates of birth and death from headstones. Often I only know the year, or sometimes the month and year. How can a create a table field to accept the info I have and not require a full date (month, day, year). I also would like to have a DateDiff field that will show the age at death from...

    LostSpring5 pointsBadges:
  • Microsoft Access change

    I'm trying to add fields to a table that says it is read-only. I don't want that,  how do I turn it off?

    PG755 pointsBadges:
  • Access

    How do I change the selected columns to be required pieces of information?

    gooman5 pointsBadges:
  • Access field set to Scale =2

    How do I set a field Scale = 2?

    jcurry6510 pointsBadges:
  • SQL Group by Query with aggregate function as well as detail information

    Given a simple table with historical info about Hotelroom occupancies such as name of the guest, date in, type of room, number of nights, ... I want to make a query resulting in 1 output record that shows the highest number of nights someone has ever stayed in the hotel, as well as the...

    idontknowthis20 pointsBadges:
  • Problem with relating multiple tables

    access 2010 i'm not getting a good answer on my question on this form, i place the link here so i don't need to explane it againLink to forum

    Kwantakosta20 pointsBadges:
  • How to reduce the time taken to select the records from huge keyed physical file having 180 Million records

    Hi All, I have a report program which uses the OPNQRYF to select the records to generate a report based on user selection in display screen, but it is taking lot of time (20 to 30 minuates) to select the records and write write into output file. I am accessing keyed logical file based on physical...

    Mohan K695 pointsBadges:
  • Extend char length

    How do I extend char length in memo field?

    flattop10 pointsBadges:
  • How to make one column in a row longer than the others? (MS Word Tables)

    I have five columns in a row, I need to make one [the last] column longer than the rest. How can I make one column in a row longer than the others? Here is a pic to explain what I need to do (I used a photo editor): http://imageshack.us/photo/my-images/831/fixedtable.png/ This didn't work:...

    spamram20 pointsBadges:
  • Trigger

    What is the use of the trigger?

    swamy00725 pointsBadges:
  • Removing Duplicates

    I have 2 access tables. One has doctors and membership totals, the other has doctors and their addresses. When I join both in an inner join, the membership totals duplicate because of the doctors multiple addresses. Is there a way to have the membership total appear only once?

    Dash145 pointsBadges:
  • Database engine

    What are the databases other than Oracle which can be efficiently used with SAP?

    SINGHA15 pointsBadges:
  • File lock on DB2 AS/400

    How do I make a file lock on a DB2 file before accessing it, to ensure that is is not updated while I'm acccessing it ?

    train0125 pointsBadges:
  • STAR JOIN command in SPSS

    Does anyone know what the STAR JOIN command is doing in SPSS version 21? It is the new MERGE files command and I am having trouble with it. When a case from the active data set contains a value that is not in the keyed data set it just stops at that case and will not finish the command. With MATCH...

    IRspecialist20 pointsBadges:
  • word doc into smn for SAMSUNG Galaxy II

    How can I transfere a word.doc into smn(nmf/ or dif) in order to copy it on to my mobile phone

    carvoeiro5 pointsBadges:
  • Problem to storing records at SAP DB from MySQL

    I'm using JCO for connecting SAP through jsp-Servlet. I want to store all MySQL Records to SAP DB. What will I Do?

    Mavric10 pointsBadges:
  • SQL selecting multiple rows from same column based on different column values

    I have am joining a table (object_restrictions) that has three columns: (object_type), (object_restriction_ID) and (object_restriction). I would like to join the table on (object_restriction_id) but select multiple rows based on the value in the column (object_type) and have them listed as separate...

    edsonk4510 pointsBadges:
  • Access 2007 Sql Query

    Hi Team (Again).. further to an original post I am trying to get 2 further fields added to my Query / Report. BoxCount & AverageWeight Here is the existing query. SELECT Pickerid, Pickername, ROUND(SUM(totalweight), 2) AS PickersTotalWeight, SUM(totalweight)/ROUND(SUM(pickerhours)) AS...

    witsendestate225 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