Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ISTodd

    make table query data type conversion

    I get a synax error in FROM clause Ss I said my sql is not great.. could you perhaps tell me what to do with this?
  2. ISTodd

    make table query data type conversion

    Hi... SELECT student_info.id_number AS student_code, student_info.sch_code AS school_code, student_info.f_name AS first_name, student_info.l_name AS last_name, Left([m_name],1) AS middle_initial, IIf([ethnic]="1","5",IIf([ethnic]="2","4",IIf([ethnic]="3","2",IIf([ethnic]...
  3. ISTodd

    make table query data type conversion

    Hi - we have a student management database that has certain fields that need to be sent elsewhere (for testing and reporting information)- the data layouts require fields to be in a text file and set up differently. In the past we have always exported to excel and made hand corrections then...
  4. ISTodd

    make table query data type conversion

    Hi, I have a Make Table query that takes data from StudentTable. I need to change the datatype from text to integer in field [gender] where M=1 F=2 and change the data type from text to integer with no decimal points. I hope this is clear enough.. I am very new to Access and any help would...
  5. ISTodd

    Access string expression

    I am trying to establish a query with a calculated field to convert a number string to a format with seperators to represent a date- ie. I have field BirthDate =152000 representing the birth date 01/05/2000 any thoughts on how to convert the date with no leading "0" or "/"... To the needed...
  6. ISTodd

    FORMAT FUNCTION IN ACCESS QUERY

    What if i have multiple criteria? For example I ONLY want to multiply that field by .17 if ALL the criteria is met. [ACCOUNTTYPE]=PAYROLL [SPLIT]=-1 [expr2]=0 or unknown IF ALL the criteria is NOT met then I want the field to be multipled by [1490-2] AND FINALLY if [1490-2] is empty...
  7. ISTodd

    FORMAT FUNCTION IN ACCESS QUERY

    ...that is testing for certain criteria in my query 1490-2Q%: IIf([split]=-1 And [accounttype]="payroll" And [expr2]="unknown",[withdrawalamount]*0.17,[1490-2a]*[withdrawalamount]/100) this returns an figure whether the [split] field is -1 or 0 - AND I NEED THE SPLIT TO BE "-1" so I...
  8. ISTodd

    TABLE HELP

    I have a problem with a small financial database: I created a small database to manage a state program. There are several accounts in the program 14901, 14902, 14905, 14906. I have several employees. Durring payroll some employees are paid by different accounts. example: Tony may get paid...
  9. ISTodd

    Gradebook expression

    I have a gradebook database. I would like to DROP the lowest test grade in a particular subject (not necessarily all subjects). Is there an expression I could write on a report (possibly query) to give me the average of all tests (not including the lowest grade? Currently I have my average...
  10. ISTodd

    Many to many problem

    Richard, Thank you for your help regarding this issue. Your detailed instructions made it very easy to figure out my mistake. I intend to use your suggestions elsewhere in my database since I need help with (presentation). I still am having a problem with one part of this whole thing. I...
  11. ISTodd

    Many to many problem

    Hi Richard Thank you for your detailed response.... The 1st qustion question you asked was "What specifically is not working". The answer to that question is: After checking to make sure my tables are set-up the way you described and adding test information in the student and Assignment tables...
  12. ISTodd

    Many to many problem

    Hi I have two tables and I think the relationships are correct however things aren't happening the way I was hoping. I have three tables TblStudent StudentID PK LName FName TblStudentAssignment Score StudentID PK AssignmentID PK TblAssignment AssignmentID PK AssignmentDate...
  13. ISTodd

    Columns in footer only?

    I recognized that after I sent the last response... It worked great! Thanks for all your help with this - Todd
  14. ISTodd

    Columns in footer only?

    Hi Duane, 1. The Sub Report is referencing QryAnsBank: TblAnswer(*All fields), and TblQuestion (Question, Subject, Chapter, Lesson, Question) 2. No (Down then Across) 3. Yes 4. I made the sizes almost equal (sub report is slightly smaller) 13 Months:) Sounds like a a good holiday..... Thanks...
  15. ISTodd

    Columns in footer only?

    Hi Duane, Thanks for the help---- these are the table structures: tblQuestion QuestionId PK Subject Chapter Lesson Question tblAnswer AnswerId PK QuestionId FK CorrectAnswer (yes/no) IncludeAnswer (yes/no) The RptTestMultiChoi is linked to the child (RptAnswerBank) by (QuestionId) The...
  16. ISTodd

    Columns in footer only?

    I have two tables tblQuestion and tblAnswer. Since there could be several answers to one question (correct and incorrect) in a multiple choice test, I created a relationship that is many to one. Also, I tried a sub report placed in the footer consisting of answers to each question (which works...
  17. ISTodd

    Columns in footer only?

    Hi, I'm trying to use an Access database to make multiple choice and fill in the blank tests. Is there a way (to help save paper) to make columns in the footer only? IE. 1. _____What is the capital of California? A. Chicago C. Los Angeles B. Sacramento D. San Francisco...
  18. ISTodd

    counting records with "letters"?

    Thanks Duane, that was actually painless - Todd
  19. ISTodd

    counting records with "letters"?

    Is it possible to have access assign a letter (A, B, C) to records in a list over a group in the detail of a report? ie. Currently: 1 Asia 2 Africa 3 Europe Hoping for: A Asia B Africa C Europe Thanks for any help....
  20. ISTodd

    Table relationship question

    Hi, I am new to this so I hope I am clear with my question.... Every year my school gets testing info (achievement scores) from the state on a spreadsheet. There are about 70 fields including name, gender, school name, test score, etc... I was able to easily import one year's spreadsheet into...

Part and Inventory Search

Back
Top