Search results

I developed a query which which searches for the closest value. I used dlookup() in the textbox to display that value. It is displaying however only the value of the very first entry, regardless of which record it is on. Textbox query in form: =DLookUp("[Aft1_query]![tbl_Aft1_...

Is it possible to create a query which selects selects fields in a table, not just data in a field? If so, how? TIA

Is it possible to use the count() function to count down a table and return that value i.e. a user first selects a table based upon a list box. The user then enters a number. That number would be used to count down in the table and return the value in the table that corresponds to that row.

I have a two dimensional array. Let's call the column header PaxFwd and the row header PaxAft. Both headers contain numbers (not that this matters). I need to be able to cross reference the row selection with the column selection (it doesn't matter which is selected first) and return the value...