Allowing rows with no data?

[KMKelly]

I have a report now that shows patient information in a group header (ID, Birth weight, Birth Date etc...) and then the charges for a specified range of dates in the detail section (includes Date, Charge code, Physician, Daily weight). But it will only show the dates that a charge was actually made, so if the patient comes in mid-week, it starts with that mid-week day. And gaps don't show up.

I am trying to find a way to make each date in the specified range show up for every patient, with the related daily charge info where applicable, but I have not been successful. I started trying to code it in the "On Format" property of the Detail section, but when I am at a record in the recordset for which I know I need to just enter a date and skip to the next line on the report, I can't do that without going to the next record in the recordset which is not what I want.

If anyone has any ideas or insights, I would much appreciate it. Thanks.

Kristin

sample:

9999999 Doe, Jane 6/30/03 1.6 Female
7/1/03 99296 Dr. Spock 1.6
7/2/03 99296 Dr. Spock 1.6
7/3/03
7/4/03 99296 Dr. Spock 1.7
7/5/03 99296 Dr. Pierce 1.7
7/6/03 99296 Dr. Pierce 1.71
7/7/03
--where nothing billed on 7/3 and 7/7

 

[jfgambit]

Kristin:

You would need a table with All Dates in it and then the table with the Patient information (including the dates. You could then create a query and change the join between the two tables to be Show all from the Date table and only those where there is a match.


This would get you what you need.

HTH


"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"

 

[KMKelly]

I have tried doing something like this, but when I do the join I need all dates for each patient and with the join from all dates to patient dates, when I group on patient in the report, anything that didn't make the join drops out because the patient name info isn't there.