Search results for query: *

You might take a look at MS SQL Server reporting Services "Report Models" feature.

Here is what I have tried: SELECT ResDate.ResDate, Reservation.ResourceID, Reservation.User FROM ResDate LEFT JOIN Reservation ON ResDate.ResDate = Reservation.ResDate WHERE (((ResDate.ResDate) Between #1/12/2003# And #1/20/2003#) AND ((Reservation.ResourceID)="101")); It does not...

ResDate Table Reservation Table [ResDate] [ResDate] [Resource] [User] 1/12/03 1/13/03 101 MB 1/13/03 1/13/03 102 BR 1/14/03 1/15/03 101 MB etc. 1/16/03 102 BR...

I am working on a system for reservations and I want to be able to produce a result that lists the dates for the next 10 days and then show which days have reservations to feed to a datagrid in VB.NET. (Database is Access2000) I first created a table of days to join my reservations to with just...

Worked Great! Thanks so much for your help..

Thanks for your input. I was actually close to this method but I need to go a bit further. I want to be able to get at the entire record that has the latest date/ref. This is the part I don't know how to do. How do I select all the other fields in the row for that record? Test Table Data...

I have a table which contains records with these fields: ID# Name Date Ref# etc.,etc. There are multiple records for the ID# and they usually have different dates. The etc, etc fields may be different in many ways. However, there are times when dates may be the same as well. In this case...