Search results

I am trying to setup a database that I can use to book reservations for a motel that has 60 rooms. I want to be able to make sure I do not over book rooms. any suggstions? I could really use some direction here. lost Tammy

HAVE FUN WITH IT!?!? :rolleyes: you must be mad... The guy I sit next to in class was so excited to find out that you are able to set a password to protect access to a data base that he was giddy —I bet he could have fun with it. As for me, I just pray that I can make it through this class...

I see that you used a form to format the fields, you used a validation rule for the last name field you used an input mask for the first name field and i don't know what the heck it was you did for the middle name field other than i think it was done in visual basic. I see that I can use the...

I tried using the code you provided, changing "TheName" to "LastName" and "FirstName" as those are the names of the fields I need to format, but it didn't work. Perhaps I am making this more difficult than it needs to be. Here is the deal I am a begining Access student, - our teacher challenged...

Well if you haven't guessed by now I am very new to Access... I am suposed to create a simple table and in the design view, using the formatting properties, set it so I get the proper case. Apoligies for the double entry, I've fixed it. Well if you haven't guessed by now I am very new to Access...

Help! Simple format question In a text field of a table - I know that using ">" in the format prpoerties, all the letters in a word will appear capitolized, but I want to be able to set the formating so the first letter will apear capitolized and the rest of the letters in the word are lower...

Thank you !

Re: Re: HELP! Very Simple Query I figured out how to only show the desired fields in table view, right click, select hide column, but I still can't seem to figure out how to simplify the expression, (or complicate it which ever be the case) so there is only one expression column instead of 2

OK, I'm sure there is a simpler way to do this (heck I can barley figure out how to post to this forum!) anyway, here is what I did... I added an expression 15% off: [Weekly Rate]*0.15 then added another expression Discount Rate: [Weekly Rate]-[15% off] Owner ID---Address -----Weekly...

I need to figure out how to display a 15% discount on a weekly rate field (I'm new to access, taking classes, and in the book it suggests that I should use Microsoft Access help to solve this problem--- HA!) The question reads: "Owner ID: ML10 offers a 15% discount on the weekly rate if renter...