Search results

jrmask; the link you gave basically provides the same information as the link in my original post. I have been able to set that up and get it working correctly, however, those are 2 unbound combo boxes. I run into problems when I try to bind the combo boxes to the fields in my table. In other...

Ok this is a really pared down version but will provide the essence of what I'm trying to accomplish. I have a table (Table 1) with 2 fields (Referral Source and Name) and a Form (Form 1) with 2 combo boxes, Referral Source (combobox 1) and Name (combobox 2). When the user makes a selection from...

Hello: I have setup 2 cascading combo boxes as per: http://support.microsoft.com/kb/289670 This seems to work fine except that it doesn't do anything. What I need is to have the value selected in the second combo box be entered into a table. When I try to bind either of the combo boxes to a...

Hello: I have a table that has several currency fields (for the cost of products, employee fees, etc.). For some of the fields, when the value is zero, $0.00 is shown in the field, however in other fields when the value is zero, the field is just blank. This creates a problem when running...

Thanks Wayne. this looks interesting but unfortunately is beyond my knowledge of access and vba.; Appreciate the info though depawl

ruralguy. Thanks again for sticking with me on this. I kind of get the jist of what you are saying. I'll give it a try. depawl

No, adding a field is not out of the question. However, I'm sure that my client does not want to have to enter the rate for every record. I can create a new table that would have the rate, but I'm not sure how that would address the problem of the rate changing with time. And your suggestion of...

Sorry, on further review my post #3 was in error. Each record has a mileage cost, not a mileage rate. The rate is indeed hard coded in the query (Not my design). Is it possible to create an expression in the query that does this? Mileage Charge: (If [date] < 10/31/2008, then =[# of...

Rabbie, How would one do that (use a function)? Can you give me an example? Thanks so much.

ruralguy: Each record has a field for # of miles travelled. The query multiplies the # of miles * 0.33, to get the mileage charge. What I need to do is change all future records entered to calculate an updated mileage charge (0.57 for instance) without affecting past records. If I change the...

Sorry, existing records won't actually change, but when I attempt to run a report of past records that uses this particular query as it's source (my main report does), the past records that I pull up will be inaccurate if I change the mileage rate in this query.

Each record does have a rate, it's the same for all of them. I have no need to change past records, they have all been billed and paid at the $0.33 rate. All I need to do is change the rate from this day forward to a new rate. Thanks.

I have a database that tracks, among other things, the cost of mileage travelling to and from service calls. In a query, there is a formula: ([# of Miles]*0.33) So this multiplies the miles travelled by $0.33. This is an old rate (several years) and I need to update it. But I can't just change...

Where do I put the textbox? I can't put in on the report, can I? And this data is not from the record source of the report, so I would have to use DLookup, wouldn't I?

How would one enter general information for a specific report? For example I have a report that summarizes client activity for a certain time period. In the heading of the report I have 2 fields that need to be populated (for example: "date report submitted", and "date reviewed by bigwigs")...

In a report, I need to calculate the percentage of clients that respond "Yes" to a question on a survey. I need to create a query that will return the count of the number of "Yes" responses, and the number of total responses. For example, if 10 clients complete the survey, and seven respond...

Thanks guys. As far as I can see right now, this function in the criteria of the date field seems to work: >Date()-365 Appreciate the help. Dennis

I trying to create a query that just returns all of the records in my database for the past year. I've tried to somehow do it using the date() function but haven't had much luck yet. Any help is most appreciated.

Thanks. I can't believe it was that easy.

Need Report to Indicate When Goal is Met I have a report that is pulling data from a query. The query counts the number of clients that have accomplished a task. For example, let's say I have 10 clients, and 8 of them have accomplished the task in a certain time period. In the report, I have...