Search results

I have a text field that contains data in the following format: "06/10/09 By John Doe" I want to use the date portion of this field in a mail merge document. Is there a way that I can code this in the document to strip out the "By John Doe" portion of the field? The field is titled Pre_Review...

Thanks DCrake. With a little modification, I was able to make this work in the ArcGIS 9.2 software. For those folks that just need to see the final solution, here is my working code: Function FindLabel ( [TAPNUMBER] ) ihash=InStrRev([TAPNUMBER],"-") If InStr([TAPNUMBER],"L")>0 Then ichar=...

I have a need to label features in a GIS system based off of a field in a table. The field name is TapNumber and here is how the information looks: 10204001-10313001-91L+110 19205020-19205002-7R+021 8016014-8016011-143R+143 What I need is only the numbers between the second "-" and the "L" or...

I understand what you are saying with the second method, but I'm not sure how to set it up. Can anyone help with this?

No, not 4 numbers for one record. I want access to create the records using the inputted numbers and populate the ID field with the individual numbers. using the example I gave, I want access to create 4 records and when its done, the table would look something like this: Record_ID 60000 60001...

I think this is a pretty simple thing, but for some reason I'm lost. I need to add a number of records to a table. The user would input a starting record number and ending record number (ie 60000, 60003) and access would create those records with the record number field populated with all the...

Shades, Your formula is EXACTLY what I was using yesterday and it would not work. Today it does. I knew that the formula should work because I am using it in other places on my worksheet and it works perfectly. Nothing more frustrating that knowing you are doing the right thing and not getting...

This might work, however I have a few rows that do not have completed dates and when I enter them, won't I have to re-sort my data each time I input a new completed date? I really don't want to do that if it can be avoided. Thanks for the help.

I think this will only work for a specific month, but it will not give me totals by month and year i.e. September of 2004. I tried using the Date function as the criteria in the sumif but it will only allow for a single day not an entire month. any ideas how to get it to grab the month AND year...

I have a date column and a cost column and I would like to get a monthly total of cost. Here is an example of how my worksheet is set up: Our_Cost Completion_Date $3000 7/14/2004 $0 9/27/2005 $1288 10/25/2004 I would like to use a formula to give me the total cost of...

towel, I think what they are trying to tell you is to create a field in your TABLE called Active. The field should be made a yes/no field. You can do this when you create the field. Your form's control should then use the table field Active as its control source. After this is done, when you...

Thanks Well I FINALLY got it to work. I followed the article you sent to me and went step by step. Everything worked right up to the point where he had me enter the VB code for the After Update on the Form. I could not get that to work. It kept giving me an error, so I created a Macro that does...

Tried That I've been trying to create a form with a pick list all day and I can't get the query to see the Contractor that I picked. If you have an idea how to set that up, it would be helpful. Thanks

Tried That I've been trying to create a form with a pick list all day and I can't get the query to see the Contractor that I picked. If you have an idea how to set that up, it would be helpful. Thanks

Simple Select Query? I know to some of you, this is going to sound very simple. I want to select a group of records for a specific contractor to see what work they have done for us. I would like to pick from the list of contractors (tblContractors) and run my query based on THAT selection. I...

Problem Resolved I re-created my six queries to give me the counts I need...One query for each individual field and made a seventh query(qryMonthlyReport) that is setup to display the counts for each of the six queries. I then made a report based on the qryMonthlyReport. So now when I run my...

Still did not work I changed the having statement to where and I get the exact same results. I get an accurate count of the Preliminary Record Date Field, but the other counts are wrong. Someone at my office suggested running 6 seperate queries to get the counts and then running a query that...

As You Requested This is the SQL that is in the query. As it is right now, If I input a month and year, I get the correct count for the first field. The other fields produce a count, but it is not correct and I dont know what to put in the criteria to make the other fields work. SELECT...

Count and Date Criteria Ok Pat, I fixed the query running prior to the report problem. And I have tried just about everything I can in the query to get the counts I need for the dates I want to specify. I have even tried to run the query by just inputting "Between [Enter Start Date] And [Enter...

Count and Date Criteria Ok Pat, I fixed the query running prior to the report problem. And I have tried just about everything I can in the query to get the counts I need for the dates I want to specify. I have even tried to run the query by just inputting "Between [Enter Start Date] And [Enter...