I have a database of football players names, their names appear more than once if the table, i.e a players name might be there 10 times, the initial name is just a short version for ease, i then have a second field with their full name, but this only appears once, I want to do a sum of all their goals scored but display their full name that appears once and not their short name that appears 10 times or more.
SELECT Players.PlayerN ame, Sum(Players.Goa ls) AS SumOfGoals
FROM Players
WHERE (((Players.Goal s)>0) AND ((Players.Leagu eCup)="league") )
GROUP BY Players.PlayerN ame, Players.Team
HAVING (((Players.Team )="first"));
I use this at the moment, but this diplays their short name, their full name is DisplayName
Can anyone help????
3 1232 PEB 1,418
Recognized Expert Top Contributor
Where is stored their full name?
In separate table or in the same table?
If in separate table do a join with this table in your query!
JOIN by Short name and invoke your full name!
:)
The full name is stored in the same table, but the full name only appears in one of the entries.
PEB 1,418
Recognized Expert Top Contributor
Hi,
So the structure of your table isn't well done! It should be great if you have a table with players where you have short name and full name and table with scores... Where you have the sort name and the score for each match...
In this case it will be very easy to link the short names results to your full name...
In your case there is always possibility to do it...
So you need to save a query with 2 columns short and full name...
It should be like:
Select ShortName, FullName FROM Soccers GROUP BY ShortName, FullName WHERE len(ShortName)> 0 AND Len(FullName)>0 ;
Save this query as soccers_names, but remember! You should change the fields and the table with your own!
When it is done, add this query to the query that you have done, link the 2 views by ShortName and invoke FullName from soccers_names and it should work!
:)
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Gregory |
last post by:
Hello,
I've managed to build two web pages, one that can display images with
associated text data in a table, and one that can resize and display images
without the text. I'd like to resize the images as I go, without writing
them to disk on the server. Do I need to prepare all of the resized images
before I display the data from the select (which is put into an array by
php). How can I display a resized image in a table, without writing...
|
by: Waguih Boctor |
last post by:
Hi,
I have a number of ASP pages where some JPGs and GIFs are displaying in the
browser and some are not. I have included an excerpt from the HTML below. In
this example, the gif file at the bottom of the example is displaying (I
have others that don't), while the jpg file at the top isn't. Both files are
in the same folder (visible bith physical in WE and virtual in CM) as the
asp file itself. WHen not displaying, it displays instead...
|
by: Les Juby |
last post by:
Can someone please help with a suggestion as to how I can keep the
formatting (carriage returns) that the user enters into a memo field
and then display that later.
I figured I might be able to use:
'replace carriage returns with BRs
comment=Replace(comment, chr(13), "<br>")
but obviously net.!
The <pre> tag doesn't sem to help either as the embedded return is
|
by: MrL8Knight |
last post by:
Hello,
I am trying to build a simple php form based shopping cart using a cookie with arrays. I need to use 1 cookie because each order will have over 20 items. With that said, I realize I need to serialize the data to put the array into the cookie. That part of my code is working just fine and displaying fine. The problem I’m having is when I try to unserialize and display; the data does not appear. If I remove my unserialize command line (see...
|
by: pe3no |
last post by:
Hi,
First of all - sorry for my silly question and the horribly strange way
of using XML by me - I'm an XML n00b :) :) :)
I'm trying to write a short guide - putting everything in one file.xml
<guide_name>
<element name = "1-prerequisites">
1.1. download iso file
| |
by: paragguptaiiita |
last post by:
I have one problem regarding displaying text from XML file.
I have a XSL variable named $p = (0 0 0) (0.82 0 0) (1.63 -0.01 0) (2.63 -0.01 0) (3.63 -0.01 0) (4.63 -0.01 0) (5.63 -0.02 0) (6.63 -0.02 0) (7.63 -0.02 0) (8.6 -0.02 0)
This line contains X,Y,Z coordinates of 10 points.
for displaying each coordinate in a separate line.Like this....
(0 0 0)
(0.82 0 0)
(1.63 -0.01 0)
(2.63 -0.01 0)
(3.63 -0.01 0)
(4.63 -0.01 0)
|
by: paragguptaiiita |
last post by:
I have one problem regarding displaying text from XML file.
I have a XSL variable named $p = (0 0 0) (0.82 0 0) (1.63 -0.01 0) (2.63 -0.01 0) (3.63 -0.01 0) (4.63 -0.01 0) (5.63 -0.02 0) (6.63 -0.02 0) (7.63 -0.02 0) (8.6 -0.02 0)
This line contains X,Y,Z coordinates of 10 points.
for displaying each coordinate in a separate line.Like this....
(0 0 0)
(0.82 0 0)
(1.63 -0.01 0)
(2.63 -0.01 0)
(3.63 -0.01 0)
(4.63 -0.01 0)
|
by: dba |
last post by:
Have been displaying data from database using html for some time but
just recently trying to display data back to "form". Can't find answer.
<form method="post" action="<?php echo $PHP_SELF;?>">
First Name:<input type="text" size="12" maxlength="12" name="Fname"><br >
Last Name:<input type="text" size="12" maxlength="36" name="Lname"><br />
Gender:<br />
Male:<input type="radio" value="Male" name="gender"><br />
Female:<input...
|
by: littlealex |
last post by:
IE6 not displaying text correctly - IE 7 & Firefox 3 are fine! Need some help with this as fairly new to CSS!
In IE6 the text for the following page doesn't display properly - rather than being aligned to the top, along with the slideshow and link buttons, you have to scroll down to see the text - how can I make IE6 display correctly?
http://geekarama.co.uk/new_home.html
here is the code for new_home.html and following that the CSS...
|
by: RichB |
last post by:
I am trying to get to grips with the asp.net ajaxcontrol toolkit, and am
trying to add a tabbed control to the page.
I have no problems within the aspx file, and can dynamically manipulate a
tabcontainer which has 1 panel already, however I want to try create the
TabPanels dynamically. I followed the advice here:
http://www.asp.net/learn/ajax-videos/video-156.aspx (3rd comment - Joe
Stagner)
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |