Search results for query: *

Okay, so I would have to use the NZ() in the 3rd query as oppossed to either of the other two since I am using the Recruit Points as part of the Primary Points Exp?

Okay, Problem fixed... I just need to know one more thing. Where do you put an ISNull or NZ expression in one of the (now) three queries so that the end report has "0" instead of " "? First: SELECT [Member's Database].[Recruiter], Count([Member's Database].[Recruiter]) AS...

Not quite. Each record in the Member's Database has SOMETHING listed as [Recruiter]. The problem is that not every Member has recruited another player. The first query is merely counting the number of times a given Member name appears as [Recruiter]. But if a member's name does not appear in...

Actually, I do know for sure that every record does have a value for 'Status'. The problem is the 'Recruiter' field. I have one Query that counts the number of times a member's name appears in that column: *snip* SELECT [Member's Database].[Recruiter], Count([Member's Database].[Recruiter])...

Okay, the new linking created another problem... I did start a new thread just in case someone else might see it as well. When I link [Recruit Points] to [Member's Database] by the firld 'Recruiter' it will list all 81 records (criteria status = 'A' or 'R', 81 is thr correct number of...

I use several complicated Queries in my database. Some of my queries may not display all avail records that meet a given criteria because of "incomeplete" or missing data. Is there a way to force these records to show up in a query anyway? i.e. I have Status, Member Name and...

Oh man, I feel less than intelligent on this one. I "accendentally" change the link from Recruit Points to Member's Database From 'recruiter to recruiter' to 'Recruit Points.Recruit Points to Member's Database.Member Name' and the things works fine now.. ARG! Thank you for your help...

Okay, that was something I did not try was rebuilding it. I added the Recruit Points AFTER everything else... So, let's see where that get's me. Thank you!

There are two tables: Member's Database and Member's Points Joined by Member's Name. There is one record in both tables for each name. Is this what you are asking?

Yes, my mistake... I have it written down as Recruiting, but the decision was made to change the name to make it more descriptive... Recruiting as I have used it *IS* "Recruit Points"

SQL for "Recruting" SELECT [Member's Database].Recruiter, Count([Member's Database].Recruiter) AS [Recruit Points] FROM [Member's Database] GROUP BY [Member's Database].Recruiter; SQL for "Membership" SELECT [Member's Database].Status, [Rank Order].[Rank Order], [Member's...

I have a query that is counting the number of times a member's name appears as 'Recruiter' called "Recruiting". I then use that query inside another query ("Membership") that my final membership report is based off of. When I run "Recruiting" it works flawlessly...

Believe it or not this is something I have just never needed to do. A database was set up with two seperate tables relating on a Name field. How does one merge the two tables together without loss of data?

Yes, Typo... :) Sorry about that. What I need to do quite simply is this: <21 = 0 value =21 but <31 = 1 =31 but <41 = 2 =41 but <51 = 3 =51 but <71 = 4 =>71 = 5 Thanks for your help.

I have a field that I want to calulate a number of points off of based on the value. Basicly if the starting value is between 21 and 31 assign a code of 1, if between 31 and 41 assign a value of 2, etc... However, when I write the IF statement in the query design view I get an &quot;undefined...