Search results for query: *

That's just the beginning of my query. Several of these prospects have more than one NoShow. The way my query stands now, It will pull up all the reservation records for each [LeadNum], which could be just one or it could be five. I need to be able to pull out only the most recent NoShow for...

I have two seperate tables in which I pull data from. One is the "leads" table and the other is the "reservations" table. The "leads" table houses all of the prospects information: name, address, etc. The "reservations" table houses the reservation...

How can I attach the current date/time to a record after any of the data has been modified? Thanks! :-Q C. Carpenter V0lup2us@aol.com

Quehay...The first option you provided me with is more of what I was looking for. Thanks!!! Ok, so i've got it all set up and it looks fine to me, but i'm getting a run time error... 'Too few parameters, expected 1' On debug, it highlights... Set rs = qdf.OpenRecordset(dbOpenSnapshot) Any...

OK...so I hate to sound completely blonde, but will this build a temp query for me? or should I refer to the one I already have set up?? Thanks! C- C. Carpenter V0lup2us@aol.com

I have a form in which users may find a particular prospect. Inside an option group, I have text boxes that give the parameter in which to search for each option(field). My problem is, the list box which the query fills in can only be bound to one query. This is fine, but I would like to have...

Yes I have verified all of the above! I'm completely stumped. I have remade the form several times and keep coming up with the same problem. Any other suggestions?? Anyone, anyone?? Thanks! X-) <p>C. Szymanski<br><a href=mailto:V0lup2us@aol.com>V0lup2us@aol.com</a><br>

I have a client entry form with a payment information subform. For some reason, when viewing the initial form, the subform is completely blank. Any ideas why this would be occuring??? Thanks in advance!! *:->* <p>C. Szymanski<br><a href=mailto:V0lup2us@aol.com>V0lup2us@aol.com</a><br>

For some reason, when I came into work today, find does not work in only one field. For no reason at all! I'm a little baffled, any simple explinations??? Thanks <p>C. Szymanski<br><a href=mailto:V0lup2us@aol.com>V0lup2us@aol.com</a><br>

I have a data entry screen for hotel reservations. (Linked to [Reservations] table). Also a table in which room allotment is entered. Say I have 20 suites available at &quot;X&quot; hotel for November 3rd, 4th and 5th. I need to enter the new reservation for those days and reduce the number...

Thanks Michael, So then, can you suggest the best way to set up my table so that it's more like a 'normal' loan table? I'm just now getting started with this type of database, any help you could provide would be most excellent!*:->* <p>C. Szymanski<br><a...

I basically need to enter in the purchase date, loan term and have all of the payment dates automatically fill in. [PurchaseDate] [TermOfContract]= [Due Date 1] [Due Date 2] [Due Date 3], etc... :-Q Thanks to anyone that can help! <p>C. Szymanski<br><a...

Yes, that is correct. I actually have 3 keys for this table: [Hotel], [RoomType], [Date] The others are... [Units]-#available rooms for the specified date. [DaysOut]-Days until allotment amount runs out. [LastCancel]-Hours before midnight of arrival day when you are charged for no show. If...

I need to reduce the number of available hotel rooms per night in our allotment table. My reservation entry form is basically set up: [ArriveDate]+[Nights]=[DepartDate] How should I link it to the allotment table and then deduct from the available nights once the each date is entered?

I have several different types of confirmation letters that print for clients. They are all linked to a specific &quot;LetterCode&quot;. At the time each letter is printed, I would like the action to auto fill the &quot;LettersSent&quot; field, with both the letter code and the date/time...

We have a large database of about 400,000 names. I need some information re: the easiest way to import new leads (usually around 20,000) and eliminate any duplicates that may already be in our database

We have a large database of about 400,000 names. I need some information re: the easiest way to import new leads (usually around 20,000) and eliminate any duplicates that may already be in our database.

We have a large database of about 400,000 names. I need some information re: the easiest way to import new leads (usually around 20,000) and eliminate any duplicates that may already be in our database.