Query with Parameter

[Guest]

Created a query that has a field with the expression
[Numbers]\4+1. Trying to create a parameter that says
Between [TypeBegin#]and [TypeEnd#]for users to type what
they need to see. However does not show correct records.
I tried adding a +0 at the end, which works when using 1
as the beginning number. Does not work with any other
beginning number. If I type in Begin at 2 and end with 6,
it will show all records from 2 on. Already checked
format & is correct. It will work when just typing in
Between # & #.

 

[[MVP] S.Clark]

A parameter query can not convert one parameter to another. So, the goal of
translating [TypeBegin#] and [TypeEnd#] to [Numbers] is not going to happen.

You can build a custom form to get the values and create the query.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-