On Fri, 12 Aug 2005 01:30:02 -0700, Ronny de Jong wrote:
>Dear all,
>
>I'd like to display the result of this query in percentage:
Hi Ronny,
SELECT SYS.Client_Version0, SYS.Client_Type0, count(*) as 'Count',
count(*) * 100.0 / (select count(*) from v_R_System) as 'Percent'
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
(untested)
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
.
RE: Query help ! ... - Total records counts in SYS.Client_Version0 ... As you are using 2 columns in your select query..."Ronny de Jong" wrote: ... > FROM v_R_System as SYS ... (microsoft.public.sqlserver.mseq)
Query help ! ... I'd like to display the result of this query in percentage: ... FROM v_R_System as SYS ...Prev by Date: ... (microsoft.public.sqlserver.mseq)
Re: database lookup ... the query on the subsequent page, and display the "drill down" data. ... The thing with PHP and MySQL is that you need the user to do an action ... I tried to state that I have the database designed and implemented but I ... (alt.php)
Re: DB Result Wizard Error ... Also noted that one folder, which contains no information can't be deleted, ... >> For instance Equipment Serial Number, Equipment Model Number, Cost Accounting ... >> to display the new equipment information. ... >> is in the table was added to the query.... (microsoft.public.frontpage.programming)
RE: Just starting to design a form (or is it a query?) ... A Form is used to display the data and allow ... A query can be the record source for a form. ... that match an ID in the Assessment table. ... Now, assuming this is the case, what you need is a form with a sub form.... (microsoft.public.access.gettingstarted)
