This took me so long to post on here because I haven't been able to try it. I was out from work for a few days with pneumonia... Anyways I now understand that ![price] just extracts the price column information from the recordset, I was just unfamiliar with it.
I have run into quite a few problems and every time I go to post on here what it is, I figure out the problem. Finallry the results are correct. I really appreciate all...
jedgretzky
Last Activity: Apr 22 '08, 06:45 PM
Joined: Apr 8 '08
Location:
-
I followed your advice and adjusted the MYSQL, as well as a few other problems I found and now it gets past the part where I was originally having the problem. Now it is getting stuck on the code on line 19:
curPriceValue = MyRS![Price]
Because I am new to using VBA with Access, I am unsure what the ![Price] does. So it is hard for me to figure out a solution. The error I am receiving says:
Run-tim...Leave a comment:
-
Hi, I came across this post and I am trying to do pretty much the same function. In mine, I am trying to find the median of certain values, based on the "Department " grouping. I used ADezii's code and query; I adjusted the code to what I thought should be correct. Unfortunately I encounter an error saying "Data type mistmatch in the criteria"...
This error comes up on this portion of the code " Set MyRS...Leave a comment:
-
I just tested the query and it worked perfectly, thanks for your help I really appreciate it.
-Jedd...Leave a comment:
-
I have a select query that selects the records that I want. I think I may just have to enter a delete statement inplace of the select. Unfortunately I will be unable to test this today, it is quiting time.
This is what the select statement looks like:
SELECT x.ID, x.[TOTAL VALUE]
FROM x INNER JOIN x AS x_1 ON x.ID = x_1.ID
WHERE x.[Total Value]< x_1.[Total Value];
Thank you...Leave a comment:
-
The record would have to be identified by the Total_Value field. In the duplicates there will be 2 different values, one Total_Value will be smaller than the other Total_Value field. I want to delete the record that has the smaller Total_Value field.
Here is one idea that I tried but could not get working: This shows basically how I wanted to delete the record where the value is smaller.
delete *
from x T1,...Leave a comment:
-
After running the subquery to come up with the duplicated data fields, It comes up with all of the rows with duplicate IDs. However I am not sure how to add in the argument to delete certain rows only where the total amount is the largest. Here is what the SQL looked like from this query to find the duplicates.
select x.ID, x.[TOTAL VALUE], x.SORTNAME, x.[DECEASED FLAG], x.NAME, x.[FACE VALUE], x.[TOTAL VALUE]
FROM x
...Leave a comment:
-
Delete Similar Records
I am having trouble creating a query that will delete duplicate records. It seems to me that this isn't that hard of a query, but I just can't seem to get it working. What I have is a table that has an ID, which should be unique. Unfortunately there have been entries for the same ID where the Total Value row has been increased. What I want to do is delete the records that have the same ID number but the lower total.
Here is one...
No activity results to display
Leave a comment: