Search results

I have a date field in my query and I'd like it to return records with today's date. I used "Date()" as the only criterion, but when I run the query, I get an error message: "Undefined function 'Date' in expression." Any suggestions? Thanks!

I have four yes/no fields in a table, and in my query I would like to create another that is checked if any of the other four are checked. Any help would be appreciated. Thanks!

I have a two-character text field that can contain one of about 30 different preset codes. I have a long-integer claim number field. If the two-character code = "CN", the claim number field cannot be null (it's okay if it's null in any other circumstance). Help? Thanks!

I have a form that contains some fields that are summed in a total field. The first three fields (FirstTierHours, SecondTierHours, and MonitorHours) are added right in the query to create a Subtotal field. That works beautifully. Now I've added a subform that shows hours that other staff...

Is it possible to have multiple junction tables refer to the same "lookup table" for their information? For example, I have a list of funders and a list of projects. I have a junction table of proposals that references the list of projects for which we need funding. I'd also like to create a...

I have a report that contains a subreport that contains a date range. When I run the report, it prompts for the date range and then creates the report just fine. But when I hit my print button, I'm re-prompted for the date range! Arghhhhh!! (Thanks!) [This message has been edited by Timberwolf...

I have a columnar report of training summaries that includes date, sponsor(s), attendees, trainers, and topics. The sponsor, attendee, trainer, and topic sections of the report are subreports. When there are multiples in each of these subreports (topics, for instance), it lists them like this...

I've been asked to create a report that will return some information regarding hours worked on a project. This particular dB tracks writers' hours spent on each file in the project. (There is one field for total hours spent on a file, and only one writer works on each particular file.) We need a...

I have a report that contains five subreports. The query for one of the subreports contains a date field that prompts for the date range for the subreport. This is the only field in the entire report (meaning the main report and all five subs) that asks for a prompt. When I run the report, it...

I have a report that contains five subreports. In each subreport I have created a field that contains the record count for the subreport. In each subreport, this field is called "Count." I can't quite figure out how to add a field to the main form that will add together the "Count" fields from...

I have a form called Contacts and inside that a subform called PubOrders and inside that a subform called Publications (which contains a list box that looks up our pubs in another table). When I'm in the list box field, the drop-down list works fine, but after I make the selection, I get an...

I know it's a not a "regular" option with drop-down lists, but I'd give my eye teeth to be able to AutoTab to the next field after selecting from a drop-down list. Is there any way to do this?

I've created an OpenReport action in a macro, which I want to use to print a report for only the current record in a form. My where condition for the action is: [ClaimantID]=[Forms]![ClaimantsInput]![ClaimantID] But when I click the button in the report, I get an "Enter Parameter Value" window...

I created a simple button on a form that closes the form. I didn't write the code myself, I used the command button wizard. The button worked yesterday, but today, I get an error message: Compile error: Ambiguous name detected: Exit_Click I'm using Access 2000 on Windows NT 4.0. Any ideas...

In a report I have created a text box in which I'd like the last and first name fields to appear: =[LastName]+", "+[FirstName] It works great, unless there is no data in the FirstName field, in which case the report shows no name at all. (A few of our clients are companies, not individuals.)...