Recent content by xeen20

Thanks Bob

Thanks for the reply Bob. I am new to this Access. Could you give me a idea if Select xxxx As yy From zzz where a = # gives me NULL So do i need to write another query like NZ(yy,0)

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

Thanks Aje. It worked now.

Ok, Thanks Rabbie and Aje Here it is Aje Lets think i have only 4 books and each have 100 pages. i am distributing to 3 people Publisher, Scanner and RFBD one book is distributed to different combinations and in the repot we are getting total no of pages we are distributed.( This is Fine)...

Very Very Thanks Aje, I know u will be there to help me , Hey i am not able to get the Total as show in the example, Could you plz help me in that. Like total Pages is only the Sum Of All Pages in Table. its not the grand total of the Report generated.

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--------...

Thanks Ortaias, But the Ajetrumpet Help Revised 2.zip worked for me. Thanks ...

Thank You , As of now what u gave me is working, But what if i wanna see both Firstname and Lastname in on combo box, is there any way...

Thanks for the Reply But i would like to have only one combo box which shows firstname and lastname, and give the required results in sub form I am attaching the databased i tried In this data base i combine firstname and lastname in the combo box and tried to fill the first name and last...

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-------...

The file size is more the 450Kb. when i zip it

Now it has gone to 3.4mb form 1.73 , i did wat u ask me(FILE > Get External Data > Import ) but no use . is there any other way .....

i dont knwo how to do that, do u have anything idea recover to original size