Query Question

[carl]

I have this query...

UPDATE [OCC_Data] SET [OCC_Data].[date] 20110419
WHERE ((([OCC_Data].date)=0));

The query is used to populate the "date" field for each record that
has date=0 (the data source only has the data info in the header and I
discard this line when importing into Access.

Is there a way for the query to prompt me to enter the date ?

Or is there a way to use the header to populate the date field ?

Thank you in advance ?

 

[John Spencer]

UPDATE [OCC_Data]
SET [OCC_Data].[date] = [Enter Date]
WHERE [OCC_Data].date)=0

Assumption is that your Date field is a number of some type.


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County