Search results

thanks datAdrenaline:). It ran fine with that DB. I tried it on another with pretty much the same data. But mismatch error came again. COuld you tell me if i applied u approach correctly. Original Code---------- SELECT fidelityReport.*, ecislandscif.MERCHCIF INTO fidelityAll FROM...

i tried it with the clng function and it didnt run. Could you post your version

The problem with the TOP idea is that the pin varies with characters. I attached the DB. The Query name is cifLink SELECT DISTINCT AnguillaFdms.*, ECIslandsCif.MERCHCIF INTO Everyhitng FROM AnguillaFdms LEFT JOIN ECIslandsCif ON AnguillaFdms.MerchantNumber = ECIslandsCif.MERNBR; So...

I tried attaching the file but i am getting a DB error from the forum. The file is within the size limit. Should the Clng function be only used on Int datatype or it works fine with text ?

thanks for the reply, i recieved a type mismatch error. The pin numbers are set to text in the database

Hey all. Can i use the tail function in a join statement. If so How? I am having this issue cas the pin# in Student table is 0234 while in yearReport it is 234. So if it possible to compare the tail in the code below would help me alot. Select Student.studentID, yearReport.* INTO studentAll...

Hey guys, i did my reading. The question is, how should i apply it to my DB? Its hard to make the feilds i use to connect the table primary keys because there are instances where more than one entry contain the same link feild (merchantName or MerchCif). Could you all give me some heads up on...

Waw. Compacting it reallt does cut down the size considerably. How this BD operates is that i load in data to fdReport 2. Link it to 2 feilds in another table and create a table called "everthing" from the query 3. "Query1" then does some calculation on table "everthing" 4. "Query2" then does...

i will read the info on those links. I tried attaching the file but it too big. Even when i zip it, its still 3500kb

Is my database split ? Not sure what u mean by that Have i compacted the database ? Not sure i know how to Could you explain please even though i am thinking its the query thats causing the problem You want me to post the query or the DB?

Hey Everybody, My DB been running fine until i added a few new queries. It either closes the DB or take a long time that u would take probably a week. My DB pretty basic. 7 Tables, 26 Queries, 30000kb. It behaves like this when i run the query to create a table report. As i said, The create...

Its working like a charm now guys. I made sub-queries, and linked them back in the main query :) Thanks again

I didnt want to resort to changing feild names cas that would be a huge job to rename feilds everytime data is loaded. Would it help if i posted the sql code ??

This is the code below. The 2 parts is what I want to store somewhere else to be used so this query wont be so long.So I would end up with something like (NewTableorQuery)*.42 + (NewTableorQuery2)*.1*.1*.1 when making the reference (Iif(([Query2]![AvgOfDRE YTD AVG SALE Int]+...

Hi All I have an Issue where my query is too long as I am prompted with "The string returned by the builder was too long". So is there a way i could store a formula that is 770 characters and refer to that formula in next query to cut down on characters in the main query.

:D Good to go.Thanks alot

Yea, i agree u cant divide 0/0. But that result added to a figure should return that figure. (0/0) + 8 = 8. Does any 1 have any experience with the NullToZero function. I tried it in my query but it not working ?

Hi all. I get a #Error even when my formula boils down to eg... ((A-B) + (C/D)) * .10 Where C and D = 0. A= 30, B=4 I really want the output to be 2.6 Tell me if i need to post my formula

Re: Calculating the avergae of 3 feilds (Answered) Thanks a Mil TownDawg. You da man :D Works just fine.

It actually did work when i deleted the zero from the feild that was null :). The set of data im working on contains alot of records which means there will be alot of zeros. Can this be coded to not treat the zero as part of the calculation ??:confused: