parameter for my query help please

[TheSpecialist]

I want to create a parameter that once I enter the number for the shoe code lets say 901. I want my database to send me back that order code along with the order numbers that came 2 days before and 1 day after that order number. How can I create that parameter for my query



Thank you

[Micron]

You would have to substitute your own table and field names, since you didn't provide any...

SELECT tblOrders.ShoeCode, tblOrders.OrderCode, tblOrders.OrderDate FROM tblOrders WHERE (((tblOrders.OrderDate)= 
(SELECT tblOrders.OrderDate FROM tblOrders WHERE tblOrders.ShoeCode = 901)-2)) OR (((tblOrders.OrderDate)= 
(SELECT tblOrders.OrderDate FROM tblOrders WHERE tblOrders.ShoeCode = 901))) OR (((tblOrders.OrderDate)<= 
(SELECT tblOrders.OrderDate FROM tblOrders WHERE tblOrders.ShoeCode = 901)+1));

[TheSpecialist]

Mircon

This is my SQL statement from my table

SELECT TOP 5 MoonPhaseTable.YourDate, MoonPhaseTable.MoonPhaseNumber, MoonPhaseTable.MoonPhaseYourNumber, [All everything].YourTable, [All everything].[Cash3 table], [All everything].Cash4Table, [All everything].Cash4YourNumber, [All everything].GAFiveTable, [All everything].GAFiveYourNumber
FROM [All everything] INNER JOIN MoonPhaseTable ON [All everything].[YourDate 3 4 5] = MoonPhaseTable.YourDate
WHERE ((([All everything].[Cash3 table])=[Enter Number]));

[TheSpecialist]

Mircon

this is my SQl so far. I want to have a parameter that it will show me lets say if I enter 8 0 1 in my parameter for my cash3Table I want it to pull that date and the numbers and the date that came 2 days before that number and 1 day after that number along with the date as well. Thank you all for your assitance

SELECT TOP 5 MoonPhaseTable.YourDate, MoonPhaseTable.MoonPhaseNumber, MoonPhaseTable.MoonPhaseYourNumber, [All everything].YourTable, [All everything].[Cash3 table], [All everything].Cash4Table, [All everything].Cash4YourNumber, [All everything].GAFiveTable, [All everything].GAFiveYourNumber
FROM [All everything] INNER JOIN MoonPhaseTable ON [All everything].[YourDate 3 4 5] = MoonPhaseTable.YourDate
WHERE ((([All everything].[Cash3 table])=[Enter Number]));

[Micron]

I had to design a table, populate it and develop the sql statement to arrive at a solution that worked.
Apply the principle for that which I spent about an hour creating for shoe orders (since that's what you posted) to your new requirement. Sorry, but I'm not going to start over after providing a solution to what was requested.