Search results

Hello again! I just faced task which seems to be quite difficult for me. I will make this a bit more simple then it is, so everyone could understand. So I have table with 3 fields for example: ID ( which is key ), Date, quantity ID is 8 digit number. I have like 1000 rows where there is just...

I am so sorry, I feel for you and your sister.

Everything is working great! Namilan +10 if I could :) Thanks a lot.

Great :) Now it makes big sense to me. I should figure out how to set first date() like 4 years back and 2nd date() 1 year in future

I am trying to get in your solution now, thanks! Think it is something in my access skills that i didn't understand mamlian and how can i benefit from date() in this situation :( In between date() and date() I would get out 0 records obviously cause there are none. I could make expression with...

Still looking for solution here, driving me nuts this. Last thing I have to deal with in this database.

Ye, now I have learned that all this it is not the most efficient work, however this time I would like to complete it. My idea was to make it more user friendly then it wouuld be with using access build in options. And it realy is, if only i could deal with these 3 date interval nulls. Namlian...

I realy don't know how to start it. Im not familiar with code realy. If there are any good resources or tips i would be up to it :) Im trying to get that Nz() working. If i understand right i have to change that Null value to emty string " " and then i can add "*" for everything.

Im new to access so i made all this just in design view by making expressions in criteria fields. If it will be necessary to get in code, I will try to master it :) sql view looks like this, dont know if it helps, looks scary, but thats cause there are just loads of things in it. SELECT...

Hello! I'm new to access, but i'm facing kind of difficult task now for my level. I have made quite complicated query by form. Which works as autofilter in excel in realy large table. My demand from access would be if all criteria fields in form would be empty then query gives out whole table...