• 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:
  • 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:
  • Setting up my own private dropbox system

    I'm trying to setup my own dropbox system (for private use). I know what I want, but I don't know how I can make it work. I'm 'comfortable' with some technical things, but I'm no tech-genius, so setting up linux servers etc. is not something I can do :) Would be lovely if you could help me out with...

    Janbracke10 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.

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

Following