The query I would like, would only show me the result of Rows 2 & 4 because the value of cost is different between the weeks.
At the moment I have two queries, One that pulls out the last weeks value (WeekNo 1), and the other that pulls out the same information but for the comparison week (WeekNo 2). In the third query I created I linked the two columns from the Ref fields, but could not work the logic to only show me ones where the differences in cost were displayed.
Thanks in advance of the resolution to this. I know it is basic query work, but just have a logical block in getting it to work.
i have a table that has meter readings for copiers on it and dates. i need to add another column to show the differences in the meter field between itself and the row entered before it (the month before) to find out how many copies were made. i can do this in excel very easily, but cant figure out how i would do it in access sample: Date Meter Diff. 06/01/2006 0 0 07/01/2006 1000 1000 08/01/2006 1500 500 we will be entering the date and the meters in every month, but i need to have it calculate the difference between months so i can then calculate overage, if any.
I have the below query (A). How do I calculate the Day of Therapy as shown in B
A MRN Last Name DOA Service startDate INR Dose WarfID VisitID 12001 Smith 6/28/2013 Warfarin 6/29/2013 1.20 6 mg 10 138 12001 Smith 6/28/2013 Warfarin 6/30/2013 1.20 6 mg 11 138 12001 Smith 6/28/2013 Warfarin 7/1/2013 1.3 6 mg 12 138 12001 Smith 6/28/2013 Warfarin 7/2/2013 1.40 6 mg 13 138 12001 Smith 6/28/2013 Warfarin 7/3/2013 1.40 7.5 mg 14 138 12001 Smith 6/28/2013 Warfarin 7/4/2013 1.70 7.5 mg 15 138 12001 Smith 6/28/2013 Warfarin 7/5/2013 2.00 7.5 mg 16 138 11002 Brown 7/1/2013 Warfarin 7/1/2013 1.00 2 mg 17 139 11002 Brown 7/1/2013 Warfarin 7/2/2013 1.3 4 mg 18 139 11002 Brown 7/1/2013 Warfarin 7/3/2013 1.50 2 mg 19 139 11002 Brown 7/1/2013 Warfarin 7/4/2013 1.8 2 mg 20 139 11002 Brown 7/1/2013 Warfarin 7/5/2013 2.20 2 mg 21 139 1205972 Jones 6/28/2013 Warfarin 7/6/2013 1.0 6.5 mg 29 138
[code]....
What I really want is to calculate the time (# day) it takes to reach a target goal INR (2-3) I have tried DateDiff between DOA (date of admission) and Start date but this obvious won’t work because some patient won’t start on warfarin until later.
Another possibility is to calculate date difference between two rows in same column but I don’t know how For example Pt 1 = It take 7 days to reach an INR of 2, Patient #2 = it takes 5 days to reach an INR 2.2 and Patient #3 takes 6 days to reach an INR of 2.1. Average = 6 days.
I have a query question . How can I extract a CHANGED value" in a column? Example here under table1. Time and TAG makes a record unique, No ID available ...
I want to have as output 10:04 Tag2 12 10:07 Tag1 11 10:08 Tag2 11 (so at 10:04 tag 2 changed in value and on 10:07 tag1 changed value and 10:08 changed Tag2)
Preferably with the previous value as well, but this is not the highest prio 10:04 Tag2 12 11 10:07 Tag1 11 10 10:08 Tag2 11 12
In the organisation that I work for employees get paid every 2 weeks on a Saturday. So for this financial year the pay period end dates have been 08/07/2006, 22/07/2006, 05/08/2006 etc
I have a column in an Access table listing various dates. I want the next column to be populated with the next pay period end date after that date.
So if DATE is 05/07/2006 I want PAY PERIOD END to be 08/07/2006 and if DATE is 09/07/2006 I want PAY PERIOD END to be 22/07/2006 etc
what is the difference between creating a table using SQL and creating a table using MAOL (access object library)? I ran into these 2 methods when taking a tutorial on the internet? What are the advantages of each method?
I am struggling with calculate difference between two query table values, I first created a make a table query(current meter reading) which contains one column called "meter read" , and I created a second make a table query(previous meter reading) which also contains "meter read" column, I linked those two make table queries to calculate the value difference between two date, how can I create a form to calculate diff between any two date?
I'm trying to use VBA to update a new column in a table with info I already have in another table.The table I want to update is an inventory details table, it has around 25,000 records. I added a column called "UnitCost", of course the column is empty for all 25,000 records so I would like to fill it easily using DoCmd.RunSQL "UPDATE" feature.
I use that through-out the program however I'm unable to connect the dots for this one.What it needs to do is update "UnitCost" in "InventoryDetails" from "Products" where "InventoryDetails.ProductNumber" = "Products.ProductNumber"
The "Products" table has all the different unit cost, it just need to be placed in the "InventoryDetails" table for every record. Of course product1 needs products1 unit cost and product2 needs products2 unit cost, etc.
How to copy a column from one table and insert it into another table in the same database
Hi, All,
I have two tables (old and new) sitting in the same database. The new table is the result of 'data cleansing' done by an external company. In the process (export and import via excel) two memo type colums in the table were truncated in excel.
To make the new table usable, I must therefore now copy/insert the two memo columns from the old table into the new table.
Both tables are already Access tables and sit in the same database. Both tables, of course, have the same number of rows.
I tried to high-light one column in the old table, clicked copy, then high-lighted a blank column in the target table, then clicked Paste, but got error msg: "This text is too long for this field. Try copying a shorter text", as if I had wanted to copy the whole column into one cell rather than one column into another column of equal length.
I have one database containing several tables, two of which are associated to this inquiry:
1) tblCategories Contains two columns: CatID and Category Name
2) tblPending Contains many columns of data obtained through upload from a web form including a column to capture the CatID and also a column for Category Name. I wish to populate the Category Name column based on the results of data uploaded into CatID column
How is this accomplished? This is inherited project and I have very little experience with Access so just limping along... Specific instruction much appreciated.
Ok everyone, I need your help. I’m trying to create a simple database template for robotics teams in MS Access hopefully to be used in our upcoming season, if we have one. I’m using MS Access 2003 and I’m trying to create a Transaction Log table like this.
The thing is, I want the Balance field to automatically fill in by adding the value of Amount to the previous fields Balance value, or if it’s the first entry in the table then setting the balance equal to the amount. Is there any way to do this?
Ok everyone, I need your help. I’m trying to create a simple database template for robotics teams in MS Access hopefully to be used in 263s upcoming season, if we have one. I’m using MS Access 2003 and I’m trying to create a Transaction Log table like this.
The thing is, I want the Balance field to automatically fill in by adding the value of Amount to the previous fields Balance value, or if it’s the first entry in the table then setting the balance equal to the amount. Is there any way to do this?
I have a big table bringing Access up to almost 2G limit. I need to add a column to that table using a query. I can’t make another table because of the volume.
I am currently building a holiday planner for my employers and I would like to try and display the days of the year as rows and the staff as columns (Fields). When someone adds a new member of staff, I would like it to also add them to the calendar table as a new column and name the column the same as the individuals name. Is this possible using VBA or SQL string?
If anyone has a better idea as to how I can display the forthcoming holidays for a team I would really appreciate your comments.
How do I add a new column to an existing table, and fill it with number (starting at 1) so I can use that column as the PK? Step-by-step instructions would be great, I'm having a lot of trouble with this!
im having problems updating a table. im trying to take a column from table2 and place it in table one...i tried exporting it to excel, copy and pasting it and what not, but since it has about 200k values, it only copied half, incomplete...
i tried this query, i dont know if im doing it right.
SELECT DlexLoad.pah, DlexLoad.doc, DlexLoad.vol, Bate.BATES FROM DlexLoad INNER Bate ON DlexLoad.Bates = Bate.BATES
im trying to replace the Bates column from Dlexload table, with Bates from bate table...
I have a linked table that I want to create some queries for. I would like to add an extra column to the table which is the sum of two existing columns in order to be able to use this in the query. So far, I've come completely unstuck. Any ideas please?
How can I create a column in a query that reflects automatically the table name? Example: Table_ABC. has fields: ID, Material, Qty. I want to create automatically a column/field in the Qy_ABC with "ID", "Material" and "QTY", and in additon into it, next to "Qty" a filed/column is called "Name" and filled with "ABC". Thanks.
