Search results

  1. B

    export new data

    Hi friends, I built a form using combo and text boxes. The options that appear to choose inside the combo boxes comes from several linked tables. But, How can I get all the new data in only one table. I mean, how can I export the new data the users write inside the tables, as only one table? :(...
  2. B

    Percentage calculation

    Hi everyone, I am very confused about calculation inside grouping data. I need to calculate a percentage using a total outside one group. I mean, I have: Inside group: AreaBasal Percentage 12.5 4.3% Frecuencia Percentage 8 ? Outside group: Total 436 I need to...
  3. B

    cutting strings

    Hi friends, I am trying to cut strings in the field [Specie] to print in reports, like these: "Jacaranda 5" to show "Jacaranda sp." "Smilax 2" to show "Smilax sp." "Pouteria 1" to show "Pouteria sp." but, I have fields like: "Juglans neotropica" "Casearia angustifolia Diels"...
  4. B

    Query based Forms

    ;) Hi there, I am trying to built a form based in a query table, but when I see the results, just appear some of registers, leaving empty spaces where must appears the other. I mean, I have 148 registers, but I just can see 50 of them. The results are not consecutive, leaving white pages...
  5. B

    Combination box options

    Hi there, I am having problem with forms, because I understand that one can built a form with combination boxes, where one can choosing the wanted option, I mean, Choose between several items inside the table, write it as new item, or search a registry similar to it inside the form. I want use...
  6. B

    Automatic actualization

    :rolleyes: Hi everybody, Be patience, I am newbie. How can I do automatic actualization of some fields that depends on other field? I mean, I have several empty fields, and when I fill one specific field, the other fields that depend from it, get its value too, automatically. Thanks in advance,
  7. B

    Concatenating text fields #Error

    I got it finally. Hi, friends, I can go the correct results finally. The problem was with strings like " ", I dont know why it doesnt work fine on my system as Wayne write me: =([N_Genero], "") & Nz([Epiteto], "") & Nz([N_Autor], "") But when I write the sentence like this...
  8. B

    Concatenating text fields #Error

    NO solution, Same #Error Hi friends, I followed both ways you recommend me to correct my problem, but it does not work, it continue showing #Error. What is the meaning of Nz command? Another suggestions or clues? Thanks in advance, Jaime :(
  9. B

    Concatenating text fields #Error

    Hi there, I'm concatenating two or more text fields using the following string: =[N_Genero] & [Epiteto] & [N_Autor] However, when I run this report, I get a #Error for the object. I get this one with other fields too. I am trying modify it, but nothing happens, like: with strings...
Back
Top Bottom