Julie Bright
Last Activity: Mar 27 '12, 08:27 PM
Joined: Feb 20 '12
Location:
-
Wow thank you I shall give it a go (when I've read it a dozen times to take it in) -
Thank you,yes, I am making regularly copies, very early on I discovered there was no way of undoing things that seemed not to work. I think with the ideas/thought processes you and neopa have prompted I'm very close ... (famous last words). Tx (ps I had hope there was an undiscovered global ''search and replace/delete', but my hopes were too high. I have searched for something closer to my requirements, but the Northwind template does seem to be...Leave a comment:
-
Thank you for the additional info, unfortunately while i am a competant 'exceller' i dont seem to have Access terminology to hand -I shall press on and when I get to the hitch I will try to word my problem betterLeave a comment:
-
Amending northwind template
I am trying to create my own db from the northwind template. Generally it has all the elements I need, but also several I don't, such as 'shipping'. How can I remove these without causing there deletion to provoke error messages?
Hope this make sense, any ideas appreciated. -
Thank you for your comments, in short I suppose there is no difference between a booking and an order. My concern was in trying to keep them separate to avoid duplicating dates and numbers, as a booking for a room would involve x guests for 2 nights from (say) 23 june and an activity would be booked for the same x guests for 1 day (say) 24 June and another activity for the same day etc. I guess I can add these fields to the Order Details table? ...Leave a comment:
-
Adding a table
Im creating a database for my hotel based on the access sample template. We sell packages incl accommodation and a variety of activities based at various venues. Ive managed to get the program to calculate the cost of a package but I now need to add in the arrival date of a booking, number of guests, number of nights.
As incl with the template I am using The following tables currently: orders, order details, products, venues, i think...
No activity results to display
Leave a comment: