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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.