Question about Microsoft Windows XP Professional

1 Answer

To dispaly row without duplication

Hi !
Plz solve my problem,
there is a query table (query) in this tabel there sare so many rows that contain one rows more time like 5 time or etc.
now i want to retrive a row from it without retriving all rows but i want to retrive that duplirow one row so plz give me the access query that display the same rows one time.
thanks for help.

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 44 Answers

Mini-05,

Try something like this:
SELECT DISTINCTROW Serial.SerialNumber, Serial.ID
FROM Serial
WHERE (((Serial.ItemID)=[CurrentItem]) AND ((Serial.Sold)=False))
ORDER BY Serial.SerialNumber;

Good luck!

Posted on Aug 05, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

How to make a 7 row and a 7 coloum in a spreadsheet


Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007
  • Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.

  • Click on the "Insert" tab at the top of the document.

  • Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.

  • Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.

  • Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.

  • Hit the "OK" button at the bottom of the Create Table dialog box to create your table.

  • Thanks for choosing Fixya............ Sandeep

    Mar 18, 2011 | Computers & Internet

    3 Answers

    What is vlook up & what is hlook up?


    The VLOOKUP and HLOOKUP functions contain an argument called range_lookup that allows you to find an exact match to your lookup value without sorting the lookup table

    I have posted below link to know more .Please have a look..

    http://www.howtodothings.com/computers-internet/how-to-use-the-vlookup-and-hlookup-functions-in-microsoft-excel
    http://support.microsoft.com/kb/181213

    http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx

    http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel

    Please rate & vote if you like soution..

    Thanks
    Sandeep

    Mar 14, 2011 | Microsoft Excel for PC

    1 Answer

    Plz tell me Sir/Madam. what is Hlookup And give me example


    Hi Geetad11

    This is Horizontal lookup , used to look up value in a 2 dimensional table .It searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. The H in HLOOKUP stands for "Horizontal."


    Formulae Syntax

    HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)


    Lookup_value is the value to be found in the first row of the table. Lookup_value can be a value, a reference, or a text string.

    Table_array is a table of information in which data is looked up. Use a reference to a range or a range name.

    • The values in the first row of table_array can be text, numbers, or logical values.

    • If range_lookup is TRUE, the values in the first row of table_array must be placed in ascending order: ...-2, -1, 0, 1, 2,... , A-Z, FALSE, TRUE; otherwise, HLOOKUP may not give the correct value. If range_lookup is FALSE, table_array does not need to be sorted.

    • Uppercase and lowercase text are equivalent.

    • You can put values in ascending order, left to right, by selecting the values and then clicking Sort on the Data menu. Click Options, click Sort left to right, and then click OK. Under Sort by, click the row in the list, and then click Ascending.

    Row_index_num is the row number in table_array from which the matching value will be returned. A row_index_num of 1 returns the first row value in table_array, a row_index_num of 2 returns the second row value in table_array, and so on. If row_index_num is less than 1, HLOOKUP returns the #VALUE! error value; if row_index_num is greater than the number of rows on table_array, HLOOKUP returns the #REF! error value.

    Range_lookup is a logical value that specifies whether you want HLOOKUP to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned. If FALSE, HLOOKUP will find an exact match. If one is not found, the error value #N/A is returned.

    Remarks

    • If HLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the largest value that is less than lookup_value.
    • If lookup_value is smaller than the smallest value in the first row of table_array, HLOOKUP returns the #N/A error value.

    Example
    The example may be easier to understand if you copy it to a blank worksheet.ramsoft.jpg

    Oct 06, 2010 | Microsoft Excel for PC

    2 Answers

    Access database was copied now no tables in dropdown list


    Your version of Access may require slightly different menus and clicks than mine, but the procedure is straightforward and should be very similar to what you will need to do. Read the whole post first!

    Make sure you have permission to modify the database, then go to the form (I assume the drop-down table is in a form) and go to design view.

    In design view, click once on the dropdown box you are having a problem with, and a properties screen with several tabs should pop up; click on the data tab, and look at 'data source'. In the list look for 'row source type' to see if the source of your data is a) a table or a query, b) a value list or c) a field list. Most dropdown boxes use either a value list or data from another table or a query (based on a table).

    Check the source of data by going down to the next line in the list titled 'Row Source' (this is the list on the data tab that popped up when you clicked on the dropdown box in design view).

    If the source is a table/query type you should see some code in the Row Source box like "SELECT....". Without changing anything, click once immediately to the right of the box, and whatever source the rows are coming from should pop up--if a query, for instance, it will pop up the underlying query in design view.

    You should be able to troubleshoot the underlying query to see why no data is given in the dropdown box.

    Another point where underlying query or table is used: If the table was based on a query that pulls data from the records in the current database, the drop down list will be blank until new records are added so the query has something to list.

    And if the source is a 'value list', the values should be included in the row source box below, separated by semicolons. If not you simply need to add them in.

    If your source is a field list, go back to whomever copied the database and tell them you need help with the copy they gave you...

    Sep 13, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

    1 Answer

    HIGHLIGHT THE CURRENT ROW


    Hi Rakesh,
    in MS Access 2003/2007, the first record is always highlighted in table as well form's text controls when they connected to a database. In a query cursor is always at last record.

    In flex-grid control you can set its properties to get cursor on a particular records.

    I think your problem is solved.

    Please contact if not.

    Zulfikar Ali

    Mar 07, 2009 | Microsoft Access 2003 for PC

    1 Answer

    Linking tables in Oracle


    While I'm not saying it's not possible, it's not something Oracle (Or any relational database) is designed to support, so don't be surprised if this isn't possible or extremely difficult.

    Relational databases support predictable relationships. IE: Table 1 relates to Table 2 in a given way.

    Relational databases do not support varied relationships depending on the data in each row. The query engines simply can not join data this way.

    If you provide me more details about your data, I might be able to propose a table structure that doesn't require a different table for each row of data in ROOT.

    Feb 12, 2009 | Microsoft Computers & Internet

    1 Answer

    HLOOKUP IN MS EXCEL


    lookup value = value searched

    table array = database

    topmost row of lookup array must contain the data IDs and all IDs must be sorted in ascending order.

    row index number = row number containing data to be shown; first row = 1

    hlookup(x,tablearray,y) will look for x on the first row of the lookup table and return the value in the cell on the yth row

    if formula cannot file exact x, it will look for the value closest to. but not greater than x

    Nov 13, 2008 | Computers & Internet

    5 Answers

    Formula required


    at first select the 1st page data and select data-subtotal from the upper menu list.
    then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

    If not solved pls get me that data as to reference.

    thanks

    Dec 04, 2007 | Microsoft Excel for PC

    2 Answers

    Budgets in excel


    Dear Madiha35,

     

    I would recommend the use of the Table Function in Excel.

     

    Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.

     

    Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.

     

    Excel 2007 had a budget format workbook

    New workbook, Select Budgets in the last hand navigation, Select Personal Budget.

     

    Step 1:  Enter your data into the worksheet.

     

    Step 2:  Create Table

                 Highlight the relevant data

                 On the insert tab, click on Table

                 

    Step 3:  Verify Table range is correct, Click OK

     

    Step 4:  Select the cell you where you wish to Sum Data.

             Click on Autosum.

     

    Step 5:  To Insert new data

             Click on the sum row in the table, (Not the entire worksheet row)

             Right click, Insert, Insert Table rows from above

     

    Step 6:  Enter new data in row

     

    Step 7:  Data is automatically calculated in formula.

    Oct 22, 2007 | Computers & Internet

    Not finding what you are looking for?
    Microsoft Windows XP Professional Logo

    Related Topics:

    237 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Microsoft Computers & Internet Experts

    micky dee

    Level 3 Expert

    2644 Answers

    Piyal Perera
    Piyal Perera

    Level 3 Expert

    528 Answers

    Les Dickinson
    Les Dickinson

    Level 3 Expert

    18384 Answers

    Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

    Answer questions

    Manuals & User Guides

    Loading...