Search results

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

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

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?

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

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

Hello everyone, I have a form with subform created to track payments against a particular job. I have a field on the main form that is labeled "OUTSTANDING". What I need is the payments to subtract from the outstanding amount automatically. Is there a way to do this? A copy of what the form...

Hello, I would like to track payments against a job. Each job may have many invoices that are billed against it. I have an "ORDER" table with "ORDER #" as the primary key. I think I need to make a "PAYMENT" table with the "INVOICE #" as the primary key. What I would like to do is enter a...

Hello everyone, I am new here and I hope that you can help me as I have spent days trying to figure out what should be a simple problem. Please explain in detail because I appear not to understand this function. I have a customer table that contains "CUSTOMER #" and "CUSTOMER NAME". I have...

Hello everyone, I am in Orlando, Florida. I used to be pretty good at this but it was 9 years ago in college. Now, I have been tasked with creating a new database that is to replace the old DbaseIII program. I have found, I don't remember nearly as much as I use to. The questions I ask will...