Query help !

Dear all,

I'd like to display the result of this query in percentage:

SELECT SYS.Client_Version0, SYS.Client_Type0, count(*) as 'Count'
FROM v_R_System as SYS
WHERE SYS.Client0=1
group by SYS.Client_Version0, SYS.Client_Type0
order by SYS.Client_Version0, SYS.Client_Type0

Any idea's how,

I appreciate your help....
Ronny
.

Relevant Pages

  • Two queries
    ... the Allocated table) I want it to display the product quantity from the ... How do I set up the query to do this? ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Populate a List Box to select a record
    ... I use the same form to display different sets of records from a query that ... I limit or filter for different subsets by using the ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • Combo box requery; update underlying table
    ... The display is ... but the value is not retained in the underlying table. ... The form is based on a query. ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: Creatinig a database to update in alphabetical order
    ... Use a query with the ... appropriate ORDER BY clause to display the data, ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)
  • pivot table not running correctly..
    ... i have pivots table in different Projects which were running correctly, ... suddenly all of them stoped running correctly and display this message ... "The query could not be processed: ... Prev by Date: ...
    (microsoft.public.access.forms)