Search results for query: *

thanks r937 - makes sense now

solution- thread436-1238094

got it! thanks so much heres a * motsql1 = "SELECT mot.mott, mot.motslot, car.reg, book.bookdate, cus.fname, cus.lname, cus.pcode, cus.cusid, mot.bayid "_ & "FROM mottimes AS mot "_ & "LEFT JOIN book ON mot.motid = book.slotid "_ & "LEFT JOIN car ON car.carid = book.carid "_ & "LEFT JOIN cus ON...

thanks guelphdad - nearly there but i need it to only display mot.dayid that equal 1 and mot.bayid = 1 it lists all mottimes regardless of bayid and dayid. but it is better - didnt know you could leave out WHERE does that make sense?

this sql lists the data as i would like except it shows all entries in table book i would like it to only show records in table book that have the date i specify - but at the same time list all times that are in mott [code] SELECT mot.mott, mot.motslot, book.bookdate, mot.bayid FROM mottimes...

thanks - cant rememeber what i did will try this if it happens again

thanks for your reply... Time Booking 9:00 Free 10:00 Mr Johnson - HJ55JRX 11:00 Free 12:00 Free 13:15 Mrs Smith - HJ06TGY the ones that say Free will be links to a page to add a record/the ones that are booked will link to page to change details tables book bookid...

have changed the sql to this motsql1 = "SELECT mot.mott, mot.motslot, car.reg, book.bookdate, cus.fname, cus.lname, cus.pcode, cus.cusid, mot.bayid "_ & "FROM book "_ & "LEFT JOIN mottimes AS mot ON mot.motid = book.slotid "_ & "INNER JOIN car ON car.carid = book.carid "_ & "INNER JOIN cus ON...

thanks scheco - have tried LEFT/RIGHT joins still doesnt produce the rs i need - guna try UPPER! will try the mysql forum

hi, have the following mysql tables book bookid slotid date carid 1 1 20060602 1 1 2 20060602... 3 mottimes id mott slotid 1 9:00 1 2 10:00 2 3 11:00 3 am making a query that lists All mot times in a table and puts the car...

...that is to list all times in mottimes and if there are records that match the date part then list them

hi guelphdad - thanks for your reply you are quite right i have mis-typed the dates as stored in the table in date format. they do need to be in the format yyyymmdd for the query. the other thing is what you said bout where clause turning outer join into an inner join motsql1 = "SELECT...

thanks tony, this table lists all mot times in a day mottimes id mott slotid 1 9:00 1 2 10:00 2 3 11:00 3... & "FROM mottimes AS mot "_ & "LEFT JOIN book ON mot.motslot = book.slotid "_ & "WHERE dayid =1 AND bayid =1" there are left joins so that if there is no booking the times...

thanks for your answers, i am using asp to produce the page. even if there are no bookings for book.bookdate then i still want to list all mott - but if there are no bookings for this date then nothing is listed. also do you know a function that changes the standard date format to yyyymmdd?

hi, have the following tables book bookid slotid date carid 1 1 2006/06/02 1 1 2 2006/06/02... 3 mottimes id mott slotid 1 9:00 1 2 10:00 2 3 11:00 3 am making a query that lists All mot times in a table and puts the car...

i have 150 people each with there own jblow@domain.com account. to start off i just want each person to use OWA to get there mail. so if i only have the 5 cals that come with sbs will only 5 people be able to logon to OWA at a time. they would then have to close there OWA page to let other...

just to confirm - if i have 150 individual mailboxes i would need 150 CAL licences there is no way to do this with SBS i would need full version of exchange. even using OWA?

thanks v much, the whole reason to host our own email is to stop porn being sent attached to the messages but i dont think this is possible without disrupting users general work. nb. also shared calendars would be useful

....i have been told by one person the max individual mailboxes you can create is 75? someone else said that is not the case. please help - im going mad

hi, have looked for the answer to this but cant find a definative answer. we are looking at hosting our own email. we have 150 mailboxes. if i went the small business server 2003 route how many mailboxes can sbs support or would i need the proper version of exchange? i understand that sbs comes...