same records need to see only 1

[DaRTHY]

Hello

If you check my picture, some Records are similar and i need to filter them. (this is a query by the way.)

For example 3303933 these are 3 records, i want to see only one (Dates and other thing are not important.

I tried TOTAL option but could not find any thing there.

Hope so you can help me, because after this i ll finish my project.

 

[Isskint]

Hi DaRTHY

You need the DISTINCT keyword. So SELECT DISTINCT...... If the other fields are not important, take them out of the query.

 

[plog]

If dates and other things aren't important, don't bring them into the query. Then, make an aggregate query (click the Sigma/Summation symbol in the ribbon) and you will have the results you want.

 

[DaRTHY]

IT WORKS

Thanks both of you

I used Property Sheet Unique Values. And Show option for others removed. (they are still there. Only from show option removed)

 

[DaRTHY]

Hello Friends,

I have same Problem again. Last time i could find a solution because only 1 Field was enough to show and count to all Records.

Now i need again like "DISTINCT" or "Summation symbol" but i don't have only one Field to show at this time....

If i take to my Query only 1 field Project_NR :I am getting 1958 Records.
and i ll take on my Query 3 Fields and now im getting 13873Records.

I need max 1958 records thats mean...

I have a Date and im sorting as "Ascending" because i need oldest dates f0r every Project number.

"1 project number", "doesnt matter which number","oldest Date"

I am sending a pictures and you can see there. (i marked off Yellow, which one i need.)

how can i ignore the other Records ? every Project number shall show me oldest dates.

Thanks for your helps....

 

[plog]

You would build a subquery. Let's call it 'Sub1'. It would determine the earliest date (let's call it 'EarliestDate' for each Project_NR.

Then you would build another query. It would be based on your original table and Sub1. You would link them via Project_NR and EarliestDate to the date field. You would then show all records from your original table and that would give you the results you want.

 

[DaRTHY]

the question is how can i determine ? Normally i need this kind of code :

" if Project_nr is same
compare dates
take early one. "

i really dont know how can i write sql code like this...

 

[DaRTHY]

i guess i found my answer in forum.

http://www.access-programmers.co.uk/forums/showthread.php?t=214559

and this is someone wrote in this thread :

http://www.baldyweb.com/LastValue.htm

 

[jdraw]

Further to the advice given, I suggest you find and work through some tutorials that deal with queries. There are many free youtube videos dealing with 1 table and multi-table queries.
It isn't clear (to me anyway) if your issue is with :
- clearly identifying the issue involved,
- how to write a query (Access query grid)
- using vba or SQL
- experience with database concepts and retrieval techniques.

Use Google to identify some tutorials ( a couple of examples)
http://www.techonthenet.com/access/queries/
http://www.makeuseof.com/tag/quick-tutorial-queries-microsoft-access-2007/

Good luck.