Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: davidmcolaco
  • Order by date
  1. davidmcolaco

    Report getting wrong data

    The query is running well so the problem is not on the query. The problem is on the report. The report is based on this query that is running fine and everything is ok, except for one field where it should appear a name and appears the code.
  2. davidmcolaco

    Report getting wrong data

    Sure, here it is: SELECT [RECOR].* FROM [RECOR] WHERE ((([RECOR].Sup)="Sup. H" Or ([RECOR].Sup)="Sup. P" Or ([RECOR].Sup)="Sup. C")) ORDER BY [RECOR].Sup, [RECOR].Departamento; Thanks
  3. davidmcolaco

    Report getting wrong data

    No, it's not. But when I run the query, everything is fine and appears the name I want to see, but in the report, I don't know why it doesn't.
  4. davidmcolaco

    Report getting wrong data

    Hi have a report that gets data from a query. Everything is fine, except for a field where it should appear a name, but appears the autonumber from the table where is that data. Can someone explain me why is that? Thanks
  5. davidmcolaco

    Find AP ip

    I already have access to the router web interface where have an option to show the dhcp clients, but the AP doesn't appear.
  6. davidmcolaco

    Find AP ip

    I use DHCP built into a switch from SMC.
  7. davidmcolaco

    Find AP ip

    And how can I look at dhcp? There is any command for that? THanks
  8. davidmcolaco

    Find AP ip

    Hi, I have a new AP in the network that is configured by a web interface. The problem now is that my router assigned an ip of our range to the AP and I don't know the ip of the AP so I can add new settings. How can I discover the AP ip address? Thanks
  9. davidmcolaco

    Copy changes on one table to another

    The problem is that right now I need to finish up this this week and I don't have time to read now.
  10. davidmcolaco

    Copy changes on one table to another

    Hi, What forces me is that I have a query to select twice values of that table to insert automatically some values, and the only way I could manage to do that was to create 2 tables with same values. Thanks
  11. davidmcolaco

    Format drive with fat32

    Hi, How can I format a hdd with fat32 file system on windows xp? Thanks
  12. davidmcolaco

    File system

    Hi, Just a question: Win NT4 supports FAT32 and NTFS file systems? Thanks in advance.
  13. davidmcolaco

    Copy changes on one table to another

    Hi, I have 2 tables with the same content, but one is linked to a form to change is values. What I need is that when something changes on table1, it copies the changes to table2, so they can always have the same content. Is that possible? Thanks in advance.
  14. davidmcolaco

    Change order in query

    So from what I understand I cannot use if and iif. So how can do it with the if or iff. Thanks.
  15. davidmcolaco

    Change order in query

    No, that was an error of the writing, but with: Sortfield: If([Supervisão]="Sup. Congresso", 1, If([Supervisão]="Sup. Programa", 2, 3)) I got that error I told before. Thanks in advance.
  16. davidmcolaco

    Change order in query

    Hi, I tried that expression on criteria, but I've got the following error: The expression you entered has an invalid . (dot) or ! operator or invalid parentheses. This is my final expression: Sortfield: If([Supervisão]="Sup. Congresso", 1, If([Supervisão]="Sup. Programa", 2, 3)) Can you...
  17. davidmcolaco

    Change order in query

    Hi, I have a query to get some data from a table and order it, but I need to order not in ascending way. I have to order it by a fiels that has 3 values: "Sup. A", "Sup. B" and "Sup. C", but in the final I want to appeared order like this: "Sup. A" "Sup. C" "Sup. B" How can I do this? Thanks.
  18. davidmcolaco

    Change reference table in a reports

    Hi, I have a report that is getting data from a table called "Test2", but now I want the change it and point to the table "Test". How can I do that? Thanks in advance.
  19. davidmcolaco

    Count words in a website

    I need that because we want to translate our website and the translators charge by word. That's the reason.
  20. davidmcolaco

    Count words in a website

    Hi, Is it possible somehow to count the total number of words in a website? How can I do that? Thanks in advance.

Part and Inventory Search

Back
Top