Search results

Both return an error #size!

ok sorry if [rundate] is empty then [some_date_field] else return the original value from [rundate] (where [some_date_field] is based on "dateadd" field on the form)

ok =IIf([rundate],IsNull(Date(),1/1/2019)) now the false part 1/1/2019

if "rundate" is empty put the current date all the Is function return the same value

i have a date field on a form where the data is coming from a table now i notice the in the table the field is empty(Serious employee failure) i can put any date that i want in the field(It will be corrected later) first i did a check =IIf([rundate],IsNull(Date())) i get the result...

Just understand if we are talking about the same thing Right click on the file itself not within Access By the way I had a problem about two weeks ago. on all my computers (11) Windows 10(x64) and Office 2016 are all installed from the same disk and the same serial number I took a database from...

My mistake I thought was working on ACCDE For the second thing, you may see a message in the file properties at the bottom "this file came from another computer and might be blocked to help protect this computer"

Db that created on x64 won't work on x32 vs varsia The dll's are different When i worth protected i meant block by windows defender you can see it on file properties

did you take the db from x64 and run it on x32? look if the spreadsheet is protected when you copy a file from one pc to another the file get protected

Thank you all I solved it that what i did gives me the amount of months months: Diff2Dates("m",[StartDate],[EndDate]) gives me the amount of months and days months_days: Diff2Dates("md",[StartDate],[EndDate]) this code well extract the number from the string days: Mid([months],11,2) this...

isladogs I am grateful for your help one problem let's take the first record for example 2 years (24 months)multiple by 1200 = "28,800" 2 months multiple by 1200 ="2400" 13 days have to by in this formula 1200 divided by 30 = "40" multiply by 13= "520" now 28,800+2400+520="31,720‬" I'm very...

i get the result as "1 year 1 months 1 day"(example) now i have a field that show me what a person should pay for a month(Varies from person to person) a month will always by divide by 30(Bookkeeping) so I will take the year and divide it by 12, multiplied by the monthly amount then the months...

in the "diff field" i get the result as "1 year 1 months 1 days"(its a string as any sting not a date format ) can i Extract the number next to the text exemple: extract the "1" from the "year"(it can be 2 numbers) to a new field in the query same to the "months" and "days"

thank you very much isladogs 1 Q' can i turn it to a number "m"+"d" = 5.6(example) rong Q' i need to multiplied the result by 1200$(for example)

Exactly what I wrote that I did same error

i made a new db for check created a table "table1" with the fields "date1", "date2"(as the code" created a Module "modDiff2Dates"(like you wrote) created a query from table1 and putet the code in a blank column SELECT [date1], [date2], Diff2Dates("ymd",[date1],[date2]) As Diff FROM [table1]

SELECT [StartDate], [EndDate], Diff2Dates("ymd",[StartDate],[EndDate]) As Diff FROM TableNameHope that helps... i get the error "The Syntax of the Subquery in This Expression is Incorrect" There should be more brackets

I couldn't figure out which field would show the result And where the function is put. In the form, in the field, in the module etc'

thanks i will take a look on that

hi: i need to calculate months with days that past from the start of the months for now i'm using =DateDiff("m", [start date]'[end date]) now i have a problem let's say the "start date" was 20/10/2019 and the "end date" is 1/12/2019 so its one month and 11 days. Access referred the "20/10/2019"...