[MS_AccessPros] Form to enter date into more than one query.

 

I am using Access 2013.

I need the same date entered into two separate queries from a form.
The queries are used for data to a union query.

The date will become part of the 'Where' condition of the query.

WHERE (((ElectricityData.Date)>#4/8/2014#) AND
((ElectricityData.[CON/GEN])="Consumption"));

I have done this many years ago and not needed it since then. I have
forgotten the technique.

Many thanks,

Robin Chapple

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___