Search results

Hi Guys. I build a report in which i need to add a number and NULL. like = Sum(# + NULL) But i should get =Sum(# + Null) = # for example: pages = 100 books = NULL are too feilds in my report when i do =Sum(pages+books) gives me nothing but i would like to get =Sum(pages+books) = 100 is...

Hi Guys, i have a problem in converting NULL to 0 , i wrote a query which gave me a Null value, But i would like to know if there is any way i can change the NUll value to 0. ex SELECT Sum(xxxx) AS yyyy FROM zzzzz WHERE******=#####; i got NULL. I need to get 0 instead of Null. Plz help

Hi , i am new to access and i am struck with a prob in building a report. i have a table with name : Books and fields Title ------Type-------Page-----Publisher---Scanner----RFBD Book1----Simple------199-------- -1 -------- --------- -- Book2-----Hard-------282--------...

Hi , I am new to Access, i have a problem in searching my database, I have a table name Called: details Coulmns or Feilds are FirstName--------LastName------Title ----............ x ----------------y-----------123 -------....... x---------------- y-----------343-------...

Hi, i am new to access. Anyone know why my .mdb file size Growing. Even when i delete the data from table and done with the compact and repair. i am doing my first small project with one table and 10 querys and 5 repots. each time i edit the query or report the file the size goes on...

-------------------------------------------------------------------------------- Hi, I am new to access i am having a prob with a report hope u guyz help me My Table is name ---- type(type have only 3 values( p,u and z ) but repeated) x----------p x----------u y----------p x----------z...

Hi, i am new to access and i am stuck with a issue, hoping u guyz could help me. i could not update my fields with reference to the value in the combo box. I have only 1 table and 20 columns. I created a form with 19 feilds with control sources to the table columns...

Hi, I would like to export a table formed by a Query into a excel sheet with a Click of a Customized button. can Anyone help me how to do that. I can do that by going to file and export to excel sheet but i need it to be done with a button of my own .

Hi i have a problem to count no of records base on certain criteria. I guess this is a basic questions for u guys but it is not for me as i am new to access. I guess some one could help me in this .... My porblem: I have a table with 3 coulms Handout/Books has only 2 predefined values...

Hi all, I am new to Ms Access and i am doing a class project now. can anyone fix the saving record problem. the add form in the attachment is not working correctly. i gave some fields to be compulsory but sometimes i could see some blank coulmn in the tables. Some friends here...

Hi, I'm new to access, i have a class project to be submitted soon. i am really trying to do my best to complete that but i couldn't. i thought of take some help from u guys The Project is just like a library project. where we need to maintain the students records. The students gives a book...