Unable to update records on query

[Costefran]

Can anyone help

I am running a a number of queries on one table and cannot update the records

To explain
I have a table with a number of fields 2 of which are start date and end date

The using enters a start and end date on a form and the query is designed to pick up any record start dates or end dates that fall between the two dates set by the user on the form so I have one query where

the parameters for my table start date are
>= Form start date and <= Form end date

the parameters for my table end date are
<=Form end date and >= Form Start Date

I then run a union query to join then and the results are not updatable

I am trying to work out another way to run the query but haven't thought of one yet so any help would be appreciated

 

[dhookom]

Union queries are not updatable. You will need to identify another solution.

Duane
Hook'D on Access
MS Access MVP

 

[Andrzejek]

Aren't these queries the same;

the parameters for my table start date are
[blue]>= Form start date[/blue] and [green]<= Form end date
[/green]
the parameters for my table end date are
[green]<=Form end date[/green] and [blue]>= Form Start Date[/blue]

???

You could just use:

WHERE MyDateField BETWEEN Start Date AND End Date

In my opinion it is a lot easier to read.

Have fun.

---- Andy

 

[Costefran]

Many thanks for your help

Will keep trying