Populate Field from Query

[Ajwebb]

Hi All,

I have a query and one of the fields is called DateOfExport.

I was wondering if it is possible that when i run the query if it is possible to populate the field with the current date.

Thanks in Advance

Anthony

 

[SQLBI]

Anthony,

Can you provide a little more info on this, your SQL statement would be useful.



Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[Ajwebb]

Hi Leigh,

The only SQL i have is when i go into SQL View of my query and it is as follows.

SELECT [Learning Activity Dataset].UNIQUEID, [Learning Activity Dataset].LEARN_ID, [Learning Activity Dataset].PROVI_ID, [Learning Activity Dataset].LPROG_ID, Format([lacti_id],"00&quot AS LACTI_ID1, [Learning Activity Dataset].LAIM_REF, [Learning Activity Dataset].[Export_Date]
FROM [Learning Activity Dataset];

My field Export_Date is bound to my table [Learning Activity Dataset].


Regards

Ant