Repeating lines in my query

[viadisky]

Hi,

How can I reduce repeating lines into a single line in my query?

Vlan2 172.18.226.251 255.255.255.240
Vlan2 172.18.226.251 255.255.255.240
Vlan2 172.18.226.251 255.255.255.240
Vlan2 172.18.226.251 255.255.255.240
Vlan2 172.18.226.251 255.255.255.240
Vlan2 172.18.226.251 255.255.255.240
Vlan2 172.18.226.251 255.255.255.240
Vlan2 172.18.226.251 255.255.255.240

I just want to have 1 line representing all these lines.

Many thanks

 

[Spenney]

Try adding a 'Group By' clause. The sigma icon on the toolbar.

 

[SkipVought]

Hi,

How about Select Distinct ...

Skip,

_{[red]Be Advised![/red] Dyslexic poets...
write inverse!}

 

[viadisky]

Hi Spenney/Skip,

I only used Access since last week, I am still trying to find toolbars and icons really ... can you provide additional details please ...

I really appreciate your help.

Cheers!

 

[lespaul]

switch to the SQL view of your query and add DISTINCT after the SELECT.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[PHV]

In the properties sheet of the query set Distinct values to true.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886