DB problem from someone new to db

[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)

 

[Alisa]

Have you tried

WHERE (((PERSON.PReference)='[PReference]'));

?

 

[m_a4]

I did....
I get the same error msg....

 

[Alisa]

Is PReference a text field?

 

[m_a4]

PReference is an autonumber

 

[Alisa]

Then this:
PARAMETERS [PReference] Text ( 255 );
might be a problem . . .

 

[m_a4]

silly me

thank you so much for your help its working

 

[Alisa]

Sometimes all you need is an extra pair of eyes . . .