Search results

Town Dog, did you get a average of 100 for Jill when u ran the query ?

I tried this below but i still gettin the same results. Its taking the average of all three including the zero. I am goin to try the Zn function Average...

Correct. But i want it to divide by the amount of figures that are > 0. So it should really be divided by 2.

There will always exist 3 feilds to carry out an average. Its just that somtimes, there exists a null value for a particular feild. And i do not want to include this figure as part of the average.. Any ideas ?

My 1st sentence. I want to know how to be able to accomplish what i have in the example given. I only know how to calculate average on feilds ragardless if any contains a null value. So the query will divide by the amount of feilds greater than 0

Hi all, need some help calculating the average of 5 feilds . But i want it to calculate the average based on feilds greater than zero. EG. In a table u have feild Name stax btax ctax Tom 50 55 31...

Nope. Not really. What are u suggesting?

I am creating a query template but im faced with getting duplicates for some records. Eg. I have T1 and T2 Left joined by common feild id T1 T2 Name id Name id type Ford 022 Ford 022 Suv Benz 025 Ford ltd 022 Suv Benz 025 sedan So when i join these two tables...

where do you find this option in design view

Hi all. A query i am running giving me duplicates for some records. For those particular rows that are duplicated, has the exact feilds with the same data as the one above it. But it only occurs with some records

Hi all. Is it possible to add a feild in a module and specify what u want the value to be. EG. If there are 5 rows of data being imported. I would like to add a new feild to these 5 records storing (eg) '341' for all 5 records. I pasted my code below so u could advice me what to do if it is...

How do i get rid of this annoying error. Nothing is wrong with the code. It came up cas i tried to import more that access could handle. I broke the connection, close the application and deleted the entries in the tables but the error still persist when i run the macro

This function does what i need. Thanks much

i am using the find unmatched query wizard to create to do some coparisons. However, a field i am camparing is represented as the end character of another feild [(eg) staff charges 10]. I want to compare the 10 from that cell to another table that conatains a feild with all these values. eg...

DoCmd.TransferText acImportFixed, "Account Master Export Specification", "Account Master", [FilePath]

Could anyone help me to reslove this error. This code been working fine with previous data i loaded just now so not sure why im getting an error when all data are in the same format. I pasted my code below Option Compare Database Dim DB As Database Dim GL As Recordset Dim SQLStatement As...