By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,271 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

Find record with 3 values

reginaldmerritt
100+
P: 201
I have a table (tbBookings) which holds three important bits of information about a Shift or Job. These are (dateofshift) (typeofshift) (staffbooked).

On a form i want to have an AfterUpdate event on the (staffbooked) field to lookup the tbBookings for any record which has the previously mentioned fields equal. In other words i need a away of checking that the (staffbooked) isn't doing the same (typeofshift) on the same (dateofshift).

I have been trying to use Dlookup but the fields have diffrent data types, so i'm having problems using this methord to find a record with all three values.

Any suggestions on how this can be done are more than welcome. Thanks
Dec 14 '07 #1
Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,383
Can't help if we don't know what those data types are.
And is the form not bound to tblBookings? Why are they different data types?
I would use DCount rather than DLookup.
Just so you know, Access has a bunch of data type conversion functions.
Dec 14 '07 #2

reginaldmerritt
100+
P: 201
Can't help if we don't know what those data types are.
And is the form not bound to tblBookings? Why are they different data types?
I would use DCount rather than DLookup.
Just so you know, Access has a bunch of data type conversion functions.
Ok thanks Rabbit. I check out Dcount and give it a try, if i have any problems i'll be back.
Dec 18 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.