Query by entering data........

[jdt020471]

I have a single table with the following fields:

Drawing Number
Description
Product Name
Project Name
Originator
Origination Date

I want to be able to enter the project name or product name and perform a search on it. It then gives me the relevant drawing numbers and descriptions. By the way, what is the significance of the Primary Key?

I'm completely new to Access, hence my knowledge is very very sketchy.

Thanks in advance

Jeff

 

[ZmrAbdulla]

Primary Key is considered as Unique Record Identifier can be Autonumber or some text/numeric that gives a distinct identity to the record.
As a beginning point of query..
Just create a select query and in the critria grid(when you are in the design view of the query) of the query just type [Enter Project Name] and run the query; you will be prompted for the project number.

in the second step you can give the project number from a form.. tell us if you need assistance on this.

________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials

 

[jdt020471]

Thanks Zameer

How do I create a select query?

Jeff

 

[ZmrAbdulla]

So you need a beginner tutorial

http://www.functionx.com/access/index.htm

http://www.functionx.com/vb/index.htm

http://www.everythingaccess.com/tutorials.asp?

you will find a lot more if you check my site out.

________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials

 

[jdt020471]

Thanks Jameer,

I've got it now. Thanks for the links.

Can you use wildcards (* ?) in the criteria box?

Jeff

 

[ZmrAbdulla]

Change it to
Like [Enter Project Name] & "*"


________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials

 

[jdt020471]

Jameer,

Your the man!!!!!

Many thanks

Jeff

 

[ZmrAbdulla]

A bonus tip
Like "*" & [Enter Project Name] & "*" to search all that includes the search word.


________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials