Search results

SELECT TblCaravanBooking.[Booking Ref] FROM TblCaravanBooking WHERE ([Forms]![Booking History]![Caravan_No] = [TblCaravanBooking].[Caravan No]); Is returning nothing?

SELECT TblFacilityAssetType.[Facility Code] FROM TblFacilityAssetType WHERE (((TblFacilityAssetType.[Facility Description]=[Forms]![Booking Facilities].[Facility_Code]))); Doesn't work? I can't work out why? Any ideas?

SELECT TblFacilityAssetType.[Facility Code] FROM TblFacilityAssetType WHERE (((TblFacilityAssetType.[Facility Description])=[Forms]![Booking Facilities].[Facility_Code])); Access is having none of it and I can't see an issue? EDIT: Bear in mind that "[Forms]![Booking...

Hey, I need to merge the two queries below into one to make it run on one listbox: SELECT TblCaravan.[Caravan No] FROM TblCaravan WHERE (((TblCaravan.[No Of Berth])=Forms!Booking![Berth Combo]) And ((TblCaravan.[Caravan Type])=Forms!Booking!Type)); SELECT TblCaravan.[Caravan No] FROM...

To create A query that just takes some of the information from a form and insert it to a table? I would like to specify the form fields and table field?

I am trying to create a booking system and now I have 2 tables. One containing caravans that are held on a site and another using the caravan number as a foreign key containing booking information such as dates booked and for which customer. So far I have a query that runs to make sure no...

Hi guys, Need help urgently as part of my university assignment. I have a database which is serving to act in place for a holiday park containing caravans. The problem is that within the search criteria I have to find times when caravans are free and bring up a list of available caravans. So...