how to used parameter query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

im new in this access. may i know how to used paramter?

As im doing a list of menu/set.
Each set have different items.
And each item have different cost

May i know how to do it?

Thanks and regards
 
Dear friend:

I'm sorry I cannot tell much about what you wish. In what other
language might we try to assist you?

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Hi Tom Ellison:

im currently writing a menu of food.
Like Benrto Set
In Benrto Set have various food
And each food have different price.

MAy i know how to put them together in one list?

Thanks and reagrds
 
Hi Tom Ellison

Im currently wirte a menu of food list.

Like Bento Set.
In Bento Set have various food.
It have different price in various foods.
May i know how to combine them into one?

Thanks and regards
 
Hi,


Make a table, as example, two fields:


Food Price



and, enter the data under each column, one ROW per different (food-price).



In a table, make a list control. Define, for this control, its row
source as:


SELECT Food, Price FROM tableName



If you want to display, in the list, only the records for a given food,
then, instead, try something like

SELECT Food, Price FROM tableName WHERE food=
Nz(FORMS!formName!ControlNameWithWantedFood, food)


(words written all in capital are reserved words to be typed exactly as they
are, other words are to be changed to match the names you supplied).



Hoping it may help,
Vanderghast, Access MVP
 
Hi,


Two corrections.
- I should have ask to make a list control in a FORM, not in a
TABLE.
- Nz( ) is a predefined VBA function (I didn't typed it ALL CAP, I
should, to be in agreement with the convention I mentioned that not all cap
words were to be modified to suit your design).


Vanderghast, Access MVP
 
In the design view, Put a ? in the criteria, then run the query and an input
windows will appear to prompt you to enter the parameter.
 
Back
Top