Question about Microsoft Office Professional 2007 Full Version for PC

1 Answer

When i run query in access it gives duplicates of the same data

If the result should be only one record it gives number of records although the record is same

Posted by on

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Press the σ (Totals) button and group the query by the necessary fields.
Or eliminate some tables from the query so there isn't a one to many relationship.

Posted on May 26, 2009

Ad

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

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

3 Answers

How i can recover deleted files?


Try to insert the digital recorder to your computer and run a data recovery program on it. If you're a Macintosh user, please also give this data recovery app a go. Recover Data from Mac Hard Drive and Storage Device

Jan 03, 2016 | Sony ICD-SX46 Handheld Digital Transcriber...

1 Answer

How to copy a rangewithout scrolling in Microsoft Access step-by-step. Then how to paste the copied information to Excel 2010.


you said time was an issue !

Have a look at this software tool for access database comparison
http://www.fmsinc.com/products/detective/index.html

It costs money but if time is an issue it might be worth buying to get you out of a jam !

Feb 26, 2017 | Microsoft Computers & Internet

1 Answer

How do you add a RANK number to a Microsoft Access query?


While there is no RANK command in Access, you may still do it using either VBA code or two queries concatenated. Lets touch the queries method since based on your question you seem to prefer the straight query method.

You have to modify the query to add a custom field based on a field containing a value that can be evaluated using either the GREATER THAN (>) or the LESS THAN (
Usually you would need to use two subsequent queries defining custom fields that receive results from a subquery. How to put them together depends on the specific rank you need to create. For a full example, please refer to:

http://support.microsoft.com/kb/120608

Mar 09, 2011 | Computers & Internet

1 Answer

Displays 'data disk' when i try to record live audio or duplicate a CD


Hi,
it sounds to me like you are using a blank CDR/CDRW that you would use in a computer rather than a CDR Audio. The two types of discs are different and although you can use either in a PC to record on, on these "Home Burners", they will only record on the other type.
Try it .....

Jan 08, 2011 | Sony RCD-W500C 5-Disc CD Recorder

1 Answer

PHP/SQL Problem


have you read the dataset in (i.e $row)?
you would require some sort of select statement to read the data frm sql into a dataset before yopu can read and display each record in the dataset.

i gather you may be new to sql statements. the bottom commect $query.... is reading the dataset into $query, the one you have issues with needs code that reads a record into $row

Jan 25, 2010 | The PHP Group PHP

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

Microsoft Access query in VB


first you need to create a record set to do this, after creating a record set RS1. please follow the code below:
Update the code as per your requirement.
Rs1.Open "Select * from table_name where UserName = '" & UName & "'", Cn1, adOpenDynamic, adLockOptimistic

Mar 14, 2009 | Microsoft Visual Basic 6.0 for PC

2 Answers

Duplicacy in excel sheet


Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.
Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data
Select the entire data and do an auto filter
In column F filter the data by Duplicate and delete all these rows
What remains should be unique data

Dec 19, 2007 | Computers & Internet

4 Answers

Lexicon lambda


push the monitor button to go mono instead of stereo.

Oct 11, 2007 | Lexicon Lambda Usb Desktop Recording...

4 Answers

Running SQL queries on Excel


Another way to do it is to use the SQL Drill freeware Excel addin (http://www.sqldrill.com)
hth

Aug 14, 2007 | Microsoft Office 2003 Basic Edition...

Not finding what you are looking for?
Microsoft Office Professional 2007 Full Version for PC Logo

Related Topics:

69 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2768 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18394 Answers

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

Answer questions

Manuals & User Guides

Loading...