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

    Trojan Horse MusicSearch

    Murray - How do I do that? I am running *choke* Windows ME. ANY help will be appreciated.
  2. DesertTrip

    Creating a report from multiple filtered queries

    Thanks CJtyo! It helps having a name to associate to something when you seek to research it further. I will go research that now and see what I can come up with. :) DT (btw: great signature!)
  3. DesertTrip

    Creating a report from multiple filtered queries

    VB6Novice, thanks for your answer! :) Now, let me see if I got this right: 1: Create a new form, that has unbound fields for each of my user criteria (or all criteria?) 2: Create a input box that feeds into that new form...one each for the date, name etc If this is correct, how do I link it...
  4. DesertTrip

    Creating a report from multiple filtered queries

    VB6 - when I did this on MY pile of problems, the user was then required to enter the date and worker number criteria 6 times each for the main and subreport. Any ideas on how to prevent that from happening?
  5. DesertTrip

    Query Based Form: How do I ignore blank records?

    ...I then tried it on the PROJECTS field itself and again, for some strange reason, it didn't work there either. But, the Between function did. (*scratches head in confusion*) Sorry that I couldn't have been more exact in describing what it was I was working with. Also, thanks for trying to...
  6. DesertTrip

    Query Based Form: How do I ignore blank records?

    The query is based off of one main table. The field itself is from a lookup table used in the main table. The "data type" for this field is text, but the mask is ##\-### (5 numerals separated by a dash) Some records don't have any entries in this field, and my query and form are...
  7. DesertTrip

    Query Based Form: How do I ignore blank records?

    Thanks for the answer, but that didn't work there and now I see I am going to have to switch gears because the placement of criteria in my expression field is causing a parameter request to pop up. So.....I am switching fields to bring up only records with text of any type. Typing Is Not...
  8. DesertTrip

    Query Based Form: How do I ignore blank records?

    ...Form to show only records that have data in certain (relevant) fields of the records? Is this done in a criteria on the Query? I tried Like* to bring up only items with entries but it also brngs up zeros. would like this to work off of a field consisting of fixed numbers GREATER than zero...
  9. DesertTrip

    Group by process (Scriver? Anyone?)

    It works! [thumbsup] You get a vote & star from me also, for your patience and assistance! Your help was much appreciated and quite informative. Leia/DesertTrip
  10. DesertTrip

    Group by process (Scriver? Anyone?)

    Oh dear! I see that missing field now and as MichaelRed stated, kudos for your patience. I appreciate it greatly when anyone takes the time to me in my Access education. I will make the corrections and try again this afternoon after I get back from an out of town meeting. Thank you; Leia
  11. DesertTrip

    Group by process (Scriver? Anyone?)

    ...DISTINCTROW Format$([tblCaseData].[Date],"m/yy") AS DateByMonth, [tblCaseData]![Code] AS Activity, tblCaseData.EmployeeNumber, Count(*) AS Count, Sum([tblCaseData]![OPAmt]) AS OPAmt, Sum([tblCaseData]![OIAmt]) AS OIAmt, GROUP BY Format$([tblCaseData].[Date],"m/yy")...
  12. DesertTrip

    Multiple inner joins on the same table

    Never mind!! I got it figured out the beginners way. Sheer luck. I made a secondary query off the first, and then I brought in the lkp.Employees table, linked and added the district to my query and wallah! My report is now showing what it needs to. Thanks for trying to help me out! DT
  13. DesertTrip

    Multiple inner joins on the same table

    ...AS DateByMonth, [lkpSpcProjects]![ProjectTitle] AS Activity, tblCaseData.EmployeeNumber, Sum([tblCaseData]![Hours]) AS Hours, Count(*) AS Count, Sum([tblCaseData]![Mileage]) AS Mileage, Sum([tblCaseData]![Mileage])/40 AS MileageCalc FROM tblCaseData INNER JOIN lkpSpcProjects ON...
  14. DesertTrip

    Multiple inner joins on the same table

    never mind on the foo question (oops) I'lllet you know how this works.
  15. DesertTrip

    Multiple inner joins on the same table

    Thanks, Rudy...silly question. What does "foo" represent in your example? I will go try this now....everything I have tried so far ends up in syntax errors.
  16. DesertTrip

    Multiple inner joins on the same table

    I don't know if an old post will bring any results, but I was searching for answers on the search function to try and avoid having to being a new post. My misfortune is not being entirely clear on the basics of SQL. ;)
  17. DesertTrip

    Multiple inner joins on the same table

    ldandy, or anyone else ready this who would know what he meant. You stated that he "should put all tables and inner joins (together with the ON clauses) in the FROM clause (which will be only one) and all conditions in a single WHERE clause (and link them with AND)." I logged onto...
  18. DesertTrip

    group/total records in a field with matching data?

    ...for direction) Before this project, I only used Wizards and never even heard of a Union report. I can now make a simple one all by myself. (*pats herself on the back*) That INNER JOIN will take more practice, but now I have seen what it can do and how it gets there....I'm ready to try more...
  19. DesertTrip

    group/total records in a field with matching data?

    Yessssssss!!! It works! It works!!! I am amazed by that solution. I don't understand (yet, but I will tear through it with your printed messages again tomorrow until I do!) how it is that the upper half goes = lookuptable #1.[field the lookup table feeds into] and the second half of the...
  20. DesertTrip

    group/total records in a field with matching data?

    Great, Bob! VERY close!!! This was working perfectly until it asked for a parameter value for lkpLeavecode.MiscHour_ID. I made no entries at the prompt and pressed enter which then brought up all my data correctly, except for the data from the second half: the MiscHour_ID records/data. The...

Part and Inventory Search

Back
Top