Search results

Why I didn't think of that I am not sure . . . . I guess you go so far down one track you loose sight of other (more simple) options. . . . Thank you Brian I'll give that a go!

Hi Brian, Yes that is exactly what I am planning to do. This doesn't happen too often (only when duplications have been made in error). A screen allows a record ID to be selected from a drop down in order to be deleted. When a button is pressed a macro instructs a delete query to remove the...

Hi John, Thanks so much for getting back to me so quickly. I can see the logic behind your example and would definitely use this approach in the future because I agree that storing a calculated filed isn't good practice. That said, I'm not sure that I can avoid it in this instance as so many...

Hi, I wonder if you can help? I have an update query which I would like to use in order to update a number of records in a table. I want to assign each applicable record a ranking based on the record start date; earliest dated record gets the lowest ranking, incrementing by one each time. . ...