Search results

Sorry, no Not resolved, I am trying to work out the left joins and right joins so I clearly understand. I liked your post because it gave me a direction. Right now I am basically only using right joins by the looks of it. When I add a left join I get no results in my query.

I am too afraid to mess it up with adding holidays....LOL

Thank you for helping me learn.

I want to thank you for not making me feel like a total idiot. I truly appreciate the help learning. Just so you know I am building a DB for fun So I can learn new skills. I have taken some on line courses that have gotten me kick started, but as I progress I am finding so many people do things...

I am getting better I can write simple ones, but when I try to get a value first then return the results I am having troubles. I have another one. I need to calculate the days due. I can do that... [review date]-Date() But i also have to consider the status I need to calculate the days due...

Oh my gosh I have not tried to use switch before. I am scared.

DueDate: IIF(Weekday(StartDate)=4,StartDate+5,IIF(WeekDay(StartDate)=5,StartDate+4,StartDate+3)) Works!!!!

Yes it still only gives me the duedate excluding the weekends valuse it does not populate the due date if it is not a weekend

I want to create a due date and if the due date falls on a weekend move it to monday I can write DueDate=[startdate]+3 this gives me my due date I can write =IIF(Weekday([duedate])=1,[duedate]+1,IIF(Weekday([duedate])=7,[duedate]+1)) and that works now I have a second duedate field I want to...

Well I am stumped, every time I think I get it figured out something else goes wrong. Now when I make an entry on the form it is changing the data in the reference table no a random number value.

My apologies for clearly displaying my ignorance. I created a query from my Table and included the StatusID field. Based on that query I created a form. In the form I needed the StatusID field to be a dropdown from the StatusTBL. So I deleted the existing StatusID field and added a COBStatus ID...

I have 2 tables, each had a Status ID both are set to number. When I run my query I am getting the primary key from my status table (Column 0) I would like my query to show the value (Column 1). Can anyone help?

I have 2 tables each had a Status ID both are set to number. When I run my query I am getting the primary key from my status table (Column 0) I would like my query to show the value (Column 1). Can anyone help?

I am having look up issues, I have posted pics but basically I am looking up contacts from my contacts query. I have such a hard time explaining. I want to look up Jane, I want the lookup box to show two columns Jane's name and her job title, When I click the drop down I see Jane, but only a...

OMG, I just fell in love! This was the perfect solution. The example you sent helped me figure out exactly what I needed. I cannot thank you enough. @ Pat H. Oh my, I am so new. This attachment looks amazing, but way over my head for now. I am going to study it. I think I am having a hard time...

Thank you I did change my names as suggested. I am just learning and typing with a new mind set catches me. My tables are small for now whine I try and apply what I learn on line. So again thank you for your help.

I have two tables I am working with. Small tables because I am learning. StatusT has four fields, 1. Primary key auto number, 2. Status, 3. Description, and 4. Percent. My Task table has four fields 1. Primary key auto number, 2. Course 3. Status and 4. Percent. The status fields are short text...

I am loving this site, Thank you so much!

I tried that and no go. It changed the field header but data is the same no total anywhere. I do not see where it added up the numbers to give me a total of hours.

Thank you. I look forward to gaining knowledge!