Posted by scf84 5 years ago In:

, ,

scf84
scf84 Asked:

In ms access, I would like to call a query that ...

in ms access, I would like to call a query that returns a constant list, assigned to each ID in a table I have, unless another record exists, in which case I would like it to replace a certain record...

Is there any way to do that?

Liked this question? Tell your friends about it

2 Answers

Order by
Oldest to Newest
Newest to Oldest
Votes
scf84
scf84 Answered:

What I'm trying to build is a kind of employe schedule.

Each employee fills in the time when he's available and the time he's not (each hour of the week)

now, the thing is that there are special weeks when an employee's availability changes.

I would like to allow him to change a day's availability without changing this constant schedule of his.

Am I clearer now?

How would you do that?

Add a comment Report
somala
somala Answered:

You can do it. try to search in msdn website. you will get it.

Thanks

asp.net

Add a comment Report

Related Questions

Other people asked questions on similar topics, check out the answers they received:

siva

Asked: In access query want create a condition it shows ...

In access query want create a condition it shows a syntex error please help me. if invested amount "<300000 then pay @1%" and ">=300000 <= 500000 then pay @1.5%" INTEREST: IIf(([AMOUNT]<=300000 ...
Fred Morris

Asked: How to access missed calls

How to access missed calls