Recent content by Kelly@AllenEnt

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