Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS & have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for

Pulling Data From Other Tables Based On Values Entered

I'm attempting to build a simple database for a martial arts tournament registration. The weight division (Fin, Fly, Heavy, etc.) depends on the age, the sex and the weight. I've tried this several different ways, most recently by using one table called "competitors" with all the entrant's information, and several other tables based on the age class/sex (i.e. I have a table called Age 8-9 Male with the weights and divisions in it, and other tables for the other ages/sex).
So, basically, what I'd like to have happen is a report that will lookup in the correct table the division, based on the weight entered. In other words, for a record where the age is 8-9 and the sex is Male, the report compares the weight to the values in the 8-9 Male table, or if the record is a 12-13 Female, it looks in the 12-13 Female table for the weight, and places the correct division in the Division field of the report.
Probably going about this wrong.....but any help would be appreciated.

View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Automatic Values Based On Entered Data
Hi all,
Please bear with me if I'm asking a dumb question. I've been tasked to create a database from scratch and I've not had much experience working with Access.

**My Question**
Using a form is it possible to have the form automatically enter a "value" in one field based on the information inputed by someone in a different field.
ie. When some one puts in a value between 0 and 20 in one field it automatically enters a 1 in the other, and when some one puts in a value between 21 and 30 you get a 2 and so on down the line.

Thanks for the help.

View Replies !   View Related
Combo Box - Populate List Options Based On Data Already Entered
Microsoft Access 2003

Novice and working on a project with deadline... please help.

I have a table w a field that I want to convert into a combo bo and use data in the field as the options:

FIELD: Student Status


How do I get the combo box to automatically pull the values from that field into the options in the field when u pull down the drop down box?

Am I being clear?

View Replies !   View Related
Update Query Based On Lookup Tables Values
Hi, not sure if this is possible or the most economical approach but here goes:

I have a lookup table (tblHolidays) with a list of holiday dates (fieldname "HolidayDate") in it.

I need an update query that can check all "StartDate" values on a table called "tblMasterLog" and where this date matches the ones on "tblHolidays", will add 1 day to the "StartDate" and then keep repeating until there are no more dates to change.

Can this be done?!

Thanks in advance

View Replies !   View Related
Pulling Values From A Table Onto The Net?
Hello all,

I would consider myself a novice to almost intermediate with access.

Anyways what I need to do seems pretty simple. I just need to make a web page that pulls values from a table we have stored on our server. The users WILL NOT need to modify the info, they simple need to view it.

I want it set up so that when users modify the table locally here at our company, people from another site can view the changes on the internet...

Thanks for your time!

View Replies !   View Related
Pulling Latest Record Based On Date And Time?
Hello All...
I'm very new to Access.. so please forgive my ignorance..

Here is the scenario..

I have a table with two fields named "item" & "description" that contains 10 records total.

I have another table with 100 records with the fields "invoice #","item", "price paid","date paid","time paid".
The item fields are linked between the two, and the 100 records contain different invoices for these ten items.

I want to pull the price paid off of the latest invoice, based on the time and date... What is the easiest way to do this?


View Replies !   View Related
Field Updates Based On Month Entered
I have a report were I want to enter a month say "November" and I have 31 independent fields that reflect each day of that precise month. I also need the the last day of the month to only show the actual end date. 28, 29, 30, or 31 respectivly.

View Replies !   View Related
Updating Data On 2 Tables Based On Criteria
Ok. Here's the situation. I have query setup. This query has 2 columns:
1. Agent Name
2. Sale Value

I have 2 tables.
Table1: Includes Sales for this pay period only
Table2: Includes all Sales From past to present.

We are setting up our system on Tiers and Each sale value is going to change. So, Here's what I need:
I need to run an update query that first Looks up all the records in Table1 based on Agent Name. The field that needs to be updated is called SaleValue. It needs to be updated with what's in my Query mentioned above.
Then, all the values in Table1, need to be copied (or updated) into Table2. This can be done based on the Primary Key (SaleID), which exists in both tables. So I guess we will need to run 2 separate update queries. Any ideas on how this can be done?

View Replies !   View Related
Compare Data In Different Tables And List Non Matching Values

I am trying to compare data in two different tables and list the data that does not match. Not sure if this is possible. Details below

Table 1

xyz - A1 - Do not use
ABC - A4 - Use

Table 2

123 - A1

The result of the query should show me

A4 (as this does not appear in table 2

I am not too familiar with Null values as there will be many null values that i want to ignore.

Any help will be appreciated.

View Replies !   View Related
Pulling Info From Tables
I am trying to get an email address from a table by choosing a employee number from a combo is almost working,
however, it is returning the employee number as opposed to the email is the code I am trying to use:

Private Sub Combo0_AfterUpdate()

Dim myConnection As ADODB.Connection
Set myConnection = CurrentProject.Connection
Dim myRecordSet As New ADODB.Recordset
myRecordSet.ActiveConnection = myConnection
Dim mySQL As String

mySQL = "SELECT EmailName .*,[Employees] FROM EmployeeNumber"

myRecordSet.Open mySQL, , adOpenStatic, adLockOptimistic


Set myRecordSet = Nothing
Set myConnection = Nothing

End Sub

Then, in the section for the command button and the Outlook code, I have:

eMailAddress = Me![Combo0].Value

like I said, it is returning the same value that is in the combo box...if anyone could help, it would be greatly appreciated

View Replies !   View Related
1 Query Pulling Info From Multiple Identicle Tables
Hi guys.
For my coursework I was told I need complex queries to gian high grades.

This is my problem:
I have many many tables all identicle. They have the same field names just different information on them.
I wanna be able ot query ALL those tables to bring 1 result which I will then make a report out of.

I have tried everything, I fidled with the relationship but can't understand it.

Oh, and the tables have been linked form excel. I know i can't edit it then, but i dont need to.

I would really really apretiate all responses as this needs to be done asap.

Thanks in advanced.

View Replies !   View Related
INNER JOIN Based On Equivalent Values, Instead Of Equal Values
I'd like to create a query which will consist of simple SELECT statements as follows:

SELECT [table1].[field1], [table2].[field1], [table2].[field2]
FROM table1 INNER JOIN table2 ON ([table1].[fieldX] = [table2].[fieldX]);

The challenge arises b/c instead of joining on equal values, such as the following:
[table1] INNER JOIN [table2] ON [table1].[field1] = [table2].[field1]

I would like to join based on equivalencies, such as:
[table1] INNER JOIN [table2] ON [table1].[field1] = 34 is equivalent to [table2].[field1] = 2;

I do not know the proper syntax, so this is where I need help. I tried to search online without any success.

I appreciate your help in advance.

View Replies !   View Related
Pulling Data Out
I have a member roster. I have members who have attended. How do I subtracta list of those who have attended from the roster to find those who havent attended. The only way I know those who have attended is by their sign in date.

View Replies !   View Related
Pulling No Data
How could I pull in someone when they do not have data?

There is a name table and data table. My goal is that when I run a parameter query if someone does not have data for that time period to have that name pulled in so that eventually a report could be generated stating there is no data for this person for the time period.

View Replies !   View Related
Entered Value In Form Must Not Overwrite Tables
HELP!!! I am getting quite desperate. I am a novice. I have made a database for customers, products, etc. They all have good relations. I have made a query where I can see who bought what and when and how much it costs. Now here's the problem. When my prices in my product list (this is the table of which the prices show up in my form) have to be altered (because of prices going up), it automaticaly changes the query and the form!! According to messages stated in this forum, I have opened the properties in the text boxes and changed the price fields, "enabled" to no, "locked" to yes, and the forms DataEntry to yes. Strangely in the North Wind example, the prices shown in the form (entry form), are extracted from the subformdetails table. But how can you extract something from a table if there is nothing in the table?? Totaly I have four tables (Orders, Orderdetails, Products and Customers) Alle these tables are joined on a one to many basis.
Please can somebody help me.....
Thank you
Anouk (Netherlands) :confused:

View Replies !   View Related
Information Entered On Two Different Tables At The Same Time
I am creating my first database and I'm a beginner. I have a table called customers and another table that has customer and product information. What I would like to do is when a new record for my product is entered it also enters the customer information on another table. I have repeat customers though, so I only want it to enter it once. Right now, I have to enter the customer info separately. Customer table contains: Customer ID, first, last, Phone. My product table also has this same info. Is this possible? To enter info on a product form and the selected info be copied into another table at the same time only once.

Please help.

View Replies !   View Related
Pulling Data From A Table
I trying to build a usage tracker. Users will take a reading once a week and enter data. I want to open the form and have 2 fields filled in based off the last reading entered into the table. I have an ID field (autonumber) and I tried using that field -1 to populate my other fields but it does not work. any suggestions


View Replies !   View Related
Pulling Data From SQL To Access DB
Ok, so I am creating an Access Database to track the progress of our collections staff. I need to pull data from a remote SQL database and filter it so that the appropriate records are appended to the appropriate tables in teh Access DB. Any ideas?

View Replies !   View Related
Data Pulling Problems
Here is my problem. I am trying to use a form to enter data that is contained on one table, have it pull data from another table that is related to the original data, then add data and dump the whole thing off to another table. I would like to do this one item at a time. The only way I can get this to work is to pull all the data at once into the form. Is there any way I can pull just the related data I need by just entering the item number?


View Replies !   View Related
Need Help Pulling Data From A Form
I have 2 Tables and 1 form.

Table 1 has:

Product ID #, Product Name , Catalog Number

Table 2 has:

Date, Product Name, Catalog Number

with the Form, You select a Product Name (From table 1) and you can enter a date, which is entered into the Date column in Table 2. The form will also transfer the Product Name to Table 2.

Now, the problem is I can't seem to get the Catalog Number from the Form to enter into Table 2 automatically. It enters the Product Name just fine. I can, in Table 2, click the field and select the Catalog Number from a list, but that's not what I'm trying to accomplish. When a Date is entered into the Form, I'd like it to update Table 2 with the Date, Product Name AND the Catalog Number.. automatically.

is this possible? and if so, how?

I sorry I'm really new to Access, so my terminology is all out of wack. I hope the question is somewhat clear.

View Replies !   View Related
JET Pulling All Data From SQL Sever In A Query
I found an article on the internet on how to stop this, but for the life of me I can't remember it or find it.

The article stated that even though you were limiting your returned set of data from SQL Server by using a 'Where' clause etc. JET still pulled all of the data.

The solution has to reserve a read/write ability.

Can anyone expand on this?


View Replies !   View Related
Import Excel Not Pulling All Data
Access 2000

I am stumped, I wonder if it is a simple thing that I am missing because I'm getting frusterated.

Importing is nothing new to me I do it all the time and am aware of how datatypes can affect the import of data.

I had the same spreadsheet importing no problem before, I just modified the table and added 2 columns that were added to the spreadsheet.

now it will only import 3 rows of data, not the first 3 or the last 3 but 3 random records. Random as far as I can see.

Now the odd thing is that I can copy/paste no problem, but if I use the import wizard it will only take 3 records. There are no warnings.

I even imported the spreadsheet to a new table with the wizard and it worked, then I copied those 2 new fields and replaced them into the table but it did not matter.

One thing I am thinking about is does Access not creat an import spec for files when you first import them? Is that what is causing me a problem. I'm going to replace the whole table, I think that will work, but it still bugs me that it happened.

Any thoughts? :confused:

View Replies !   View Related
Show Calculations In Tables That Are Entered In Form View
I would like my table to show the result of a calculations (or a formula). I surmise that you can not have a column cell calculate data, however if I can do this in the Form View and on a Report - can it just SHOW on the Table so I do not have to keep switching back and forth to see the information.

I am new to Access and think the forum will be a big help to me.

View Replies !   View Related
Pulling Data AND EQUATIONS From Works Database 7.0
I'm trying to take a database from MS database (Works 7.0) into Access 2002. I've done this before by saving it as a DBase IV file and then opening it as such into access. However, this time I need the EQUATIONS to transfer as well, not just the values. I care little about the form view, or even the values themselves, but need the equations to transfer. Please advise. Thanks. :confused:

Mike S in ohio

View Replies !   View Related
Pulling Data From Combo Box Field Into A Report
I have several lookup fields in a table that reference data in other tables, each with two fields (unique nummber & text data). The combo boxes in the data entry form work fine, but when I produce reports, the unique number shows up in the output, not the text data from the second field. What can I do to force the data that I need to see in my reports?

View Replies !   View Related

Copyright 2005-08, All rights reserved