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

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.