Search results

I am trying to write queries that pull the top 25 and bottom 25 records for each of four regions. This can be easily done using a Top N query. My problem is that when there are fewer than 50 records in a region my boss wants to see them grouped together (eg Top 47), and the bottom 25 query would...

I inherited a db that uses a series of make table queries. Yesterday, when I went to run the queries I received the error message, "You can't delete table [ ]; it is participating in one or more relationships". Can anyone tell me what the error is, how to fix it, why it just started? Thanks, Len

I haven't used Access in a few years and am trying to replace an Excel spreadsheet with Access. One field in Excel looks at the prior record, if they are the same it doesn't update the current record. The excel command is: If($Y3 = $Y2, 0, sumif($y:$Y, $Y3, G:G)). Is there any easy way to...