Recent content by keeling1

ScooterBug, Your offer is very kind, and I've attached the file. There's nothing sensitive in it. The two queries I'm working on are called qryGraphAllTags1 and qryGraphAllTags2. It's based on the form frmGraphAllTags. I think the first query is okay, except for the fact that it doesn't...

Thanks for your response, ScooterBug. Turns out that it's something else that needs counting, not this. So scrap my question. What I actually need the query to do is, for only those records which fall under the date parameters, divide the records into month, count the number of Yeses vs. Nos...

A quick question: I have a query that determines whether a date entered by a user is within certain parameters. I have it set up (using IFF) to return 'True' if it is within the parameters, 'False' if it is not. What I need the query to do is to count the number of Trues and Falses from this...

I'm creating a form-based query that takes dates entered as a month (e.g. Jan. 2009). It should then (1) determine whether the date in a table is before the date entered on the form, and (2) for only those entries that are before the date entered, sum the total number of "Yes" entries and the...

Quite right, wazz. Thanks for the correction.

Thanks for your help, Doc Man. I've gotten some way into this, but I've hit a roadblock. I've got a query, as you suggested, which separates the month and year for each date entered. Then, I have a second query which is meant to (1) determine whether the date is before a date entered by the...

I've asked a little about this before, and I've gotten some useful help. Here's what I'm doing. My overall goal is to create a line graph that plots certain data by month. It will plot Open Tags vs. Closed tags depending on the date parameters a user enters. (What Open Tags, etc. means doesn't...

Thanks for your replies, DCrake and Galaxiom. I can see, I think, how and why to use the DatePart function. But I'm not sure why it will help me to use a crosstab query. I've never used one before, so I'm really not clear how they work. The online descriptions I've found aren't very helpful...

Kryst51, your answer put me on the right track. What I did was just to get rid of the ID numbers completely. I was using them because when I set out to do dependent combo boxes, I found help online and simply copied what someone else had done. I think the ID numbers were there in the code I...

I have what seems to me to be a difficult query problem. I hope someone can help, as I'm a beginner. The database I'm building is to help a company repair its machines. When a machine breaks, a 'tag' is entered in the database. Then, when the machine is fixed, the user re-enters the database...

Thanks for your help, Kryst51. I've solved the problem.

This should not be difficult, but I can't figure out how to do it. Very briefly, my database is meant to help technicians fix broken machines. There are hundreds of machines, so they're broken into groups. There are two tables in play here. The first has columns for Group name and an...

Okay, in the query, I joined the ID field on the main table with the ID field on the tblMachine table, which has columns for the ID number and the Machine name. I thought that what I'd need to do then is to add a field in the query for Machine Name from the tblMachine table. But that's giving me...

You were exactly right. One of the fields in the form had the wrong control source, and it's now fixed and working perfectly. Thanks for your excellent responses. Maybe I'm pushing my luck, but I've also posted another problem I'm having and haven't gotten any response yet. It's here if you have...

It happens immediately after I click OK on the form. (The form opens the report, which runs the query.) I'm also posting the SQL of the query called 'qryAnomaly' as you suggested: PARAMETERS [Forms]![frmAnomaly]![cboAnomaly] Value; SELECT tblMainDataTable.ID, tblMainDataTable.[Tag #]...