G
George Applegate
If I have a table filled with records of days, say
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
and I have a query that has a select that it only include records
where the day entered exists in the table, i.e. by doing DLOOKUP, is
that a valid way to validate data entered?
For instance, so someone doesn't inadvertently enter "Sunderday", or
Thuesday".
Does that make sense? I want to validate that it only pulls in
records in my other transaction table that have valid days entered.
Or a variation. Let's say I have a table that has dates in it:
01/02/2008
01/03/2008
01/04/2008
Can I use a Dlookup to in a query select to only include records that
have dates taht match the dates in the date table file?
Just wondering if Dlookup would work for this.
thanks,
ga
George Applegate
(e-mail address removed)
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
and I have a query that has a select that it only include records
where the day entered exists in the table, i.e. by doing DLOOKUP, is
that a valid way to validate data entered?
For instance, so someone doesn't inadvertently enter "Sunderday", or
Thuesday".
Does that make sense? I want to validate that it only pulls in
records in my other transaction table that have valid days entered.
Or a variation. Let's say I have a table that has dates in it:
01/02/2008
01/03/2008
01/04/2008
Can I use a Dlookup to in a query select to only include records that
have dates taht match the dates in the date table file?
Just wondering if Dlookup would work for this.
thanks,
ga
George Applegate
(e-mail address removed)