Sorry, for some reason, it didn't paste, hope this is nearer to what you want to achieve

Select E.EventNumber, E.ArrangementNumber,  F.FY,F.Period,F.StartDate,F.Enddate from

(Select Eventnumber,Min(StartDate) as MSD,ArrangementNumber from  events

 Group By EventNumber, Arrangementnumber) E

inner...

Hi,

Try this

Select distinct  Financial_Periods.Period from

(Select Min(StartDate),ArrangementNumber from  events

inner join  Financial_Periods on '||ThisDate||'

between  Financial_Periods.StartDate and  Financial_Periods.EndDate

If you can guarantee that the values will fall within the same day, then you could try

select Convert(varchar(5),Cast('2005-05-16 16:02:33.347' as datetime)- Cast('2005-05-17 09:23:30.813'as datetime),108)

Hi,

Try replacing the CHAR(13) with a CHAR(13) + CHAR(10)

Check out this link

http://support.microsoft.com/default.aspx?scid=kb;en-us;208295

You say all the computers have the same front end, do you mean they all access a common front end from a network drive, or is it just each machine...

A quick way to get this is to use sp_columns, and then copy the size column into excel

Try this link for an introduction to storing and retrieving images from SQL Server using C#

http://www.c-sharpcorner.com/Code/2002/Feb/FlashCardsMG.asp

CurrentProject.Name will return the name of the file, or if you have given the application a title in the startup dialog box then

currentproject.Properties("AppTitle") will return this

If it is the command that is timing out, then try increasing the command timeout property

Hi,

The error you are getting is due to the fact that you are trying to delete the field from an open recordset which is something that you cannot do, hence...

Hi,

You need to make the changes to the table on the server, then refresh the link in the access database.

If you want to be able to edit the actual tables,...

CopyFromRecordset does not take out any headings into Excel, so you have 2 options,

1. Use a template with the column headings predefined

2. Loop through the fields collection of the...

Try this

Delete from TransactionRequests

Where DateDiff(hh,getdate(),datein)>48

AND Completed = 1

Looks like I was beaten to it by mkeast, but for what it's worth here's my version

CREATE FUNCTION dbo.Translate (@source varChar(8000),@replaceRequired varChar(200),@replaceWith varChar(10))

RETURNS varchar(8000) AS 

BEGIN

 declare @i int

 declare @checkLen...