Search results

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

I would have expected it to ask for paremeters in that way too. That's what it asks when you try to open the query without using the form: [Forms]![frmAnomaly]![cboAnomaly]. But what it's asking is just: Anomaly (My query is called qryAnomaly; the report is called rptAnomaly. You can see...

Relating numbers to names in a table or query I think this problem is easily fixed, but I can't figure out how to do it. Very briefly, my database is used to help people repair the machines in a factory. The main purpose is to print reports that will tell the technicians which machines need...

Ah! That idea never occurred to me: to make the form open the report, which runs the query, rather than the other way round. Thanks much, pbaldy. The only problem now is that after using the form and clicking OK, the query is asking for parameters. If you know how to fix that, I'd really...

I should add: ideally, the query would open, generate the report, and then close on its own. I don't know how to make it close automatically either.

Okay, I guess I should explain more. The database is supposed to help my company repair its machines more easily. The machines are divided into categories, and the people fixing them are divided into teams. So, suppose Team 1 wants to know which machines need fixed. They'll use the switchboard...