Search results

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

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

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

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

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

This should be simple, but I can't figure out how to do it. I created a form-based query. The query works fine. But what I want it to do is automatically create/open a report based on the query. How can I do this?

I posted earlier about a similar problem and got some useful help, so I thought I'd try this one here too. I'm a beginner, so please be gentle. I have a very simple form-based query set up. The form is called 'frmTeams', and the query is called 'qryOpenTagsByTeam'. The form has a single...

This is a very simple question, I think. And I'm very much a beginner at Access. But can somebody help me set up a parameter query where the prompt allows the user to only choose from a few select options, rather than having the user enter the information manually? Basically, I want the query...