Querry by primary key? is it possible?

[m_a4]

Hi,
I am just starting with access and dbs and already have a problem

i am working on a db for managings goods being retured

my db has particular tables:

GOOD
GUpc (PK)- unique product code
GDescription

PERSON
PReference (PK)
PName
PSurname
PTel
PMail

COMPANY
CReference (PK)
CName
CAddress
CTown
CPostcode
CCountry

RGA
RGAReference (PK)
CReference (FK)
PReference(FK)
GUpc(FK)
RGADate
RGASatus
RGACostOfRepair

I managed to get a query working so that i can search the PERSON table searched by surname

PARAMETERS [PSurname] Text ( 255 );
SELECT PERSON.PReference, PERSON.PName, PERSON.PSurname, PERSON.PTel, PERSON.PMail
FROM PERSON
WHERE (((PERSON.PSurname)=[PSurname]));

but i cant get it to work i wanted to search it by PReference

PARAMETERS [PReference] Text ( 255 );
SELECT PERSON.[PReference], PERSON.[PName], PERSON.[PSurname], PERSON.[PTel], PERSON.[PMail]
FROM PERSON INNER JOIN RGA ON PERSON.PReference=RGA.PReference
WHERE (((PERSON.PReference)=[PReference]));

I get a msg that The expression is typed incorectly or is to complex to be evaluated. For example a numeric expression my contain too many complecated elements. Try symplyfing the expression by assigning parts if the expression as variables.

AND THIS IS NO HELP FOR ME... francly

The same situation is with all the other tables- its possible (query- search) for everything apart for the primary keys.

I prepared a querry gathering data from all those tables. I managed to get it work with parameter like the one below with surname

PARAMETERS [PSurname] Text ( 255 );
SELECT COMPANY.*, RGA.*, PERSON.PName, PERSON.PSurname, COMPANY.CName, GOOD.GDescription
FROM PERSON INNER JOIN (GOOD INNER JOIN (COMPANY INNER JOIN RGA ON COMPANY.CReference = RGA.CReference) ON GOOD.GUpc = RGA.GUpc) ON PERSON.PReference = RGA.PReference
WHERE (((PERSON.PSurname)=[PSurname]));

but the same situation again, i cant get it to work if i want to get it for RGAReference, CReference, PReference,GUpc

I don't know what i am doing wrong?
have I designed it all wrong or is it just a small thing...

Thank you for all your help







My problems started when I tried to run a querry that will return the GDescription (this tables store data about 3000 products)

 

[Dennisk]

I suspect the reason your query selects by surname is the fact that surnames are text and you specify the surname parameter as text. If the key you are searching for is say an integer then the parameter should be an integer.

Normally I would provide a form to enter selection criteria then all you need to do is reference the form in the query criteria cell i.e. =Forms!yourCriteriaForm!YourControl.

 

[m_a4]

so true!
silly me!
thank you so so much!