Search results

That sorted it. Thanks. Why did the original way stop working?

I have a report that I have been using for a long time. For some reason, it is refusing to sort by "Order Date" properly now. I have it checked it marked for "ascending" in the design view. It is sorted in the table and query that creates the report. Yet for some reason, it will not sort...

"OUTSTANDING" is a calculated field in the Form based on the "payment subtotal" which is also a calculated field. I think the "OUTSTANDING" column in the "ORDERS" table is erroneous. I wish the calculation from the form would store in the table as a number. But that is wishful thinking. What...

When I run the query, it is blank

with or without criteria, Outstanding is blank.

I did as suggested and it wants me to enter parameter value for "txtTotalPayments". If I don't, everything comes back as NO.

Hello, I have a database that has a check box that automatically checks when the outstanding amount is less than or equal to $0.05. =IIf([OUTSTANDING]<=0.05 And [COMMISSION]>=0,-1,0) When the criteria is true, my Form automatically checks the box marked "paid". I have a report based on a...

Great analogy. Made perfect sense!

I have a field that is currently a yes/no field. I would like it to be a yes/no/? option. I want the default for that field to be the ? to be manually changed to a yes or no once it is decided. Is there a way to do that?

Perfect! Thank you. I knew it had to be something simple!

I cannot post the database as it contains confidential information. screen captures are attached. I assure you it is date/time in the Order table. I have typed in the query criteria: Between #1/1/2011# And #12/31/2013# The results are showing 1996, 2002 and above.

No I am not including the quotes. I just put them there so you would know exactly what I was typing.

I have a query that is pulling information from 2 tables: airport codes and orders. I was able to select the 7 states I wanted without any problem. I am trying to limit the "order date" by using the criteria ">=#1/1/2011#". I want the query to only choose those orders that were dated 1/1/2011 to...

This was great. Thank you for the useful information.

I do not understanding what you mean. In my database, the control source, when I look at the field in the form shows, the calculation. I opened the form in the one you sent and everything has either #error or #name?. Unfortunately, because of confidentiality, I cannot attach my complete...

Perfect, thank you. I now have about 3300 entries in the Form. It is taking about 30 seconds to open. Is there a fix for that? I don't want it to get worse as more entries are added.

I deleted everything and inputted 2 orders. If you look in the datasheet view of the VIEW ALL ORDERS query, you will see that both orders have been paid and it says YES in the column. Then, if you look in the ORDER ENTRY WITH PAYMENTS, you will see that Byrd Electric does not have a check...

Hello Bob, I have been working well with the database and have been transferring information into it. I am running into a slight problem with the paid check box that you created for me. It does automatically check if the outstanding is zero but not if it is less than zero. ALTHOUGH, if I look...

Hello Access World, I have a simple form with a subform that I enter orders into. It only has 3300 records in it. For some reason, the form is taking about 10-15 seconds to open where it did not do that before. I have compacted and repaired the database hoping to fix the problem. I am only...

I feel stupid now. I had fixed the >0 on the other copy but not the one that I sent to you. I had figured it out previously but converted the wrong DB. I just changed the query that the form was bound to to the new one you created and that fixed the problem. Thank you for your direction. I...