access parameter query, how to create a parameter query for access

Write :

like "*1*" and like "*2*" and like "*3*"

In addition, add a field Parameter Length: len([Parameter]) condition to write:

If it's a number from 0-9:

select Table 1Data, len([data]) as Data length from Table 1 where ((Table 1.)data) like"*"& left([function],1) &"*"and (Table 1.)

data) like"*"& right(left([function],2),1) &"*"and (Table 1.)data) like"*"& right([function],1) &"*") and ((len([data]))=3));

Write :

Please enter a score].

Try running a query.

When executing this query, the system will first convert this condition to:

Student Table].[Score] > [Please enter a score].

Since there is no field to enter the score, the system will prompt you to assign a value to this field. A dialog box will pop up asking you to enter a score. This is called a parameter query.

How it works:

Open the access database on your computer and click the "Create" button on the menu bar. Before that, you need to add the table that you want to query to the database.

After that, click the "Query Design" button of the query module, and a ** selection window will pop up.

Select the ** that needs to be queried, and then click the "Add" button, and then click "Close" or the close button in the upper right corner when the table to be queried is already displayed on the screen.

Drag and drop each field in the table to the "Fields" column below, click and select it with the mouse, and then drag it directly.

In the "Condition" column below, enter the parameter that needs to be queried, for example, in the following figure: if the search parameter is a name, enter "Please enter a name".

After entering the parameters, click the "Save" button in the menu bar, enter the name of the query, and click "OK", and the query will be saved.

Click the "Run" button, and the input box for the parameter query will pop up.

Enter the content you want to query in the field of the parameter to be selected, and the information in the corresponding ** will be displayed.

Summary. 1.Click on the menu bar above: Create - query design.

2.In the Show Table dialog box that appears, click Basic Student Information, and then click Add.

3.In this dialog box, drag and drop the field to the ** below.

4.In the Criteria for Student Name line, enter [Please enter Student Name:].

5.Click the Save button above the menu bar.

6.A dialog box pops up, enter a name for your query here and click the OK button.

7.Click the Run button at the top of the menu bar to check the operation.

8.A dialog box pops up for parameter input, where you enter a student's name so you can find out about that student.

How to query the access parameter.

1.Click on the menu bar above: Create - query design.

2.In the Show Table dialog box that appears, click Basic Student Information, and then click Add. 3.

In this dialog box, drag and drop the field to the ** below. 4.In the Criteria for Student Name line, enter [Please enter Student Name:].

5.Click the Save button above the menu bar.

6.A dialog box pops up, enter a name for your query here and click the OK button. 7.

Click the Run button at the top of the menu bar to check the operation. 8.A dialog box pops up for parameter input, where you enter a student's name so you can find out about that student.

** Send you to see obviously.

Access queries are divided into the following categories according to their functions:

1.Select Query Select....

2.Update query update....

3.Insert query insert....

4.Delete the query delete....

and generate a table query select .into...crosstab queries, etc.

Parameter queries do not belong to the above categories, if the above queries use parameters to perform multiple queries with different values, then they are considered parameter queries, so the parametric queries can be any of the above.

For example: select * from student table where name='Zhang San'

delete * from cargo table where classify ='Fruits'

The above is to select the query and delete the query, if you want to query the student named Li Si next time, or if you want to delete the dim sum classification, you need to rebuild or modify the above query, which is more troublesome when you use it repeatedly.

So it's more convenient to change to a parameter query (x is a parameter):

select * from student table where name=xdelete * from cargo table where class=x In this way, when executing a parameter query, you only need to enter the value of the parameter when prompted.

By passing parameters to the "query" of access, you can use ADO data to access objects.

Here's an example of using Access VBA:

students table.

id name

1 card three. 2 Li Si.

Create a query with a parameter called "paramtest", sql** as follows: parameters sname text ( 50 );

select *

from students

where name=sname;

Now demonstrate the use of the parameter sname, find the information of Li Si, create a new access form, and add a command button private sub command1 click()dim rs as new

aduseclient

paramtest 'Li Si'",msgbox rs!name

end sub

Click the command button and you will see "Li Si" in the pop-up message box

Note: The method of passing parameters is to fill in the parameter value format after the query name space Query Name Parameter 1, Parameter 2, .,Parameter n Note: Don't make a mistake about the order of the parameters.

The principle is the same for other programming tools.

Suppose Table 1 contains fields such as ID, name, place of origin, and gender, and perform a summary query based on Table 1

1) Select Table 1 in the query design view and click the Summary button.

2) Add the home and ID fields, and change the total method of the ID field to count. The ID field names summarized by count will be automatically named "Count of IDs".

3) Customize the field name. Enter "Quantity:" before the id. Use a colon in English.

Hello, glad to answer for you. 1. First open our database file.

2. To create a query, of course, you have to click "Query" on the left side, here we can double-click "Create Query in Design View".

3. Add the table we need in the "Show Table" window. Here you need to query the course number CNO, course name CNAME, and the average grade of students, so you can add table C and SC table here. When the addition is complete, click the Close button to close the Show Table window.

4. The tables of the relational database should not be isolated, but should be correlated. If you find the same field in two tables and drag the field from one table to the field in the other table, you will find that there is a line in between, which means that the two tables have been linked.

5. Double-click the field we want to query from the table, which means that we want to output the field to view, and there are 3 fields output here.