Multiple criteria for one field

[Guest]

Hello,

I have what I hope is a simple request but I am not sure on how to perform
it. I need to create a query with only two fields: Branch Number and Loan
Type.

I need to pull all the records for Branches 061, 02, 43, 88 and 33, I also
need to pull all Loan Type 1's. The loan type shouldn't be a problem but how
do I pull multiple branches in the criteria field in the query? Please
simplify answer as queries are not my strongest area of Access.

Thanks!!!

 

[Guest]

Try this --
SELECT YourTable.Branches, YourTable.YourFieldName
FROM YourTable
WHERE (((YourTable.Branches)="061" Or (YourTable.Branches)=" 02" Or
(YourTable.Branches)="43" Or (YourTable.Branches)="88" Or
(YourTable.Branches)="33") AND ((YourTable.YourFieldName)="Loan Type 1's"));

 

[George Nicholson]

In design view:
[Branch] criteria: In('061', '02', '43', '88', '33')
[LoanType] criteria: 1

The SQL should then include something like:
....WHERE (([Branch] In('061', '02', '43', '88', '33')) AND ([LoanType] =
1));

 

[Guest]

Hi Karl,

Worked like a gem, thank you!!!!

Try this --
SELECT YourTable.Branches, YourTable.YourFieldName
FROM YourTable
WHERE (((YourTable.Branches)="061" Or (YourTable.Branches)=" 02" Or
(YourTable.Branches)="43" Or (YourTable.Branches)="88" Or
(YourTable.Branches)="33") AND ((YourTable.YourFieldName)="Loan Type 1's"));

 

[Guest]

Excellent! Thank you very much for your help, I'll save this with my other
access instructions for future reference.

In design view:
[Branch] criteria: In('061', '02', '43', '88', '33')
[LoanType] criteria: 1

The SQL should then include something like:
....WHERE (([Branch] In('061', '02', '43', '88', '33')) AND ([LoanType] =
1));


--
HTH,
George

Hello,

I have what I hope is a simple request but I am not sure on how to perform
it. I need to create a query with only two fields: Branch Number and Loan
Type.

I need to pull all the records for Branches 061, 02, 43, 88 and 33, I also
need to pull all Loan Type 1's. The loan type shouldn't be a problem but
how
do I pull multiple branches in the criteria field in the query? Please
simplify answer as queries are not my strongest area of Access.

Thanks!!!