Query Start and End Dates

[Pedro Pinto]

I'm new in Databases and Access, so my problem is very simple.
I have a table with three fields: Name (Prim. Key), Start Date (Prim. Key) and Cost.

I want to obtain a query with this fields:
Name
Start Date
End Date (where the End Date would be one day before the next start date)
Cost


Thank you

 

[hmongie]

You might want to populate an end date in your table as well. This should resolve the problem when you query for the end date.

Table Fields:

Name
StartDate
EndDate
Cost

Hope that helps.