Search results for query: *

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?

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

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

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

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

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

Hi, I am a self taught novice at access 2003 and need some help formating a function in a query. I have this function that is testing for certain criteria in my query 1490-2Q%: IIf([split]=-1 And [accounttype]="payroll" And...

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

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

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

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

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

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

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

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

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

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

Thanks Duane, that was actually painless - Todd

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

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