Recent content by BE19

I did. That's where the information came from in the first place. I used dlookup() to access the information but when I do and scroll through the records, I keep getting the first record in the query. The query records do not keep up with the table records.

The only criterion is that the record number of the query i.e. the matches the record number of the table. And actually both dlookups listed give the same result. How do I get query data (querey ID does correspond to the ID in the table) to scroll through with the table data?

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

Access 2003. I can send the table I'm trying to construct this one, if you'd like. All I want to do is return the cross section of the two values so I can use it elsewhere. You'd think I was asking for a piece of the true cross! :O

Yes, the contents of the table is static.

I'm trying to find a way to do a two dimensional lookup w/o VBA. I have a table that is 10x9 (CxR). I thought I could use a combo box with the field names in it to represent the columns across the top. I then put in a list box for the row selection. I thought I could use the count() and dlookup...

Interesting. I didn't know that. So you're saying the data isn't stored in lineal progression. That shoot that idea for solving my two dimensional lookup. Back to the thinking board.

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.

All I've done at this point is to create a table with the values. The only solution I saw was to rename the field names to the necessary column names then use the row that had the values as a primary key. Stopped after that because I wasn't sure how to proceed.

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

combo boxes There are a myriad of examples out on the 'net. Here are a couple: http://www.blueclaw-db.com/comboboxlist/ http://office.microsoft.com/en-us/access/HP052405811033.aspx?pid=CH063661991033 http://www.functionx.com/access/Lesson25.htm lkp