Thank you...

Ninja's_RGR'us, you are right... I have a trigger, I didn't realize that it was having the problem.

Thanks Dugi, your last submission is where I started.

I appreciate it....

Wayne, Thank you for your persistence and patience.

Looking good... Martha and David appear on target. Joe has 116 days in August and 85 in September. I wish I understood this better.

Thanks for your help.

Wayne, Chris and Ron,

The database is from a third party and I'm struggling to make it work. I will take your suggestions and normalize so I can use the...

I think this is getting close Ron.

This is for an organization that helps people in therapy/recovery. When they start the program they're in Building A, then B, then C....

In the previous post I started testing using three tables and a query.

This is the result of the query:

JohnSmithKaganSeptember52

JohnSmithWaylonNovember18

JohnSmithWinthrupNovember2

MaryJonesWinthurpNovember20

Where Kagan is building A, Waylong building B and Winthrup...

I've setup a test database with three tables - clients, buildings, residency_dates.

The Residency_date table table holds the Client ID, Building ID, Move-In and Move-Out dates.

USE [NightsStay]

GO

/****** Object: ...

You're very close to understanding what we're trying to accomplish. Here's where I'm having a challenge... maybe I'm over-thinking it.

What if the person moves into Building A in...

Lutz,

Thank you for your questions.

There are two tables - Tenant and Buildings.

The ID in Tenant = ID_U in Buildings.

If a tentant returns they will have a...

The question is actually larger than I originally described. I need to find out how many nights an individual stayed in different buildings over a period of months.

CREATE TABLE...