MS ACCESS - The problem of query

Question

I want to ask some question, which about that" Create a Query which accept two parameters,Restaurant and Category, and display results showing Branch, Category, Description, Date, Quantity, Price and Total Sales, where Total Sales is calculated as Quantity * Price.

How can I do that? Please help me,thanks

We'll need to know table structure.

JeffO
– JeffO

2010-09-12 19:58:26 +00:00
Commented Sep 12, 2010 at 19:58 — JeffO
– JeffO, Commented Sep 12, 2010 at 19:58
Sounds like a homework question to me.

KevenDenen
– KevenDenen

2010-09-13 16:55:24 +00:00
Commented Sep 13, 2010 at 16:55 — KevenDenen
– KevenDenen, Commented Sep 13, 2010 at 16:55

Fionnuala · Accepted Answer · 2010-09-12 22:41:29Z

2

You might like to read: http://support.microsoft.com/kb/304352

answered Sep 12, 2010 at 22:41

Fionnuala

91.5k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

infused Over a year ago

While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.

Fionnuala Over a year ago

@infused This is a link to a Microsoft page and the question is dated 2010.

btg_1967 · Accepted Answer · 2013-05-26 14:41:05Z

A couple of things that are needed to fully answer your qestion:

Version of MS Access
Table structure

But with that said, the item you are looking for is accessible in the Query By Example (QBE) grid.

Unless you are doing somethign very tricky with the data types, then you can just type the name of your 'variable' in the Where section of the grid in the column of the field that you wish to be applying the criteria to:

[*parameter*]

When you run the query, this will cause a pop up window to display that you can put your parameter into and hey presto - all solved.

As mentioned above, you should also read the KB article referenced. You can also use standard form syntax to link the parameter to a form field.

*formname.fieldname*

Collectives™ on Stack Overflow

MS ACCESS - The problem of query

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related