design view need to see the dates and Number after I enter a specific number

[TheSpecialist]

Hello,

I created a parameter to be able to enter a number in design view. In my table, I have dates field and a field called numbers. In m parameter, I enter the number 439
It pulls all the times 439 comes out associated with the date the number it came on this is great. However, I now want it to see the number that came 2 days before this numer date and 2 days after this number date



Example I enter 439 and it came on 10/1/2000, 1/2/2006. I want to also see the numbers that came on 2 days before and after these dates as well. I have been away for awhile on duty so my access skills are not the best.

enter 439 it came on 10/1/2000 and 1/2/2006
what number came on 9/30/2000 and 12/31/2005 once i put the number i want to see when i enter 439 in the paramter. Whatever number i enter I want to see what came 2 days before and two days after


Thank you in advance

[orange]

It sounds like you are dealing directly with a table??

I suggest you create a query but we should see your table design before making guesses.
Perhaps you could show us the table design, and a few records.

[TheSpecialist]

DTE	3 digits
11-Jun-17	675
10-Jun-17	405
09-Jun-17	228
08-Jun-17	064
07-Jun-17	022
06-Jun-17	701

[TheSpecialist]

example If I put in 675 when I run the query I want to see the numbers and the dates that came 2days before and 3 days after so I would like to see what came on june 10 and 9.

DTE	3 digits
11-Jun-17	675
10-Jun-17	405
09-Jun-17	228
08-Jun-17	064
07-Jun-17	022
06-Jun-17	701

[orange]

I understand 2 days before 9-Jun-17 and 10-Jun-17.
But ?? What comes 3 days after 11-Jun-17 in your table??

[TheSpecialist]

12-Jun-17 198
13-Jun-17 657
14-Jun-17 259

[orange]

Where did these come from???
If they are in the table, you might have included those in the last post.

[TheSpecialist]

It was from a table
I just need to be able to pull te number from a number I enter

[aytee111]

This would be two queries:
- query 1 - pull in the date for the number you have entered
- query 2 - bring in query 1 and the table, do not join them. Select all records from the table where the date is
Between query1.date - 2 AND query1.date + 3

[aytee111]

A better way to do this is to have a main form where you select the number and filter on that so that the date is displayed in a textbox on the form. Then create a subform to display the records with the date criteria mentioned above, with the query referencing the date field on the form instead of using query 1.

[TheSpecialist]

aytee111,

I sent you a private message