Search results for query: *

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

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!)

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

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?

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

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

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

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

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

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

...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")...

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

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

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

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.

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. ;)

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

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

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

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