Search results

After 20 years of dBase files we want to make some of the changes to the structure that we limped with over the last 20 years. Especially since were switching to Access. Bob

I have and I am getting different results from each one. I basically want the query dependent on the WHERE clause because I need records with those specific dates and substring of SC field. But once I have those records, I want to fill in a few values or additional fields from other tables...

Did some research on UDF. Even MS Help was of little help. What would be an example of a UDF? Bob

I have a Access 2007 database that contains five tables. I need to make a permanent change on some of the field names. In the past we were working with dBase IV, and it was always best to use similar feels with the same name. Example: Permit.bld Builder.bld Now, I would like to change fields...

I'm dealing one very large files coming from Access and processed in Excel. I'm experimenting and trying to find out if I am better off to call an external file, when in Excel. Working with the pivot table. Right now my biggest problem is having a quarry set up in Access 2007and saving it...

I have two quarries that should come up with the same total. The only difference. Uses a relationship and the other one does not. listed below is the code: 11CTY Total 127009 SELECT SEQNO, SEAL, SC, PER_DATE, SB, LOT_SIZE, BLDCERT, BLD, JOBADDRESS, JOB_ZIP, JOB_CITY, JOB_PHN, PHN_SEARCH...

I get an error when I use the run command in Access 2007 query. FROM ((permit INNER JOIN BUILDER ON permit.BLD = BUILDER.BLD) INNER JOIN SUB ON permit.SB = SUB.SB) INNER JOIN CITY ON permit.SC = CITY.SC Error: The specified field '[SC]' could refer to more than one table listed in the from...

>>However using the query designer << Yes I agree. I do need. But there seems to be a little less than a zillion to select from. Can you point me in the direction. Bob

As long as I'm on this project. Is there a way to exclude. Sine I have many fields but at times I need to exclude only a few from the results. Bob

Thank you both for your help. But Galaxiom you will never know how much you would just help me. I'm converting from dBase IV to access. Every database. That little statement about a unique field changes everything. Thank You Very Much! Bob

I'm sure of that! As I look at my records. He has many times given me excellent help. It's just that over time, many people look at topics, search. I only wanted to add a piece I came up with. One or two years from now someone might search on "Query on part of a value" and get a solution...

There is a term "Permit" in my code referring to the table. Is there a way to not have to use it but one time? Like a variable? SELECT permit.SEQNO, permit.SEAL, permit.SC, permit.PER_DATE, permit.SB, permit.LOT_SIZE, permit.BLDCERT, permit.BLD, permit.JOBADDRESS, permit.JOB_ZIP...

Thanks for taking the time to help me with the issue. It worked well. I want to add some code that a friend was able to help me with. It does the same but with a different slant: SELECT permit.SEQNO, permit.SEAL, permit.SC, permit.PER_DATE FROM permit WHERE (((permit.PER_DATE)>=#1/1/1989#) AND...

>>KeithG - If my post has helped you solve your problems please add to my reputation. Click the scale in the top right side of this post.<< Checking some of my previous topics. I'm definitely satisfied with the help I get on this forum. I do not see a scale at the upper right side. Would it...

My field contains very structured data, two characters - three characters. Example: 13-251 40-251 40-245 66-234 51-233 I want to quarry my table based only on the first two characters. usually I would use several values. In this case, I use two 66 & 51. 13 and 40 and 66 I tried The following...

So far I have found that using TaskBar address I can load an Excel file. Now I only need a way to load the "Sheet" and "RangeName", cell location. Bob

I want to go to a cell on a specif work sheet in Excel 2010, 2 different ways. "Link". I will using a macro program that can load very easy. 1. Open a closed Excel "xlxs" to a specif work sheet & also a different cell Example: a. File PermitUpdateMst.xlsx b. A sheet called "Master" c. A cell...

Thank you very much. The code worked great. Anyone who has to process data or work with large databases could really use a code snippet such as this!! Thanks so much for your help!!! Bob

>>jdraw<< >>Pat Hartman<< A standard sort could be C14. Field would be character of 14. Example: Bob Robert Robert Snow If all were the size of Bob I would be wasting a lot of size on my drive. Robert Snow is just short of 14 by 2 so is not that bad. Problem is my table is 4000,000 records...

I have a table with thousands of records. I'm getting ready to create new tables. My field in one case is Char 18. I would like to see if I'm filling the field using all 18 characters. Also weather I only have less than 100 that require all fields. If I could do a sort of some kind that would...