Check Field's Value in Record

[edisonl]

Hi, (Its going to get slighly lenghty below, My Apologies)

1) I have a form whereby I need to compare value input by user with values from 4 fileds in my table.

2) User supply 3 input : (a)Model of Bicycle, (b)Budget for New bicycle, (c)Budget for Used bicycle

3) System Perform following checks:
3.1) Check if Model Available (Done)
3.2) Check if budget input is within range (For Used & New)bicycle

4) I have 2 tables : table_bicycles_brand, table_BrandA
4.1)table_bicyclebrand (To Check if Bicycle Brand is available)
4.2)table_BrandA to Z(Different Brands) within which consist of different model with their individual costs.

5)table_BrandA fields (4)
5.1) UsedHighestCost, UsedLowestCost
5.2) NewHighestCost, UsedLowestCost

6)System requirement:
6.1)Based on User Input, compare with New Highest& NewLowest
,Used Highest & Used Lowest
6.2)To determine if their budget within range of Used & New Bicycle

7) How Can I do that? Extract Data out to do comparison ?

Sorry, for being lenghty.

Thanks (In Advance & God Bless)

 

[neileg]

3.1) Check if Model Available (Done)

You can avoid this step if you use a combo box that presents the user with available brands only.

4.2)table_BrandA to Z(Different Brands) within which consist of different model with their individual costs.

Not the way to do it. One table only with a field that holds the ID from table_bicyclebrand .

Use DMax() and DMin() to obtain the high/low values.

 

[KenHigg]

So to boil this down here's what I see:

You have a table where each record represents a bicycle you have in stock. Among other info it contains make, model, new or used, price, etc. So a customer calls and asks if you have a new or used bike of a certain model in a certain price range and you need to see if one exists in you table?

 

[edisonl]

Recordset ?

1) Yes Thats right, You summarise it for me what application should does.

2) Erm For Combo Box to check Model Through accomplished it.

3) Left the price portion though.

4) Is there anyway whereby I can use recordset function to retrieve the value of high new low new, high old and low old price so I can compare it progam-atically ?

Thanks & God Bless

 

[neileg]

Why use a recordset function? Use DMax() and DMin() to compare with your budget figures. Or alternatively, use the budget figures as criteria in a query and present the results in a subform.

 

[edisonl]

Erm, sorry not really knows how to go about using dmax() & dmin() though

 

[neileg]

Have you looked in Access Help?

What do you want to show in your form? Perhaps you want a list of all bicycles that are in budget? Or do you want to scroll through matching brand records and show whether they are in budget or not? Or something else?

 

[edisonl]

1)I settle it already, Basically I just did output to user accordingly if their budget is within range continue to next function
Else their budget lower/higher Reenter their input

2) Tried it with set rd as new ADO.recordset

3)Do a loop through, within by do loop, if found bicycle model> rd!UsedLow, rd!UsedHi...etc etc