Thanks for all your help everyone.

Got the query to function properly by declaring a variable and building the string based on values passed to the procedure.

But the answers have...

Mike

Thanks for the reply. I thought about doing it this way, but thought there might be a more efficient way of doing it in the Where clause somehow.

Something along...

I have went with the following SQL code from the first reply by Michael Du Bois:

CREATE PROCEDURE spGetDocuments

@DateFrom datetime,

@DateTo datetime,

AS

Declare @AddedDateTo datetime

Set @AddedDateTo= DateAdd(DD,+1,@DateTo)

SELECT RecID, Desc

FROM tblFiles

WHERE CTimeStamp BETWEEN '...

Thanks for all the replies so far, but in reply to the post asking why I am converting, I get the following error "Syntax error converting datetime from character string."...

Thank you both for your help.

As always with this forum, the help has been spot on.

All, thanks for your help. As always in this forum, the help is spot on and replies are lightning fast.

Keep up the good work.

Brendan

Remi

Thanks for the amazing quick reply. Your solution was exactly what I needed.

Cheers

Brendan

Hi

Thanks again for all your help. Have taken Philips advice and coded so that the date format sent to the database is of the format MMM DD YYYY. All seems...

Thanks for the quick reply. Will try to code your solution, just thought it might be easier to change a setting on the database.

Sending dates from web apps to databases...

Dinakar

Thanks for all your help. I will give this a try.

Brendan

Hi

Instead of the following record being returned:

AgendaID = 1

AgendaItem = "Make cuppa"

ProposedBy = 1

SecondedBy = 2

I would like it to return:

AgendaID = 1

AgendaItem = "Make cuppa"

ProposedBy = "John Doe"

SecondedBy =...

TblContacts:

ContactID - Primary Key

FullName - text field

Company - text field

Address - text field

tblAgenda

AgendaID - Primary Key

AgendaItem - Text field

ProposedBy - Numeric field linking to ContactID of tblContacts

SecondedBy - Numeric field...

Hi

Thanks to all for your help. I have managed to take something from each reply to get the problem sorted.

Brendan

Have made a seperate table which now links the section to the Contact, but

am now having trouble inserting into this table using SQL. The code I have

(simplified) is:

Declare @ContactID...

Thanks for all the help. The code works perfectly!

Brendan