<div>
can you provide an example?
</div>


Wonderwall99

<div>
Okay, I think the quotes did the trick. &nbsp;Thank you!
</div>


Okay, I think the quotes did the trick.  Thank you!

<div>
<div class="content wysiwyg-content">
Hi, in the select query I created, everytime I input a number in Criteria, Access automatically puts brackets around the number and forces me to input a parameter value. &nbsp;The table the query is built off of shows Numeric for this field. &nbsp;Any way to fix this? &nbsp;I won't be able to upload the database for data sensitivity reasons.
</div>
</div>


Hi, in the select query I created, everytime I input a number in Criteria, Access automatically puts brackets around the number and forces me to input a parameter value.  The table the query is built off of shows Numeric for this field.  Any way to fix this?  I won't be able to upload the database for data sensitivity reasons.

Access forcing brackets around Criteria value

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.