Query goofed up!
- From: "cottage6" <cottage6@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 20 May 2005 06:08:02 -0700
I have a query that needs to get all the employee records that have not made
a cobra insurance payment within a specified month. Each employee should be
in the General Cobra db (primary) which is joined by ss# to the Payments db.
I'm trying to match the ss# in each database and then see if they made a pmt
in the month in question. My SQL isn't right and I don't have a lot of
experience with this. I'd really appreciate help with this. Thanks! Please
try not to laugh too much at this:
SELECT [General Cobra Information].[SocialSecurity#], [General Cobra
Information].[First Name], [General Cobra Information].[Last Name]
FROM [General Cobra Information] LEFT JOIN Payment ON [General Cobra
Information].[SocialSecurity#] = Payment.[SocialSecurity#]
WHERE (([Payment].[Month] = [What month?] AND (Payment.[SocialSecurity#]) Is
Null));
.
- Follow-Ups:
- Re: Query goofed up!
- From: John Spencer (MVP)
- Re: Query goofed up!
- From: Jeff Boyce
- Re: Query goofed up!
- Prev by Date: Assess: How to make a list in a query
- Next by Date: Re: Help with a query
- Previous by thread: Assess: How to make a list in a query
- Next by thread: Re: Query goofed up!
- Index(es):