Search results

Is there a way to specify the value of "N"? For example, if a prior query finds all the records in one region and there are 47 records. Could that 47 be automatically input as "N" for the following query?

To clarify: I may have 47 records or I may have 357 from each region. The purpose of the queries is to automate the procedure so clerical staff can run it and won't have to provide a value for N.

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...

SQL code SELECT IIf(Len([1b_Import BOM]![Material])<8,IIf(Left([1b_Import BOM]![Material],1)<>9,Null,[1b_Import BOM]![Material]),IIf(Left([1b_Import BOM]![Material],1)=1,[1b_Import BOM]![Material],IIf(Left([1b_Import BOM]![Material],1)=2,[1b_Import BOM]![Material],IIf(Left([1b_Import...

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...