[users] Sorting in Report

i'm making a report, based on a query. The report is Grouped and Sorted, first on Date, then Neighborhood, then Street. In the detail area, the first control is the house number which, when the report is generated, does not order the house number in ascending order. i've ordered the field

[users] Base - Relationships

Hello Fred, Actually I saw your first email and meant to reply - just got off on other things and never back to it. Let's start with this - look at the attached database. Is this about how you have it setup? Drew Drew: Thanks for the above. However i didn't see any attached db. i get

[users] Base One to many relationship

i hope this is the correct forum for this... i'm still trying to get this to work... i've created two tables: Dates and Visits. This is a bare-bones setup to see if it works. The idea is to input info from visits to homes into the Visits table. Since many visits to homes are made on the