Search results for query: *

Great idea not storing the data that is predetermined. Eliminated 5 fields. I wrote VBA for the other situations and it all works beautifully.

Hello, I am an appraiser and I am making a database to track files that I complete. I need to fill in 28 fields for each file I do (stupid goverment). Many of the fields can be determined once a corresponding field has been filled in. Others fields can be estimated when corresponding fields have...

Excellent!! I put my variables in and it worked beautifully. Thank you very much for your help. Below is the final code anyone searching for answers in the future. ~Luke Select [ORDERS 1998].[File #], [ORDERS 1998].[Street Address], [ORDERS 1998].[Appraiser], "1998" as [Order Year] FROM...

scriverb, Yes, if correctly follow what you are saying, that would definately be valuable. Also, when the user searches for an address, they will only use the beginning. (Ex: "5232 Tablot" for "5232 Talbot Rd S" or "5232 S" for "5232 S Tablot Rd"). This may return more than a couple results, but...

Got my answer from another forum. Information is posted below for others referance: ___________________________________________________ You could use UNION to join different queries. This can only be done in SQL view (i think). Be sure the returned columns all have the same name (you can use...

Hello, I am a relative novice so bear with me. I have a database that has six tables in it (Orders 2003, Orders 2002, Orders 2001, Orders 2000, Orders 1999, and Orders 1998). Each table contains was created by different office staff over a number of years. They all have some of the some basic...

I needed to show all appointments scheduled for the current week (Monday through Sunday). I used this criterea and was wondering if there was an easier way: >=(Now()-Weekday((Now()),2)+1) And <=(Now()-Weekday(Now(),2)+7) Just curious if I missed something obvious. ~Luke

Hello, Right now I have a query that takes a user input for the current week (ex: 0 is this week, 1 is next week, etc) and brings back all the appointments during this week. The criteria for this is as follows: >=(Now()+7*[UserWeek])+(-Weekday((Now()+7*[UserWeek]),2)+1) And...

Thank you for your help.. I need to think about it a little more.. I will probably post again in a couple days. I am assuming there is no way to leave the cell unmodified using the IF function. Either you need to clear the cell with &quot;&quot; or you have to have IF function reference...

Thank you for taking the time to answer. Unfortunately, that will not work. Continuing with the same example...D2+D3 equals &quot;x&quot;, but the values in D2 and D3 are constantly changing, (they represent a stock price for today and yesterday, so tommorrow, it will be tommorrows price and...

First, is there a larger specific excel forum out there? Second, I am having trouble with the &quot;IF&quot; function. I want to have something happen to a cell if something else is true, put if It is not true, I want the cell to keep its current value. Ex. Lets say A1 equals value...