Search results

i did not write to sql code im using design view. Sql code seems so funny now :D and i cant send them because its forbidden from company :S

Date Type is Date/Time its correct. a million dollars question : if date type is correct why do i get this error message :(

I copied your first code "BETWEEN DateSerial(Year(Date()), Month(Date()), 1) AND DateSerial(Year(Date()), Month(Date()) + 2, 0)" but its not working first error was Sytax and i used "" and now there is a new error : Data type mismatch in criteria expression.

Hello guys, I need to Criteria between currently Month and Next Month. (we are in April because of this im giving this example : 01.04.2015-31.05.2015) I tried this code but its not working : Dateadd("M") between DateAdd("M"+1) if you have a solution please share to me Ty.

yes i have to use this system. Its not my choice, my company wants to use it. and they are weeks not months (doesnt matter weeks or months) "yyyyXX" only if xx come to 36 after that yyyy shall be +1 and i need to difference these 2 dates. (PS : I dont want to use this system not for all...

Nope its not a day in fact these XX are Weeks. every month has 3 XX and 1 year 12 month totally 36 XX thats why company is using yyyyXX system. I just need to define new weeks system normally is 1 year 52 weeks but mine is 36 :D if i define this it ll be so simple

Yes its a date. But not same as you know. (Its our job system) its doesnt matter. Is There a solution or not. Date or number what else !

Hi guys, i need your Help because i dont know how shall i define my new Date or numbers. Now "yyyyXX" this is my date "y" is year 4 digits and "XX" is my problem 2 digits. I ll give an example, (XX = 01....36) XX can be max 36 and min 01 of course. f. Exp. 201436 and next number shall be...

i did not create this database but i must find the solution. How simple is that. I do not have and find any solution. ----o----- If i fix it i ll 1 more problem. They want to from me 10-5 = ? the problem is these numbers are not integer instead of String. still can i substruction this 2...

Hello Friends I need to change my all field information at the same time. For example : FIELD a a a a a a This is my field and i want to change there b instead of a (of course there is 5000 records) Is that possible ? how can i do that ? or can i change at the same time 1by1 its not an...

Hello Everyone, My Access is turkish hope so it ll be not problem for you. I will explain what i need : As you can see from Pic. i need 3 pie and every pie ll report for me different infos and i ll write top on the page 2 dates and it ll give me results and show to me on pie. For...