Search results

Okay, everything in the database now works. apart from one final task. I need to somehow create a query that that reads a caravan number from tblcaravanbooking and shows all the booking references associated with it. I just need a format to work with?

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

Any help? I really hope so, My deadline is in 7 hours.

Haha Basically, the process involved is that the the user would choose a description of a facility and the query would match the input (Now more appropriately named as 'Facility_Description') to the facility code in the same row? If that makes sense. I have changed the query due to the new...

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?

Thanks! I did that and now its all good :)

Basically, the box which it is comparing it to pulls its value's from a separate column in the table, this means that that value (Text, not number) needs to be compared to the value in the table to be matched up and displayed again another box? Does that make sense?

But the data needs to fit both criteria, if I use the union query it shows all of them?

Yeah, no result, if I run the form and then run the query it just opens the datasheet with '(new)' in the field that should display the appropriate code.

Doesn't work as a list box either?

I combined them through an 'And' in the end. Seems to work?

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...

SELECT DISTINCT TblCaravan.[Caravan No] FROM TblCaravan LEFT JOIN TblCaravanBooking ON TblCaravan.[Caravan No] = TblCaravanBooking.[Caravan No] WHERE (((nz([When Required]>[Forms]![Booking].[Required_Until],True) Or nz([Required Until]<[Forms]![Booking].[When_Required],True))=True)

That doesn't seem to be a video?

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...

One more thing. How can I combine 2 queries that consist of: 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 TblCaravan LEFT JOIN...

Hey, Its just the fact that I have a list box that retrieves its values from a query but I need to input the selected result to a table? If i bind it to the table I want it in it then doesn't let me choose any of them?

Thanks for all your help. I fixed it!

I literally cannot explain how much that helps! Thank you!

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?