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!

Register Log in
  • Congratulations derfloh 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: *

  1. theif68

    Changing query

    The field Names and Number of Fields change every time. I am also using the table to print a field listing for a report as well so keeping the names Field 1 through whatever might not work the best... Thanks again guys, might just have to suck it up..
  2. theif68

    Changing query

    Well I have been using the Report Wizard to create it each time, but would like to cut down on time , and make this automatic if possible.
  3. theif68

    Changing Report

    ...going to change in this table daily. This will select my records and fields, but need a report to be displayed off of this query without having to modify if for the different fields. Query: SELECT TOP 25 tblImport.* FROM tblImport WHERE randomizer()=0 ORDER BY...
  4. theif68

    Changing query

    ...different every time. I have a query that selects a random 25 records for a data dump but what is the easiest way to create a report that will change with the new fields each time... Query: SELECT TOP 25 tblImport.* FROM tblImport WHERE randomizer()=0 ORDER BY...
  5. theif68

    Parse Query

    Thanks guys.
  6. theif68

    Parse Query

    I am looking to parse names that go into a table in the field "FULLNAME", but I only want this qry to run if there is 1 space in the field. UPDATE tblStandardLayout SET tblStandardLayout.FNAME = Left([FULLNAME],InStr([FULLNAME]," ")), tblStandardLayout.LNAME = Mid([FULLNAME],InStr([FULLNAME],"...
  7. theif68

    Can I create A Report from This?

    Thanks alot, works great.
  8. theif68

    Can I create A Report from This?

    Wish I new how to create a table from this or I would. Thanks again guys.
  9. theif68

    Can I create A Report from This?

    Thanks but this is something that I would like to add to a macro to be ran at the begining of a job.
  10. theif68

    Can I create A Report from This?

    This gives me a layout of a table in the debug screen. How can this be alterd to show in a report? Public Sub fieldProperties() Dim tblStandeardLayout As String Dim rs As DAO.Recordset Dim fld As DAO.Field Set rs = CurrentDb.OpenRecordset("tblStandardLayout") For Each fld In...
  11. theif68

    Report That Prints Table Headers.

    That is exaclty what I need but not getting it to work. Thought I did. Sorry.. How do I use this on a table called "tblStandardLayout" ?
  12. theif68

    Character Counts

    Thanks alot.
  13. theif68

    Character Counts

    Can this be done in a Report? This way I can see counts on multiple fields instead of running multiple queries? SELECT Len([COMPANY]) AS Length, Count(tblStandardLayout.COMPANY) AS CountOfData FROM tblStandardLayout GROUP BY Len([COMPANY]); and SELECT Len([TITLE]) AS Length...
  14. theif68

    Character Counts

    Thanks alot.
  15. theif68

    Character Counts

    Thank you that is perfect. Is there a way to get counts of a field. Say I run a query on the company field and i want a layout something like this. Where length is the number of characters and count is the number of records that are that length. Lenth Count 10 1 20 5 30...
  16. theif68

    Character Counts

    Is there a way to get charater counts of a feild in a table. So if I have a company feild I want to get a count on how many are under or over 50 charaters long.
  17. theif68

    Record Multiply

    Works Great, Thanks alot guys. Saved me alot of time.
  18. theif68

    Record Multiply

    Thanks , but I get a runtime error 13 on: Set objSourceRS = CurrentDb.OpenRecordset("Test") Type Mismatch.
  19. theif68

    Record Multiply

    Thanks for the help. I guess this is a lil bit over my head. Hours of Cut and Paste will have to do the trick.
  20. theif68

    Record Multiply

    How do I take that table using a query to output a new table with the feilds multiple times based off of the quantity field?

Part and Inventory Search

Back
Top