Help with report

[whojstall11]

Can anybody show me how to make all of my start date information show before my discontinue date information

[pbaldy]

I hope that's not an actual patient name/number. If you're grouping on started date, the report should sort by that. What does the report look like in design view, with the sorting and grouping shown?

[June7]

It appears start date and discontinue date are two fields of table. This will require some manipulation of the data, such as a UNION query, or subreports.

[whojstall11]

Yes im glad you took that off but i here is the report in design view.

[pbaldy]

Have you tried sorting on that field in Sorting and Grouping?

[June7]

Don't think Sorting and Grouping pertinent because the start date and discontinue date are different fields, not data in one field.

[pbaldy]

I read the original problem as the report not being sorted by start date, which is a problem the original attachment displayed. If that's not accurate, perhaps the OP will say so.

[whojstall11]

Have you tried sorting on that field in Sorting and Grouping?

I have i dont understand how it works I need for Start Date, Medication, Dosage, Frequency to come before discontinue date, and notes. If it helps Start Date, Medication, Dosage, Frequency are apart of one table (all one row) and discontinue date, and notes our apart on another table (all one row).

[whojstall11]

Start Date, Medication, Dosage, Frequency are apart of one [Medication table] (all one row)and discontinue date, and notes our apart on of [Notes] table (all one row). I want every thing from the medication table to come before the notes table.

[whojstall11]

it looks like this now


i need it to look like this with all the data

[June7]

Okay, Grouping might be helpful. Create a group for the StartDate and include the Medication table fields in that group header. Put the Discontinue date and Notes fields in the Detail section.

[whojstall11]

yea i tried that it only outputs one record and it would make duplicate notes fields

[June7]

I can't help further without examining database. If you want to provide, follow instructions at bottom of my post.

[whojstall11]

i split the db already is that going to be a problem

[June7]

No, zip both files. Remember to copy and remove/replace confidential data, run Compact & Repair. If the backend is very large because of data, remove records, leave just enough for testing.