Recent content by hamed_gan

Tnx, At least I know it is possible now. The only thing to do now is to figure out VBA.... Tnx again and happy christmas Zurvy

Hey again, I meant by Germany...UK So all 1. Give all the CustomerNumber & Customer Numbers in UK (not germany)

Hell all, I was wondering whether the following is possible in access; I need to create a form which is able to show the requested information. Let's say we have a query (which is a combination of five tables) about sales information of a company. It contains the following fields...

tnx ya all! You really helped me out. Ciao for now. :p

Hello everybody, I have a problem which should be simple. I have a txt file (exported from oracle) containing data I want to add to access. What I usually did was the follwing: 1. Importing the txt file to Excel, 2. Using the Excel Import text wizard to set the brakes for the columns 3. Sort...

Tnx...for the info. I happend to read in on Microsoft Knowledge Basis. And I was unable to find the Nz function on the Built-in function in Access 2000. Maybe it is built in but you cannot find it? Regards, Zurvy

tnx again, I know exactly what you mean, but there is one factor I cannot change, The data are exported from Oracle. The data are extracted on montlhy bassis. So on a Oracle report, the month will apear as in columns. An the order ID is igonerd, as it is not necessary for the purpose of the...

Hi all, I have a table containing the details of the sold quantities of a particular Item to a Customer; Field1: CustomerNumber Field2: Customer Name Field3: ItemNumber Field4: Sep-03 (the whole column contains the quantity of a given item sold to a given customer in the Month September-2003)...

Hey there, Is the other system also using Access 2003? According to my information Nz is only compatibel with Access 2003. You could also use an make-tabke query with an IIF statement in the fields containg the Null values; Just type in an emty field Y: IIf(IsNull([X]),B,[X]) Where Y is...