How do write the Criteria so that the user will be prompted to give a From Date and then an End Date and the query show only those records that fall within that time frame?

Write a made up field name in the criteria for the date field. In other words, if your date field is named "Date", then in the criteria box, enter the following as its criteria:

Between [EnterStartDate] And [EnterEndDate]

This will then prompt the user for those two "fields" before running the query.

HTH