Search results

  1. K

    List box: combining columns from multiple tables where records not always cohesive...

    Hello, I have a form with a combobox (combo0) where a sample id can be selected from the drop down menu. In a list box I have the following code: SELECT DIVERS_pt2.sample_id, DIVERS_pt2.[1/(maxi/summe)] AS 1/(max species count/total count)], SHANN_pt2.proz FROM DIVERS_pt2...
  2. K

    how to highlight a row in a listbox?

    Hello, I have a form where i have a combo box where I can select a desired sample id. Then, I have a listbox which then shows all of the species that occur in that sample and their relative abundance. Would there be a way that I could highlight the record with the maximum abundance each...
  3. K

    possible to add a "select none" option to a combobox drop menu??

    Hi, Using a combobox, I have made a drop down menu of values from a table column. When an item is selected in the combobox, records show up in a listbox. I want to have a "select none" option in the list. Is there a way to add an entry to the combobox drop menu without altering its parent...
  4. K

    Im stumped on a simple query! I need some help!

    Hello, OK. So I have a table titled NANDAT with the columns: sample_id, shipcode, cruisenum, corenum, depth, data, art I have a query written shown below: SELECT DISTINCT sample_id, max(data) AS maxi, sum(data) AS summe FROM NANDAT WHERE art<>66 And art<>88 And art<>90 And art<>95 And...
  5. K

    need help displaying record in listbox based on parameter selection in combobox!!

    Hello, Basically I want to perform a parameter query with a drop down menu. To do this I have created a form with a combo box (combo0) and a listbox (list3). The combo box is a drop down menu of sample_id (from my query ANART_pt2) I want the listbox to display the full record from ANART_pt2...
  6. K

    How to "Export" query table in Access?

    Hello, I want to export my query results table to a specified folder as a .dat file. I don't want to output the whole database to file, I just want to output a query table to file... Using Informix SQL the equivalent would be: UNLOAD to "C:\test.dat" and Using Oracle SQL (I think?) the...
  7. K

    Problem importing from excel to access. My #'s get rounded!

    hello there, I am trying to import data from an excel spreadsheet into an access table. The problem is that all my values keep getting rounded up or down, and my decimals are not preserved. I have tried creating a table, setting the data types to 'decimal', then importing the data in, and it...
  8. K

    Simple Query giving error message... help please?

    Hi, When I try to run this simple query: SELECT sample_id, sum(data) AS summe FROM REVDAT; I get an error message that says, "You tried to execute a query that does not include the specified expression 'sample_id' as part of an aggregate function" Does anyone know what would...
  9. K

    "Not responding" Help simplifying a query?!

    SELECT distinct area.shipcode, area.cruisenum, area.corenum, lat, long, waterdepth, (data/summe)*100 AS proz FROM nandat, indproz_pt1, area, sample WHERE sample.sample_id=indproz_pt1.sample_id AND sample.sample_id=nandat.sample_id AND area.area_id=sample.area_id AND nandat.art=98 OR...
  10. K

    Unload/Export/output data from a query??

    Hi, I want to "unload" my query results to a specified folder as a .dat file. I have some old SQL scripts where the command seems to be: UNLOAD to "C:\test.dat" However UNLOAD is not a legitimate command in Access... does anybody know an alternative? thank you!
Top Bottom