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 figured it out this morning....I used Between 1 and 60000. This eliminated all records that had no entry. I was shocked because it is a text field, but this Criteria in the Query worked anyways. In answer to the question, you must forgive me as I am not very familiar with the terms of the...

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

I created a Maintenance FORM, that allows users to update and correct data they already added to the data base. I did this by creating a simple query, and then creating a form off that query. How can I get the Maintenance Form to show only records that have data in certain (relevant) fields of...

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

Scriver was extremely patient last month and taught me alot about grouping like records from one field of a query. I did great on my own for the next 5 queries that required this action. But now, I am stumped with my latest one. It keeps telling me that I am having a Syntax error and when I...

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

Okay, I added the word AND in between them as I was getting a really long nasty error until I did. But, I am now getting some little syntax error : "Syntax error (missing operator) in query expression". Can you see what might be causing it? If it means anything, after I close out the...

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

Oh yeah! The more I learn, the less I have to ask! (I hate bugging people and asking 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...

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