Search results

  1. N

    Help new User. Calculation: Field a + field b = field c (and express in all field c records in table)

    Thanks, how do you mean this? UPDATE table SET newvalue WHERE criteria; An update is to modify data in the column no? What I want is to set a day with sql for a column today, and keep it unchanged tomorrow. I think in my sql: "IIF(IsNull(RejectionDate), '', Date()) AS EndDate" It will check...
  2. N

    Help new User. Calculation: Field a + field b = field c (and express in all field c records in table)

    Hi theDBguy, It gives the date in all rows, and it ignores the RejectionDate valued column. In the RejectionDate column a date of 7-4-2021 is shown. 6 days ago. Basically it is doing the opposite sort of. Just a question left. How to store date() permanently in a column? (So it will not...
  3. N

    Help new User. Calculation: Field a + field b = field c (and express in all field c records in table)

    So, i found it is easier to test sql statements in separated queries to test if they work basically. If anyone is interested, I found the way to calculate the end date in the same sql query as well. select [all columns here that you need] ...
  4. N

    Help new User. Calculation: Field a + field b = field c (and express in all field c records in table)

    The question of a 2th action in the SQL boolean is still open. If someone knows how to use the argument so that it will set the enddate in another field it would be great. ID, ApplicationDate, Company, [Job Title], RejectionDate, IIf(IsNull(RejectionDate)...
  5. N

    Help new User. Calculation: Field a + field b = field c (and express in all field c records in table)

    Nice one. "This recordset is not updateable"........So Now i did the whole thing for nothing. The form can't be edited..... It Seems my Contacts_query can't be modified. I don't understand, but i can't use the form to modify fields. I didn't try to update the calculated columns. Just the other...
  6. N

    Help new User. Calculation: Field a + field b = field c (and express in all field c records in table)

    Thanks for the help. No it doesn't work. The syntax error error gives the same line: "IIf(IsNull(RejectionDate), Null, DateDiff("d", ApplicationDate, RejectionDate) AS TotalDaysComplete,Date() AS EndDate"
  7. N

    Help new User. Calculation: Field a + field b = field c (and express in all field c records in table)

    This didn't work either: SELECT ID, ApplicationDate, Company, [Job Title], RejectionDate, IIf(IsNull(RejectionDate), DateDiff("d",ApplicationDate,Date()),Null) AS TotalDays, IIf(IsNull(RejectionDate), DateDiff("d",ApplicationDate,RejectionDate) AS TotalDaysComplete, Date() AS EndDate FROM...
  8. N

    Help new User. Calculation: Field a + field b = field c (and express in all field c records in table)

    arnelgp, Thanks a lot! Your method works. i was struggeling with access SQl to get it working. It is a bit different compared to MySQL After a while I gave up and tried the Access gui method. (Create relation) In the end it worked and when I looked for the SQL code it was like this: SELECT...
  9. N

    Help new User. Calculation: Field a + field b = field c (and express in all field c records in table)

    no really not. that's what I tried first. It gives a "The expression you entered contains invalid syntax" error instandly. That's why I start searching the error on the net and i found =DLookUp("TotalDays";"SollData_query") If you mean the domain and field name I used earlier, this was my...
  10. N

    Help new User. Calculation: Field a + field b = field c (and express in all field c records in table)

    sorry Guys, I was still refreshing the old location of this post yesterday, so I didn't see the help posts coming in the other night. Thanks for all your time. changing control source to =DLookup(TotalDays, SollData_query) gives an 'invalid syntax' error. I double checked the names of the...
  11. N

    Help new User. Calculation: Field a + field b = field c (and express in all field c records in table)

    So, i still have one problem in my access database. I have one form I meant to use as a sort of "application gui" This form has all fields based on 1 control source which is the table where I started. I want to change one of the fields called 'EndDate' to take data from the new query instead of...
  12. N

    Help new User. Calculation: Field a + field b = field c (and express in all field c records in table)

    thanks guys for all answers. Arnelgp, I was wrong. I tried it out by opening a query and simple use your sql query and let it run the selection under "query" it worked perfect. You were right. Just virtualise 'TotalDays' and 'EndDate' in a 'calculated column' in a query, gives all i need. It...
  13. N

    Help new User. Calculation: Field a + field b = field c (and express in all field c records in table)

    Sorry Jon, for posting my question here. Could you help me to copy the post to the required section then? Arnelgp, thanks very much for your quick sql-boolean. I don't understand it quite, but that's me. DateDiff("d", StartDate, Date()), Null) => will this not give a negative value since you...
  14. N

    Help new User. Calculation: Field a + field b = field c (and express in all field c records in table)

    Hi Guys, Thank for allowing me on the forum. I am just a new user in access. It is silly, but I never used it really much. I was hoping to find some experienced forum members here that could help me further. What I try to do is very simple. Just i don't know the best road to get there...
Top Bottom