Recent content by kkershaw

Thank you. That's just what I needed.

I am running a report, based on a query. I want the detail to print on the report in "data-entry" order. In the query, I have marked the auto-number field to "sort ascending", but when it gets to the report it still scrambles the order. Any ideas? Thanks. Karen

Hello everyone. I love this discussion forum! My question is: I want my form to increment an invoice number if I have a checkbox checked. Otherwise I want the invoice number to stay the same as the previous form entry. How can I accomplish this? Thank you in advance!

When my client tries to sort a field within a query, nothing happens. She is selecting the entire field and chooses the A-Z button. She is able to sort within other queries in the same database. When I try to sort at my computer, it works just fine. She is using Access 2000 and I am using...

Thanks. That will work. I was afraid I would have to break my one main table into smaller ones, and I see the wisdom of that now. You people are great!

Each state is a separate field in a record. The table comes from a paper form where the driver fills in boxes for the state he's traveled in and the gallons of fuel he purchased in each state. My table looks something like this: Ticket #, Trailer #, IDMiles, ID Fuel, MtMiles, MTFuel...

I don't know if I should post this in the query or the report forum, but here goes: My report shows a truck and its miles and fuel by state: Example Truck 119 IDMiles IDFuel MtMiles MtFuel I have too many states to fit on one landscaped sheet of paper so I want the report/query to suppress...

I need a formula that uses a "nested" IF. Is this possible? Here it is: If miles > 0, then Miles*Rate per Mile Otherwise If MinTons > 0, then MinTons *Rate, Otherwise Tons * Rate. In other words, if we have miles, it overrides everything else. If no miles then if minimum tons are greater...

The formula is on the form itself. I have no idea how I would do it as an update query. I need to put it in the table because the fields come directly from a paper form that is already calculated. This database is mostly for archival purposes rather than calculated purposes. Thanks.

I know this is bad database form, but I've considered my options and I think I need to do this: I would like to paste the results of a formula in my form to the table. The control source is used up by my formula, so how can I get the result of the formula to post to the table? Thanks.

I have tried that, but the problem I have is that some of the fields in my query are calculated fields, and I get an error when I try to sum those fields. Any suggestions? Thanks

I have a field named "manifest" that often has duplicate values. I would like to combine the duplicate "manifests" into one line item in a report. Example Manifest Amount 12345 15.00 55555 10.00 55555 5.00 should read as Manifest...

Hi. I got your reply re: my message about copying data from a combo box to a text field. You supplied a line of code for me to enter in the AfterUpdate event. Can you tell me exactly how to enter that code? I cannot get it to work. Here's what I did. I went to the AfterUpdate line of the...

Each form represents an actual bill of lading, so I do need to store the rate with the form, and have it in the underlying table so that I can create reports. Currently, I get the rate from a query based on a table. The rates are linked to a field called OriginDestination. These rates are...

Now that I have successfully got my combo boxes to copy data to text boxes in my form (thanks to fizzio), why won't that data now appear in the related table? Example: 'rate' copies from a combo box to a field named 'rate' on my form. When I go to the table, the 'rate' column is blank. I...