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

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

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

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

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

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 have a Access 2003 database file listing all licensed hunters & fisherman (purchased from Fish&Game in my home state), about 200,000 names. From another...

I have a table like this: NAME CODE FREQUENCY ------------------------- Bob 1 3 Frank 3 2 Bob 3 4 Joe 2 1 Joe 1 2

Hi, Using Visual Studio 2008: I have a tableadapter in my dataset connecting to a table in Microsoft Access Database, which forces me to use the IIF...

What I am trying to do: tblUniveral is made of questions (Q1- Q28)which can only take their value from the list of Satisnumber off the tblSatisfaction....

I have some ADO statements in my code (INSERT, UPDATE, DELETE) used in a passthorugh fashion, like

Is there an easier way? Currently use in a query: 1.) DatePart("w",) = 5 and 2.) Day() = Between 15 and 21 and is the field name in a table with MANY...

I'm working on a database that contains information about how well a question was scored on an internal assessment. In order to make the data work for...

I want to create a counter for a query by selected field results Main sort - req number Second sort - Date or Name or Time ...etc Output1 Have counter...

Hi everyone! Enjoying the spring? It's a beautiful time of year. Using A02 on XP. Have a letter query and want to ask "Include New Client Info Paragraph? Yes...

I have a report tracking database where the report number is an autonumber field. I am useing a switchboard so I have setup a macro to allow me to search for...

Want a muslim match?Want a muslim brother/sister?why not join our site and start your searching? http://www.motorcycletime.com/mywebs/muslim.htm