query between 2 dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following query
SELECT NFind.BId, NFind.NTCCY, NFind.NTFs, NFind.NTDueDate, [F Type].Type
FROM NFind INNER JOIN [F Type] ON NFind.TypeId = [F Type].TypeId
WHERE (((NFind.NTDueDate) Between [Enter date] And [Enter date]));

however the query is not allowing me to enter the second date
Any suggestions, help would be greatly appreciated
 
You need to specify a different name as the parameter, either wise it will
use the same parameter and this is why you been prompt only once

Try
SELECT NFind.BId, NFind.NTCCY, NFind.NTFs, NFind.NTDueDate, [F Type].Type
FROM NFind INNER JOIN [F Type] ON NFind.TypeId = [F Type].TypeId
WHERE (((NFind.NTDueDate) Between [Enter Start date] And [Enter End date]));
 
thank you
--
thanks as always for the help


Ofer Cohen said:
You need to specify a different name as the parameter, either wise it will
use the same parameter and this is why you been prompt only once

Try
SELECT NFind.BId, NFind.NTCCY, NFind.NTFs, NFind.NTDueDate, [F Type].Type
FROM NFind INNER JOIN [F Type] ON NFind.TypeId = [F Type].TypeId
WHERE (((NFind.NTDueDate) Between [Enter Start date] And [Enter End date]));
--
Good Luck
BS"D


jer said:
I have the following query
SELECT NFind.BId, NFind.NTCCY, NFind.NTFs, NFind.NTDueDate, [F Type].Type
FROM NFind INNER JOIN [F Type] ON NFind.TypeId = [F Type].TypeId
WHERE (((NFind.NTDueDate) Between [Enter date] And [Enter date]));

however the query is not allowing me to enter the second date
Any suggestions, help would be greatly appreciated
Click to expand...
Click to expand...
 
Back
Top