Parameters problem in queries

[Fern2408]

Hi everyone

I have no probelm if I set 1 parameter in a query but if I use 2 parameters even though the box appears and I type something in (there is data in the table that it should choose) it does not recognise the second parameter.

I'm new to access but I've looked in the SQL and it seems to read ok to me it has and inbetwwen the 2 parameters.

Thanks

 

[John Big Booty]

Perhaps you should be using the Or operator rather than the And operator? Bit hard to tell without seeing the nature of your query.

 

[Fern2408]

Query is bring together information from 2 tables. I want to only show info with a particular part number (first parameter) and then filter this further so I only see a particular operation number for this part number. It seems to ignor the second parameter both of these are with 1 table.

 

[John Big Booty]

Are you able to post a copy of your DB?

 

[Fern2408]

I cant upload yet as I have not been a members long enough it says something about changing my database to a zip file sorry dont know how to do that.

Regards

 

[John Big Booty]

Did you even read the link I posted in my previous post :banghead: If you had have you would have seen that you need do is zip you DB and upload that

 

[Fern2408]

Yes I did bother to read your post as I said I am very new to access and also this is the first and last time I have used a forum.

BYE