473,326 Members | 2,048 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

converting multiple field data into a scholarship amount

I have a table I use to enter student data and would like my users to
see a student's scholarship amount based on the data they enter into
the following fields:

[FYear/Tsfr] - "First Year" or "Transfer"
[PT/FT] - "part-time" or "full-time"
[HSGPA] - high school GPA on a four point scale (ex. 3.52)
[SATsum] - (ex 1160)
[RSTATUS] - "resident" or "non-resident"

Only full-time students are eligible for a scholarship/award. We have
a scholarship matrix based on the data above, but right now my users
eyeball the correct award amount based on the data they have.

I started to type in an expression, but it was too long. An example or
what I enterred is: IIf([F Year/Tsfr]="First Year" And
[RSTATUS]="resident" And [PT/FT]="full-time" And [HSGPA] Between 3 And
3.24 And [SATsum] Between 800 And 890 Or [ACT Composite] Between 17 And
18,3000). The problem is there are about 50-60 other If statements I
would have to enter.

How else can I display the scholarship/award data besides with an
expression? My knowledge of VB is very basic. Please help.

Nov 13 '05 #1
1 1372
Its only a thought, but a couple of things spring to mind.

Firstly avoid having spaces in your field names. ed F Year/Tsfr and ACT
Composit. You have to put square brackets round them and that makes things
look more complicated than they are.
I would also avoid slashes. They look too muck like a division sign.
I guess, probably wrongly, that a number of fields are Boolean (True or
false) like FullTime - if FullTime is true the student is full time, if
FullTime is false then the student is part time. Same probably applies to
Transfer and ResidentStatus.
Trying to type something like IIf([F Year/Tsfr]="First Year" .... May return
a true statement, but a slip in typing to IIf([F Year/Tsfr]="First Yare"
will always return a false statement. Much safer is IIf(Transfer = True)....

I am not sure where you are trying to type this massive IIf clause, but it
may pay you you set the information up on a form and then use filter by form

HTH

Phil
"oneillb" <on*****@chc.edu> wrote in message
news:11*********************@c13g2000cwb.googlegro ups.com...
I have a table I use to enter student data and would like my users to
see a student's scholarship amount based on the data they enter into
the following fields:

[FYear/Tsfr] - "First Year" or "Transfer"
[PT/FT] - "part-time" or "full-time"
[HSGPA] - high school GPA on a four point scale (ex. 3.52)
[SATsum] - (ex 1160)
[RSTATUS] - "resident" or "non-resident"

Only full-time students are eligible for a scholarship/award. We have
a scholarship matrix based on the data above, but right now my users
eyeball the correct award amount based on the data they have.

I started to type in an expression, but it was too long. An example or
what I enterred is: IIf([F Year/Tsfr]="First Year" And
[RSTATUS]="resident" And [PT/FT]="full-time" And [HSGPA] Between 3 And
3.24 And [SATsum] Between 800 And 890 Or [ACT Composite] Between 17 And
18,3000). The problem is there are about 50-60 other If statements I
would have to enter.

How else can I display the scholarship/award data besides with an
expression? My knowledge of VB is very basic. Please help.

Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: JMCN | last post by:
i am running into problems with is the recordset. i have exactly 104 records. when i tested the code, the end result was multiple records for the same loan(ET LN Shortname). where did i go wrong? ...
1
by: Jon | last post by:
I have a field called "Amount". In it, there may be values populated that are either in £ or $. I want another field, called "ConvertedAmount" that will store the value in dollars. If Amount...
3
by: Parvesh | last post by:
hi, I am using a webservice which Returns the Result in an XML string, The XML response i get i svery cumbersome to parse, But if i could convert it to the Corresponding Class using the...
13
by: ricky.agrawal | last post by:
I'm really not sure how to go about this in Access. What I've created is a table for each location. Those tables are identical in format but different in information. The tables are named after...
59
by: Rico | last post by:
Hello, I have an application that I'm converting to Access 2003 and SQL Server 2005 Express. The application uses extensive use of DAO and the SEEK method on indexes. I'm having an issue when...
5
by: c676228 | last post by:
Hi everyone, my colleagues are thinking about have three insurance plans on one asp page: I simplify the plan as follow: text box:number of people plan1 plan2 plan3
1
by: abprules | last post by:
Can somebody help me with this scenario? I want to update a date field when another field has a certain value entered. It is something like this: When the PDetType field ( from tlkpERegStatus...
5
by: Patti | last post by:
I am struggling with converting a certain varchar column into an int. I have a table that has 2 fields - one field holds the loan number and the other field holds the codes associated with that...
11
by: shriil | last post by:
Hi I have this database that calculates and stores the incentive amount earned by employees of a particular department. Each record is entered by entering the Date, Shift (morn, eve, or night)...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.