I have an Access database(Access 2002) with voter information - first name, last name, address, city, st, zip. I need to be able to combine records if there...

I'm trying to set up a database that should handle volume discounting. I've constructed a table containing the conditions for each volume discount agreement....

Hi All, The Vlookup function normally looks for exact matches. However I'd like to try and modify the functionality to look for near matches. For example if...

Hello - I am considering transferring our data recording system from an Excel Spreadsheet to an Access database. I work in a school and one of the key things...

Hi I'm not a programer, not aware of programming, I just started using ms access recently Can anyone help me in a simple language of creating vlookp in ms...

Hi, I have 'Table1' with 3 fields: MonthOfFlight (text 3 digits), USExchange (number), CANexchange (number) and 'Table2' with 3 fields: Flightdate...

I am a new user of MS Access and have in the past done all of my databasing in MS Excell. I was wondering if there is a lookup function in access that...

I am looking for equivalent functionality on ACCESS XP as found in the vlookup function in EXCEL. I have a value in a field which I will test against a table....

Hi there I am having some problems when trying to extract the data I want. Basically i have these two tables set up: 1. GSTT Raw Data - it contains a list of...

All, I am trying to do something similar to a VLOOKUP from Excel. I have a table where latittudes are the column names and longitudes are the row name (1st...

I have a text file i import and it is on a per company basis. Thru the use of a query, I have create specific identifers for each piece of information. The...

Hi. Hope someone can help me with this. I have this vlookup, where I want the cell to display a zero, if not found, but instead I am getting #N/A. I tried...

Anyway of simulating a VLOOKUP kind of function via Access Queries. For users who are not familiar with VLOOKUP, it functions as follows: Amongst a table of...

Hi, I am writing a visual basic procedure as follows: Public Sub DaysAvg() 'Calculate the average value of a given value. Dim dbs As Database Dim rst As...

I get this message when I try to exit Access. It won't let the database close - only way I can close it is through the tack manager possibly losing last...

Hi, I trying to retrieve values from a table to calculate the 14days average value of a stock closing price. However, i encounter some problem as stated...

Hi, I trying to retrieve values from a table to calculate the 14days average value of a stock closing price. However, i encounter problem when there is...

Hi, I trying to create a table using visual basic, when i try to run it. It prompt me "No fields defined, can't append Table or Index. Anyone, could...

This one is very detailed. I am trying to run create a VB code that gives me results that contain the distribution center's name, the total number...

Has anyone else tried MS Access (2003 or 2007) with Vista RTM? I have Macro that lets a series of 130 or so queries that churn thru a large database (280k...