Search results for query: *

I have a list of names in a table. In a report they display one below the other. Can I make them appear one after the other instead: name, name, name, name, name, name, name, name, name, name, name, name, name, name, name, name, name, name, name, name, name, name, etc. Please help

Hey everyone I need a macro to start the "Merge It with MS Word" wizard using my table "tblTeam" Can this be done? or anything similar Thanks in advance

Hey everyone I need a macro to start the "Merge It with MS Word" wizard using my table "tblTeam" Can this be done? Thanks in advance

I have a RIGHT JOIN on a query showing each of the names of teams. To the right of this there is a sum for each team of the amount they owe, and to the right of this is the standard fee that each team must pay on top of this. (see Query headings below): TeamID MoneyOwed StandardFee I've...

Don't worry about it, I solved it. Have a good evening

sorry, forget that. Solved it. just set it to COUNT instead have a good evening

I've got RIGHT JOIN, and rather than it displaying a blank field when there is nothing to find, I need it to display a "0". Kind of like a default value. below is the SQL used for my query. SELECT [tblTeam].[TeamID], [qryLeagueWon].[Won] AS Won FROM qryLeagueWon RIGHT JOIN tblTeam ON...

This is the SQL in the query I currently use. The problem with this one is that the TeamName disappears if there is no value for the Won field. SELECT qryLeagueWon.TeamName AS Expr1, Sum(qryLeagueWon.Won) AS Won FROM qryLeagueWon GROUP BY qryLeagueWon.TeamName;

cheers for that website, it's helping loads

alright, I'm a little confused, but that's because I think you're using SQL, which i'm not too familiar with, but I know where to insert it in a query. I've got a "tblTeam" table where one of the fields is called "TeamName" and is thus a list of all the names. I then have a...

I have a table holding a list of names. There are currently 4 names, and they are each held a number of times. (e.g. bob, jim, joe, paul, paul, joe, jim, jim, jim) I need a query to display each name; with the number of times it appears in the table next to it (e.g. Bob 1 Jim 4 Joe 2...

cheers rudy, I appreciate the help, but for the benefit of some less experienced users who don't have a scooby about what you just said, could you use Lamens terms. much appreciated Bob Munkhouse

[reply to rudy]: ok, that's fine I have another query holding all the names...this is how we know what all the all the names are... can my problem now be solved?? and how BObMunkhouse

I have a table holding a list of names. There are currently 4 names, and they are each held a number of times. (e.g. bob, jim, joe, paul, paul, joe, jim, jim, jim) I need a query to display each name, with the number of times it appears in the table next to it (e.g. BOb 1 Jim 4 Joe 2...