Search results

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

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

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

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

Please help a poor fool! I have read through the form forum and tried some of the suggestions to help me with my problem, but no luck. Here it is: In my form I have a combo box with one column showing 'destination' and the other column shows a 'rate'. The combo box list was created from a...