Help With Repeating Records
Nov 29, 2006
My table has the following fields
ItemNo Name ImageName DateRecd
123 Foo 00123.jog 1/1/06
123 Foo 00FOO.jpg 10/11/06
123 FOO FOO123.jpg 7/5/04
456 bar 00456.jog 6/10/06
456 BAR 00BAR.jpg 7/5/00
456 Bar BAR456.jpg 11/23/06
How would I write / get a query to run and show me, the 2nd item numbers, the 123 but only the most recent date so 10/11/06 and for itemno 456 the item dated 11/23/06
View Replies
ADVERTISEMENT
Aug 7, 2015
I need to create a form and report. I created a Form now (i want to Report too.) but i saw, some field records are repeating themself.
I give an example :
ID Group Project Name Maintainers
1 A X-File Top-Secret Saruman
1 B X-File Top-Secret Gandalf
1 C X-File Top-Secret Radagast
On my report or form i want to see only :
ID: "1"
Group: "A" , "B" , "C"
Project: "X-File"
Name: "Top Secret"
Maintainers: "Saruman" , "Gandalf" , "Radagast"
Is that possible to filter records like that ? and How ?
View 3 Replies
View Related
Nov 3, 2014
I have a query that I am running based off two tables. To one of the tables I add a few blank fields as my boss wants me to calculate the accounting portion. I work at an budgets unit but as IT. Anyways, I ran the query and opened it in a form for the Analyst to input their numbers. So every other field is calculated. A + B = C.
I have something in field A and I am putting the input in field B to get teh results in field C. So that's say that I queried for a certain analyst and I get four records. When I input anything into first record the input is in all the records for field B. This is where I am having a problem. I only want to input into the the corresponding record and not all the records I query.
View 14 Replies
View Related
Apr 10, 2008
Hi everyone. Apologies if this has come up before, but the search terms I've tried here and on google keep turning up the wrong information.
At work I manage a large database with many tables. It stores data for participants in a research study. Each table stores the data for a different test, so one participant may have multiple records. Primary keys for these tables are defined by a combination of the participant and date of test fields. (Everything is dependent upon a table that stores the static info for participants, so the database is normalized.)
I want to be able to make a table that lists target participants and dates, and then create a query that looks at this table and pulls all the available data from various tables for those individuals that was recorded within one year of the target dates.
I've successfully made queries that meet these criteria while pulling data from only one table. The problem I'm having is that when I try to pull from multiple tables, each with it's own date field that needs to be used as a criterion, I end up excluding almost all the data, because most of the target participants do not have all the requested data within the target dates.
I've tried being inclusive with my criteria (using ORs), but then I end up with tons of data that I don't want and I need to filter through it, which defeats the purpose of the query.
Any advice on handling this issue, or do I basically just need to create a separate query for each table?
I'm sorry if this is too vague, but it's illegal for me to upload any of my own dataset. I could probably come up with an example if it's helpful, though.
Thanks!
View 7 Replies
View Related
Dec 25, 2005
hi
my problem is when i export data form table or query to textfile it give me repeating rows my computer is win me
help me
View 2 Replies
View Related
May 12, 2006
As posted here
http://www.access-programmers.co.uk/forums/showthread.php?p=489795#post489795
I thought its better to mention it here as well:
How do I get the query to repeat itself to gernerate extra rows of info.
I have "[Enter Ingredient Code]" in the criteria section on one column, this gives me a popup when starting the report to enter the code. I would like to have this reappear to enter more information. Maybe the action to with another pop up box like
"Would you like to add another ingredient"
"Yes" "No"
Click on yes and the query will rerun and enter the data in, select no and the report is made.
M
View 1 Replies
View Related
Dec 6, 2006
Here we go again i have another problem.
I am finding it very hard to explain my problem so i have attached a copy of my database:
Have a look at NUMBERPLATE OPTIONS in the booking table. When you click on this field you have to type in the END DATE and the CAR TYPE to generate a list of numberplates that can be selected. This END DATE and this CAR TYPE have already been enetered into the BOOKING TABLE for this particular record. Is there anyway of repeating this data entery?
Iain
View 4 Replies
View Related
May 25, 2007
hello,
I have a form, and I am on record "A". When clicking to add a new record "B" I want all the same information on record "A" to show on the new record "B".
How can I do this without using default?
Thanks
View 8 Replies
View Related
Aug 6, 2007
Hello to all on this site, I am hoping someone here can help me in my journey to learning Access. I have some experience writing simple/moderate code in VBA for Excel, but I am now using Access to create a database to monitor/track progress on projects for an initiative at my work place.
My question revolves around using Combo Boxes. I have one table/form (tblEventSummary/frmEventSummary) where the user will enter data regarding a project they are working on. One field is called txtEventLeader. What I want to do is to create a combobox which will allow the user to either select a name from the dropdown list (of names that have been previously used) or to enter a new one. When entering a future form, I want any new names used to also be displayed in the combobox.
I was kind of successful doing this already using a query (qryEmployees), but if the same name is used in txtEventLeader, I then see that name twice in the combobox and in the associated query. I would appreciate any recommendations for what to do here. Hopefully I was able to ask a clear enough question...
View 2 Replies
View Related
Mar 27, 2014
I am attempting to perform a normalization process in a query where an organization would be operating in several different states and different countries. I have created three tables where: one table is Organization, second table is Country, and the third table is State. I made a table to record: Organization ID, Country ID and State ID. An organization could have 1 or more countries while having no US states. Also the organization could have 1 or more countries while having 1 or more US states.
What I am seeing is in my query is:
Organization | Country | State
Organization | Country | State
Organization | Country |
What I am wanting to see is:
Organization | Country, Country, Country | State, State
In the end, I want to make a mail merge from this query table.
How can I 'normalize' the query?
View 1 Replies
View Related
Dec 4, 2012
I have a form with a combo drop down box to select item from.The problem is once i've picked from a list this result shows up on all forms from #1 to end. I only need value picked to become record, only for that record.
View 1 Replies
View Related
Dec 2, 2004
I have read lots about importing files but can't find anything on how to handle importing data that repeats itself in blocks from with in a txt file.
Note that I intend to run the import as an event each time the db is opened.
the data is an audit log that looks like this:
Date: 12-01-2004 Time: 11:16:57
Transaction #: 061318 Cashier ID: NB
Computer: COUNTER2
Sale Recorded. Transaction Total: 2.5
Date: 12-01-2004 Time: 11:20:55
Transaction #: 061319 Cashier ID: NB
Computer: COUNTER2
Sale Recorded. Transaction Total: 5
Date: 12-01-2004 Time: 11:59:48
Cashier ID: RC
Computer: COUNTER2
Deleted All Lines From Transaction
Date: 12-01-2004 Time: 12:01:17
Cashier ID: RC
Computer: COUNTER2
Opened Cash Drawer--NoSale
Whats the best way of doing this.
Cheers
View 4 Replies
View Related
Aug 14, 2006
Hi,
On my form, we can enter time off for employees. This is working pretty well, but we have some employees that have flex days every other week or even once a month.
What I would like to make possible on my form, when the user is inputing the data, He makes the initial entry, and then he has an option (checkbox?) that they can select to make this same entry every (week, other week, or 1 month from the date). Have it repeat for a year out maybe, so if the user has every other friday off. It will make an entry for every other friday for the next year.
I've been searching the forum, and I've been reading on the dateadd function. But I'm not sure how to implement it on this form, not sure if there is a way to make it repeat for a year? Also not sure if it's possible (or if that's the best choice) to have checkbox for choices using it?
Any ideas suggestions?
Thanks
Chris.
View 4 Replies
View Related
Mar 16, 2005
I have users who use a form to enter data. One of the fields is "DateRange". The users tend to enter records in groups. The group of 10 records will all have the same "DateRange" As they start a new record is there a way that the "DateRange" field can copy from the prior record?
Any help would be great!
View 8 Replies
View Related
Nov 1, 2006
I am basically setting up a macro that will change the value for a field from "N" to "Y" for all records from a query. The macro works fine except for it does not know when to stop and gives an error message of "You can't assign a value to this object" after it has gone through all of the records and there are none left to change. The macro is set up like this:
OpenForm Action : This form is populated by the query and I set the Where condition to open records that don't already have a value of "Y".
SetValue Action : I use this to set the value of the field to "Y"
Close Action : I use this to close the form and save the changes
RunMacro Action : This is where the problem is. I use this to repeat the macro so it can go through the rest of the records that still have the field set to "N". I need to set the Condition or Repeat Expression so that it checks if all of the records have been changed. It either needs to check that all records have the field = "Y" or check that the macro is on the last record. Basically something that will cause the macro to not open itself again when there are no more records to be changed.
View 2 Replies
View Related
Jan 7, 2014
I have a form that uses VBA codes to write all the info from the controls in the form into different relational tables. I was stopped at the point that I wanted to have repeating controls. Collect multiple instances of the same type of data, such as in the case of writing many people's Name, Age and Specialty in the Employees table. How do I do that? What is the VBA code for this task?
View 1 Replies
View Related
Sep 22, 2014
My query has the fields setup ID, Date, Session, Value.In a report I am trying to create a bar chart that shows session names on the y axis and values along the x axis. I want to show 1 chart per ID.However, when I run chart wizard and create my chart I am getting charts for each ID repeating by the number of sessions (number of records in my query).So for example with 3 sessions im getting:
ID: 1 - Chart
ID: 1 - Chart
ID: 1 - Chart
ID: 2 - Chart
ID: 2 - Chart
ID: 2 - Chart
ID: 3 - Chart
etc.
Where the chart is setup the way I want it, but it repeats for each session.how I can get the report to show 1 chart per ID?I tried grouping by ID but didn't seem to work
View 3 Replies
View Related
Aug 3, 2005
Hi,
Over the past three months I have been trying to develop an application which can repeat appointment entries.
I would like to have the option to repeat an appointment entry for a given number of weeks.
For example if an appointment entry was placed for today (Wednesday), there would be a command to create additional duplicate enties for the same day of the week for a given period of weeks ie say every Wednesday for the next 52 weeks.
Any help on how I could approach this would be very much appreciated.
Thanks
View 1 Replies
View Related
Mar 1, 2006
Hello hello. I'm new here, and new to Access... I've just started taking Microsoft's Office Online training tutorials and I was wonder about planning tables and repetitive data.
I had transferred some stuff from Excel to Access but now I'm looking at redesigning my whole database using relationships, etc.
I'm mostly working with a mailing list, so my fields are:
Mr./Ms.
FirstName
LastName
Title
Company
Address
City
State
Zip
Okay. There is also a second list of contacts that will link to the Company field. But my question is, most of the contacts in this list have the same title (be it President or CEO or whatever...) -- there's only like four variations.
Would I make a separate table with just those four titles, so I don't have to repeatedly type "President" in the title field?
And then if so, what about things like Mr./Ms.? It's only two variations and every record needs one. And what about State? Again, only two states ever. These don't get their own little "related" table, do they? And if not, how do I avoid typing it every time??
Thank you so much for reading this, and thanks in advance for your help.
~Jas/LadyGrey
P.S. I have another major question too, actually. As I said, I'll have two different lists hinging on the Company name. Except I have some companies with multiple contacts... so I don't think I can make the Company the primary key, since it may be repeated for a few records. Help, please! Thanks!
View 2 Replies
View Related
Nov 7, 2006
I have a table like this
Stuff.
ItemNo Name ImageName
123 Foo 00123.jog
123 Foo 00FOO.jpg
123 FOO FOO123.jpg
456 bar 00456.jog
456 BAR 00BAR.jpg
456 Bar BAR456.jpg
...
I want to do a query to return just one row per unique ItemNo
So the query would return
ItemNo Name ImageName
123 Foo 00123.jog
456 bar 00456.jog
I don't care which one it grabs, the first is as good as the last, as they are essentially different names for the same thing coming from different systems.
I know there's gotta be an easy way to do this, but I've tried things like TOP, DISTINCT, etc and none of them work for me.
View 3 Replies
View Related
Jun 5, 2006
I'm trying to create a video tape library and I'm very new to access. The tapes are numbered 0001-infinity. I want to insert a microsoft word template in each record that I can click on, make changes to one and not change each document in each record by simply changing one. Does this make any sense and if so can someone help?
View 1 Replies
View Related
Aug 17, 2015
managed to get some code up and running but when trying to enhance it I have hit a rut.
I have a function that is looking up a query called Optimisation - Auto Optimise with operational data in it. I only need 2 key fields; consolcode and volume. There are 106 records with different consolcodes each with different volume. e.g consolcode: Chittagong to Rotterdam201452 (Chittagong to Rotterdam by year "2014" by week "52") and volume 161 (cbm)
I then run a code that allocates the volume into specific sea freight containers and returns the values into a different output table.
The allocation code works fine but when I run the loop function for the recordset rsttradelane it runs for the correct amount of records (106) but always returns the first record of Chittagong to Rotterdam201452 and 161 cbm and not the other 105 consolcodes with the different cbm. Giving me an output table with Chittagong to Rotterdam201452 and 161 cbm repeated 105 times!!
Code:
Set rsttradelane = dbsEPIC.OpenRecordset("Optimisation - Auto Optimise")
consollane = rsttradelane!consolcode
ConsolVol = rsttradelane!Volume
Do Until rsttradelane.EOF
'Optimisation code' then
Code:
rsttradelane.MoveNext
Loop
rsttradelane.Close
How do I ensure that each consolcode and its associated cbm is recognised individually and flushed through the optimisation code?
View 3 Replies
View Related
Feb 13, 2014
I have two tables that look like this:
Table 1
LOCATION NUMBER , SIZE
1.12 ,100
1.13 ,100
1.14, 12
1.15, 12
1.16 ,150
1.17 ,150
1.18 ,100
Table 2
ITEM , SIZE
A , 12
B , 12
C ,100
D ,12
E ,100
F ,100
G , 150
I would like to do a query that Joins the "Size" in each table, and then matches an "Item" to a "Location". However, because of how a normal join works, I cannot seem to figure out how to limit the "Location" field from producing duplicates in the match.
I only want to have 1 location for every 1 Item.
View 6 Replies
View Related
Jun 10, 2015
and I have several queres using the same table. I was trying to add 2 columns and fields to my 1 querie. I do not use program much but I have it for my cattle. SO I was clicking around. Went to Table and went to add the field.I changed my Primary Key field then realized I should not have done that.I changed it back to "ID" and "Number" and added my fields. THEN I went to the one querie and added my columns and fields.However NOW the one querie I messed with has 30,888 rows as it just repeats the 20 or so rows over and over .The other queries do not and they use some of the same data "ROWS" from the table
View 1 Replies
View Related
Jul 18, 2013
I am making labels to stick on containers that we're shipping out. Some shipments will have only 1 container and some will have more than 1.Can I have it repeat a label if there are more than 1 container for an order?
For example:
Shipment 1 has 3 containers. The label says "3 x DM" and it will make one label.
Can I set it somehow to print that label three times? What about adding incremental text, e.g. 1 of 3, 2 of 3, 3 of 3?
View 12 Replies
View Related
Aug 10, 2014
I have SQL query/dual sub-query in MS Access that is returning data from the left side of the query FROM correctly, but is only returning one record from the right side of the query FROM. Furthermore, it repeats the display of the one record and it repeats the entire results set with a different one record each time until all the records have been displayed. I expect that problems described as "Furthermore" will not exist by fixing the one record issue. I have tried using all the join types available in MS Access, but none change the result.
The desired output is:
Yellow Blue
11/23/2013 11/19/2013
11/19/2103 10/01/2012
10/01/2102 10/08/2010
10/08/2010 12/14/2007
The actual output is:
Yellow Blue
11/23/2013 11/19/2013
11/19/2103 11/19/2013
10/01/2102 11/19/2013
10/08/2010 11/19/2013
11/23/2013 10/01/2102
11/19/2103 10/01/2102
10/01/2102 10/01/2102
10/08/2010 10/01/2102
The same pattern is repeated 2 more times with Blue values of 10/08/2010 and then 12/14/2007.
Here is the SQL:
SELECT Long_List.Yellow,Short_List.Blue
FROM
(
SELECT DISTINCT BirthDate AS Blue
FROM (
SELECT DISTINCT BirthDate FROM citizens
UNION
[Code] ....
View 11 Replies
View Related
