Search results

Erm not sure if i can post the cut down version of db. I may need to post the full database, but not sure if Admins allow me to post a full database.

Hmm i tried the above but not sure if it is working really. As you suggested, it works okay but it still shows the maximum number of records that i have in the table which is 76. Don't know why it is not working. Want something like Chalet type 1= 6 (meaning how many customers have booked...

Oh okay thanks, just going to see if it works. Do I need to have the party leader table, chalet and the booking table in one query?

Dcrake, the way you put it would be a better solution just to having show which party leader made which booking and to show the popularity of the chalet. So how would i do that in SQL? Much appreciated

Hmm I dont think I can change the lookup tables now as this is due in on Monday, so im limited with time.

No party leader is not a customer.. basically the party leader can make a booking on behalf of the customer. i.e If i was to call up and say bla bla bla want to make a booking for this person, they would need my details.. I could be paying for you to go on the holiday.

Pbaldy, I tried the SQL that you had suggest, but it works to some extent. It just shows the maximum number of Chalet. Now i have looked at my chalet table and in there also shows which booking is made for each of the chalets. Im thinking would i need to have an outer join?

Right okay, well below is the screen shot of the database and the Booking table, with Customer ID, this shows which chalet is selected. Hope this problem can be resolved. http://yfrog.com/1gdatabasepj

Well, the expected result is to show which chalet is popular when party leader makes the booking and to result that as a Query, but not sure how. Just checked that the customer data doesnt need to select the chalet, its only the Party leader that chooses the chalet. Hope this helps.

Hmm it sounds good, but im just thinking in my head how it will work. Cos the Chalet just shows the descriptions of the type.. and there is another table called party leader, and that table includes which chalet is chosen, and ditto with customer table too. So do i need to have another table...

Hello everyone and hope you all are okay. Bacially i have a table that is called chalet, and the database is about a booking system. Now what i want to work out is, how do you find out which chalet is popular. I.E one, two or three.. bedroom chalet.. How would i find out which one is...

Thanks it does work, I tried Allens E-mail rule and it works really well. Must thank you as you helped me alot in fews mins.

Do you a validation rule that only allows you to input a text OR a numeric in one field. such as house name/ number, but not both...

Thanks pbaldy, the link works like a charm, it is very useful. thanks once again.

Edit.. OMG IT WORKS argh yay, i needed to leave space between first and name and now it works, thanks. I have another issue, what if i want to have a rule for only accepting text and not numeric in text data type? is that possible..?

Hi thanks for a quick reply, but it doesnt seem to work, it says the following: Could not find the field name "FirstName"...? dont know what is going on, btw im using access 2007..

Hello everyone, this is my first thread and post. Basically i want to limit the character size in a table. E.G Field name- First name and data type-Text I want to limit the character size of the first name so the minimum is 4 characters and up to 10 characters max in length. I been...