Sort a field within a field

[CMXJay]

I'm making a query and and i have appointment dates, appointment times, and task code and i want to sort it is sorted by time in ascending order then by task code WITHIN the time in ascending.



the way i have it now is just sorted by time in ascending order and code in ascending order and i get over 4000 results and I should only have about 6 results, it repeats every customer for every procedure for every appointment time, Not sure how i did that but I was told I could fix it be sorting the code within the time but i procrastinated from fixing it for too long and and now i have no help :/ is there something i can put in the criteria of the task code field or the appointment time field that can fix this?

[June7]

This query includes more than one table? Post the SQL statement of the query.

[CMXJay]

Noob Warning: I have never opened SQL before and I have no idea how this works

SELECT [Provider Table].[Provider Name], [Appointment Table].[Appointment Date], [Patient Table].[Patient Name], [Patient Table].[Daytime Phone], [Procedure Code Table].[Procedure Code], [Procedure Code Table].[Procedure Name]
FROM [Performed Procedures Table], [Procedure Code Table], [Insurer Table] INNER JOIN [Patient Table] ON [Insurer Table].[Insurer Code] = [Patient Table].[Insurer Code], [Appointment Table] INNER JOIN [Provider Table] ON [Appointment Table].[Provider Number] = [Provider Table].[Provider Number]
WHERE ((([Appointment Table].[Appointment Date])=[Enter Appoitment Date]) AND (([Provider Table].[Provider Number])=[Enter Provider Number]))
ORDER BY [Appointment Table].[Appointment Time], [Procedure Code Table].[Procedure Code];

[June7]

I see 6 tables in that query but only 4 are involved in JOIN clause.

Should Performed Procedures Table be linked to Appointment Table?

Should Procedure Code Table be linked to Performed Procedures Table?

[CMXJay]

I don't really understand the questions. I have no idea how to tell what is linked to what by the SQL

when i open this query it is set up so it requests an appointment date and the provider number before is displays and for some reason it is displaying the correct appointment times but for every appointment time it displays every patient and it gives every procedure to every patient so there's 4000 entries and there should be less then 10 entries for every date i put in

[June7]

View the query in Design View. If every table does not have a line to one other table then there is missing links. This creates a Cartesian relation. Every record in the unlinked tables is joined to every record in the other tables. Another possible cause of the excess records is including several tables that are the "many" side of a relationship. I don't think that is occurring here. If the relationships I describe are valid, then set up links in the query and should see reduction in record count.

Seems you need a better understanding of relational database principles and building queries.