Search results

  1. C

    Tail function

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

    DB freezing or closing when running query

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

    storing formula to use

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

    #Error throwing off calculation

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

    Calculating the avergae of 3 feilds

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

    help removing reps

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

    removing duplicates

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

    adding a new feild in a module

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

    run time error 3001

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

    comapring

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

    Run-time error '3001'

    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...
Back
Top Bottom