Search results

Is it posible to use a iif statment in a validation statment ? i have one table project and i want to check the occurens. IIF ([ProjectStatus] = 1 ,[ProjectCompletedDate] = NULL, [ProjectCompletedDate]<> NULL) when the projectstatus is 1, the date cant be filled in. is this possible in access...

meaning you can't sort? (sorry sometimes english is a bit hard to understand) i thought of that. you mean: subjectnr, meetingnr, subjecttitle, location ( LOWEST level ) 1---------1----------subject 1-----1 2---------1----------subject 2-----1 3---------1----------subject 3.1---2...

when i export it as a raport. The numbering is very important. It goes to customers. The subject will be numbered: Meeting: 1 1 subject 1.1 1.2 1.2.1 1.2.2 1.3 When i use recurency, you have to generate the numbers. Aint this risky? Aint it smarter to record the numbering in a table. For...

Hi, i want to create a meetingstyle form the form must have a tree with the posibility to make subjects. In those subjects you can make sub subjects and so on. see example. How do i construct the relations? see picture:

you mean, one product table, and one quotetable. Yes i would slit1

Hi, Im constructing an ERD. I got rid of all redundancy, but im stuck atm heres my question: Is it bad to have 5 pri-key in a entity? I an work around it when i leave a tiny bit of redunancy, but in my perfect opinion its better to have no redunacy! So can i contruct witout getting problems...

to difficult ?

Ill try excplain. Im desiging a reservation system. You can book a place for a periode of time. I have a combobox on a form which displays the free spots left after looking at the formbegindate and forumenddate that the user filled in. Here is the problem When a spot has been reserved more...