barnettjacob
IS-IT--Management
Hey, I'm trying to query an Access Database with PowerPivot. Long story short I am trying to bring in the date of a Guest's first booking from the Bookings table with their ID, Country and the Date their account was created from the guest table.
I've done this a million times from SQL Server databases but when I try with Access I get an error about a Type Mismatch. Here is the query as it stands:
SQL:
Select
[Guests].[GuestID],
[Guests].[StartDate],
[Guests].[Country],
Min([Bookings].[BookingDate])
from [Guests]
join [Bookings] on [Bookings].[GuestID]=[Guests].[GuestID]
Group by
[Guests].[GuestID],
[Guests].[Flat Date],
[Guests].[Country]
Thanks
Jacob