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

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

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

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

I am somewhat new to Access and I have a problem. I would like to input a starting date and an ending date and have my query give me a count of records for a few fields for work done between those dates. This is like a monthly report kind of thing. I have created independant queries that give me...

I have a form that users enter information in that updates a block of records. I would like to clear all the fields after the query runs and updates the records so that another block of records can be updated without having to close the form or erase the fields one by one. Can anyone help with this?

OK the best way to describe what I want to do is Step by step I want to create a Form that a user can populate with information for a new job. This form should have all the fields that are contained in a Master Table. The user then puts in a starting record number and an ending record number...