Existing Access Database lookup

[rbhazie]

So I have an existing database that we use to input our computer cables that we install and number.
I want to make a form or something that I can use to extract a group of numbers.
Ex: I need a cable report for numbers 5000 to 5020 and all of the info that goes with numbers.
I want to make something that I can just key in the numbers that I need and then have access spit out the report.


Is there an easy way to do this?

[Micron]

You could try a parameter query and if successful, make a form based on it. However, I don't know if a parameter query will accept multiple inputs (e.g. IN([input 1], [Input 2],...) and even if it does, it may not produce any results if one parameter is dismissed.

When multiple inputs are involved, it's common to loop through the selected items property of multi select listbox and build sql in code from that, then base the records on the sql statement by setting a form recordsource to that sql.

[orange]

We don't know the design of your table(s). So if you could post your table design(s) and any relationships you have, it would help readers. I agree with micron re multi select listbox, but we really need to know little more about the database.
Yes a parameter query can take multiple parameters.

[Micron]

Multiple parameters using IN clause? Usually it's done as 1 per field but I don't think I have ever tried several in 1 field using IN.

[orange]

My response was with respect to multiple parameters generally--Not specific to the IN operator.

However:

These parameter queries work in my testing.

1:

PARAMETERS P1 Text ( 255 ), P2 Text ( 255 );
SELECT animal.[AName], *
FROM animal
WHERE Left(animal.[AName],1 ) In ([P1],[P2]);

2:

PARAMETERS P1 Text ( 255 ), P2 Text ( 255 );
SELECT animal.[AName], *
FROM animal
WHERE (((animal.[AName]) In ([P1],[P2])));

Result of 1: with the attached table, using P1 = J, P2 = S

AName	AnimalId
Spot	1
Jim	2
Sam	3
Johnny	7

[CJ_London]

you can also try this variation

PARAMETERS Enternumbers Text ( 255 )
SELECT *
FROM tblCables
WHERE Eval(cableNum & " In (" & [Enternumbers] & ")")

for enternumbers you would enter numbers separated by a comma

5000,5001,5002

but you do say

need a cable report for numbers 5000 to 5020

in which case rather than typing 100 characters your query would be

PARAMETERS FromNum Long, ToNum Long;
SELECT *
FROM tblCables
WHERE cableNum BETWEEN FromNum and ToNum

and you have only entered 8 characters

and as you can see has very different parameters and criteria

you might want to consider using vba and build your criteria in code so you could enter something like

5000,5003,5010-5020

i.e split the string on commas then split each element on -and treat accordingly

[rbhazie]

I have been trying to post a pic of my Cable Form to input date. What I would like to do if possible
is to have a "Form" that I can input the umbers I need to report on and then have the report in excel

[CJ_London]

you have had some suggestions - why don't they work for you?

regards a picture of the form, upload by all means but of more relevance would be the tables and relationships - and try zipping your file/s and upload the zip

[rbhazie]

I am not that fluent in access. The suggestions are great, I just don't know how to implement them.