Parameter Value and Data Question 2

[taltonm]

Hi,

I have a n annoying issue that I cannot put my finger on. I have a report to write that requires a from/to date parameter for appointments. no problem there.

the other requirement of the report is that I look at the previous appointment date to see what was done on that date. Problem, if I am looking at the next weeks appointments say 5/22/06--5-26-06, the parameter selection obviously only looks at records with that date. if the previous appointment happened two months ago it does not show since it is outside that range.

any light shed help would be appreciated.
thanks
Mark

 

[Madawc]

Select the appointments table twice, this adds it as an 'alias', which can be treated as if it were a separate table.

Be careful about the range you give it - if the alias doesn't include apointments next week, then you'll not see cases with an apointments next week but none two months ago. Select the alias for everything from two months ago up to your end date.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[taltonm]

ok, I will give that a try and report back, thanks for the insight

Mark

 

[taltonm]

looks like everything is working good, as soon as you said alias, I realized what I was missing. thank you very much for your help.

 

[taltonm]

how should I link the Aliased table?

thanks
Mark

 

[Madawc]

Depends on your data. Normally I link by account number and date-stamp: our database has datestamps that let us look at the same record at different times, where necessary.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10