Too Many Steps?
Oct 10, 2007
I am working with several reports between Access and Excel and I feel like there must be an easier way to do what I need. Hoping someone can help.
I have 4 Excel files, A.xls and B.xls and C.xls. Each with different fields that I will use to join and extract data to make D.xls.
A is the master file that I need to compare B and C to. I need to create a 4th file that will contain all the records on A and only those on B & C that match A. I am using email and ID as the join fields. A has email, B has email and ID, C has ID. I am joining A & B by email to make query A_B which contains all A records and only those on B that have same email. A_B now has fields email and ID. Then I need to use query A_B to join to C. The problem here is that I cannot use the query A_B to do this. I get an error message and have to export the query to Excel then bring it back into Access as another table to use for the last join. This is where I feel like I am doing an extra step. Is there a way to use this last query for the next join so I can end up with a final file that has all A records that contain B data and C data?
I know this sounds confusing but I hope someone can understand and provide guidance. Thanks!
View Replies
Jul 18, 2005
Hi,
I have a table wherein only new data is provided by the user, and fields that have not changed from the previous record are left Null:
Date Field1 Field2
1 B (Null)
2 A 1
3 (Null) 2
Is there a simple way to produce the following results from an aggregate query:
Date Field1 Field2
3 A 2
(Where [Date] is a parameter.)
Right now my process is pretty clumsy, requiring multiple steps to get the MaxOfDate for each Field, then each Field's value corresponding to its MaxOfDate. Not pretty. :(
View 3 Replies
View Related
Feb 29, 2008
Hi,
This is my first post here and I seem to like the activity on this forums. Now to my issue.
I have a table with schedules: Event and it's schedule in actual date:
Ex.
Event1 1/1/2007
Event2 5/1/2007
Event3 7/1/2007 (MM/DD/YYYY)
and I have another table which has the event name, time steps and numbers:
Ex.
Event1 1 1000
Event1 2 1500
Event1 3 1500
Event1 4 2000
Event1 5 1500
Event2 1 1000
Event2 2 1500
Event2 3 1500
Event2 4 2000
Event2 5 1500
Event3 1 1000
Event3 2 1500
Event3 3 1500
Event3 4 2000
Event3 5 1500 (I kept the numbers same for all, time steps are monthly)
Now, I can't think of away to write a query to link the dates and the time steps, eventually reaching to some output as this:
Event1 1/1/2007 1000
Event1 2/1/2007 1500
Event1 3/1/2007 1500
Event1 4/1/2007 2000
Event1 5/1/2007 1500
Event2 5/1/2007 1000
Event2 6/1/2007 1500
Event2 7/1/2007 1500
Event2 8/1/2007 2000
Event2 9/1/2007 1500
Event3 7/1/2007 1000
Event3 8/1/2007 1500
Event3 9/1/2007 1500
Event3 10/1/2007 2000
Event3 11/1/2007 1500
Thanks, let me know if there is anything not clear. Pointing me to the right direction to do this helps a lot since I am kinda lost.
View 3 Replies
View Related
Jun 27, 2006
Is there a way to make a query that has several steps that have to be run in sequence, rather than all at the same time?
For example, I want to create a table that is created from 3 other tables that I download.
The first step would be to append all titles from the first downloaded table, not allowing duplicates.
The second step would be to append all titles from the second downloaded table, not allowing duplicates.
And the same with the third step.
It would be nice to be able to do this with one query, but since it gives me an error because I am trying to do the same thing three times to the same field, I can't. I would really like to avoid having to save this as three different queries, like I've had to do with other multi-step queries.
If there's a way to do this, I'll be able to apply it to several other multi-step queries I have.
Also, if that is possible, is it also possible to have several types of queries in one? Like an append query with several update queries, performed in sequence?
(Note: I'm creating these queries in Design View--I don't know enough to write my own queries in sql, except for my one union query--which I had help with--from here, I think. I can, and often do, alter sql queries that others have written for my own purposes, though.)
Thanks,
Siena
View 5 Replies
View Related
Nov 4, 2013
MS Office 2003..I have 7 queries that I use to export data to one excel workbook. Inside the workbook are 7 worksheets, one for each query. I have it working but I dont know how to save the exports steps like I did in AC2010.
I export the data by right clicking on each query and select export , then I browse to the workbook and because each query is named differently , it names the worksheet. I have to run these 7 queries each month , so I would like to save the steps and then build a macro that would run all seven steps at the push of a button.
I have saved the steps on a PC running MS office 2010 and the macro works great. The problem is this resides on a PC that cant be upgraded and I need to make it work on Access 2003 .
View 1 Replies
View Related
Sep 17, 2014
I'm enrolling medical centers in a new multi-center database. There are a number of steps that must be completed before the center is enrolled in the project. I have a form that serves as a checklist. I want the textbox at the bottom of the form to display the percentage of steps completed. I guess you would have to count the number of fields on the form that are filled in, but I don't know how to do it.
View 1 Replies
View Related
