Access query with Criteria

[maabbas]

Hello Everyone,

I have a tblProduct which has following columns
ProductCode
ProductDesc
CaseWeight

there are some caseweight does not have specific weights and I am using "1" in table , please see below. is there any way in the query I can add criteria when the caseweight =1 then ask user to input, otherwise use the caseweight in the table.

Thanks in advance

Code	Description	CaseWeight
104429	ABC	40
104594	EFG	1

<caption> tblProduct </caption><thead>
</thead><tbody>
</tbody><tfoot></tfoot>

 

[bobsan42]

firstly - I wouldn't use 1's. I would prefer 0, Null (empty cell), or -1 (or any negative number).
I don't know how you can use a query to ask the user for such input.
What you could do is use an UserForm and ask the user to provide input for any of the records in the recordsset.
You can use something like this for the form's RecordSource:

SELECT * FROM tblProduct WHERE CaseWeight = 1

(hopefully the caseweight field is of Number type)

 

[maabbas]

firstly - I wouldn't use 1's. I would prefer 0, Null (empty cell), or -1 (or any negative number).
I don't know how you can use a query to ask the user for such input.
What you could do is use an UserForm and ask the user to provide input for any of the records in the recordsset.
You can use something like this for the form's RecordSource:

SELECT * FROM tblProduct WHERE CaseWeight = 1

(hopefully the caseweight field is of Number type)

Thanks bobsan, I forget to mention I made a form from that query, where user will enter data.