Search results

In my form and report I use a field called "use" and it displays the contents as either "R", "Condo" and "Apt" (this comes from the actual data). I'd like to have the data displayed differently in the form and in the report. Can I display it like: if results is "R" displays as "SFD" if...

To be quite honest Bruce seemed to ignore everybody but Bob. I actually did try everyone's suggestions but they didn't work (I guess I wasn't very clear on this). It wasn't until I compacted/repaired the DB and rebooted the computer when they worked. Thanks again. Bruce

I certainly learned a few lessons. I need to be more precise in how I explain my problem. I need to be more precise when I respond to posts. I need to remember to reboot my computer every once in awhile. Again, thanks for everyone's help. Bruce

Bob: I tried each and every suggestions and they didn't work. I then decided to compact/repair the database and rebooted my computer. I then started over trying each suggestions. It now works (I believe what you suggested did the trick). I truly appreciate everyone's help. Thanks again...

Bruce, The MIDDLE column in #3 should be from [0-Combined] Not [0-Combined_City_Filter] !!! Wayne Wayne: I tried using 0-combined and its sorts by city just fine BUT it shows all of the cities (there is a table that is supposed to show only certain cities). see post #20 Thanks. Bruce

I tried uploading the DB but its too big (its 854 kb). I can email mail it if anyone would like to see it. Thanks again. Bruce

Bob: If you can, could you look at the pictures I posted in post #18. They are the most current. If you notice picture #3 that is how the query is set up and #4 is the results. As you can see #4 the results are not sorted by city and that's what I'm trying to accomplish. I'm sorry if I'm...

Not sure what you mean by sample DB? The DB is pretty big: the front end is 43,432 kb and back end is 190,096. I appreciate all your help. Bruce

The way the current query is set up I have a table where I input the cities I don't want to see data displayed. When I use the city in the other table it displays every city including the ones I don't want data displayed on. Thanks for your help. Bruce

I'm trying to understand the "is null" comments BUT the query displays data when "is null" is in the city field. Picture #1: is the query where sale date is sorted Picture #2 is the sale date results Picture #3 is the query where city is sorted Picture #4 is the city results. As you can see...

If you look at post #2 I attached some pics of what I'm seeing. Here is the code when I have: no fields sorting SELECT [0-Combined].* FROM [0-Combined] LEFT JOIN [0-Combined_City_Filter] ON [0-Combined].CITY = [0-Combined_City_Filter].City WHERE ((([0-Combined].SALE_DATE)>GetDateCrit()) AND...

No, its still the same. It will sort by date but I want it to sort by city and that's where the problem is. Bruce

I'm not really sure how it actually works but if I remember correctly, it was designed to have a separate table where the cities are kept that I DON'T want to see data on. If I run the query and the "is null" is used these cities do not show up. If I remove the "is null" every city shows up...

The database was set up to only search for certain cities and if I remove the "is null" it shows every city. Thanks.

I opened the query in design view and then went view, SQL view and here is what showed up (not sure this is what I was supposed to do). SELECT [0-Combined].* FROM [0-Combined] LEFT JOIN [0-Combined_City_Filter] ON [0-Combined].[CITY]=[0-Combined_City_Filter].[City] WHERE...

I don't see images I uploaded the images but I don't see them. So, I'll try again. Thanks. Bruce

I have a query that I can't get to sort correctly. I'd like it to be based upon a start date (which is fine) BUT then sorted based upon city. If I leave all fields "unsorted" it sorts by date but if I check the city field "sort" it kind of sorts. I've attached a few screen shots. I really...

I think I got the 2 queries done correctly. So, how do I go about attaching these queries to the icon on my form? Thanks. Bruce

I've done the append and it add the records to the new table BUT how do I get it to delete the records in the 1st table? Thanks. Bruce

Move records I've been able to create the query that finds the correct records NOW I need to know how to MOVE the records to the new Table. Bruce