Search results for query: *

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

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

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

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

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

Hi, I have a text box on a form that wont grow to fit text from a memo field. I have to be forgetting to do something (I changed the can grow property to "yes"... is there something else? Any help will be greatly appreciated. Todd

Hi, I have a small database that is replicated and shared. I have a missing reference on all computers with an XP operating system (the older system works ok), and they can't access certain records (I'm assuming because of this missing reference). Any idea on how to get around this? Thanks...

Hi, Is there an expression (or something easier) to change the format of a percent in a table and on a form or report? when I add "75" into a percent field it reads 7500% I want it to read 75%. Thanks for any elp on this... Todd

Hi, I have a database with several tables including tblStudent, tblTeacher, tblClasses. I have a query qryStuTeachClass containing tblStudent:StudId, StLastName, etc. tblTeacher: TeacherID, TeacherLastName, and RoomNumber tblContacts: ContactID, ContactDate, ContactTime, ContactMemo...

Hi, I'm rather new to this.... I have a standard class list printing from a query. Is there any way I can have the user define parameters based on [teacher name] and/or [grade] at one place on a form (list box)? Then having the option of the user printing that specific report? Thanks for...

I am using a Query as a (dde) data source for a Word document. I have an expression in my query to calculate a person's age from the birth date ..(Now()-[bdate])/365.25. the problem is that the age in the query is limited to 1 decimal place (which is what I want) but in the Word Document it has...

Hi - this may be easier than I think. I have a query from a table that contains student information. I want only one student per household in my report. Is there a way I can use the [Address1] field and print only one student per address in report use the [Student Id] or [Age] as a qualifier...

I have placed a combo box on a form that will "look up" and "retrieve" a record from a query. The problem I am having is that when I type a name with an aprostophe, I am recieving: Run-time error '3077': syntax error (missing operator) in exopression. When I click "DEBUG" I get this report...

I have a form for data entry on a new database that I'm testing. It is connected to a query (qryStdnt) and from (qryStdnt) to tblStudentInformation. When I add a record on my form it adds the record to the table, but it will not delete a record. I checked the properties of the form and it...

I have a simple database linked to an exel spreadsheet. I was printing reports (class lists) from it without a problem until today. Now I get an error message stating that data type mismatch in criteria expression. I can't think of where else to look for the problem... Any help would be...

Im importing a table from excel and I have a full name field set-up (for the most part) Smith, John there are occasional middle names Smith, John Edward Also there is the occasional Smith, J. Edward Any ideas on how to split this to 3 fields last, first, Middle Would it be easier to do...