Search results

Haha I would definetly like to slap my boss's wrist for that! It's linked to a sql server that is once a day updating counterparty values. The query that I am doing is making a Make-table query where I select the values for the last reported date. That field is inconvenient named date :D

That was silly out of me thanks :p but now when I run the query it says "Enter Parameter Value" for CurrentDate?

worked for me, I just added a space between your "" so " " instead

I am wondering if it is because the date that I had was enter as text, so I made this column CurrentDate: CDate([date]) This do not work for me! where [CurrentDate]=dateadd("d",-iif(Weekday(Date())=vbMonday,3,1),Date()

I believe this would do the trick aswell! Might be a stupid question, but does this code look the same in access 02? Cause it worked in my access 2010 but not in 02 :/

I'll take a look at the weekday funciton thank you! What I need help with is pretty simple tho. We compare values of stockportfolios. How we value it and how the counterparty values it. We get the value from our counterparty the day before(therefore Reportdate=date()-1) and compare them with...

All good here, hope that you're doing the same. It seems like a pretty easy table to make, just input your columns and fill them in. However I suggest that you make several tables as Mihail suggests. Try splitting you're tables up in categories that easily can be linked. For example the ones...

The reasen I use Date()-1 is because we run the report at 9 a.m. Report date gets updated at 4 p.m. So for mondays I need the dates from friday, that is my issue! Thanks anyway Mihail!

You can make an append query for (155-187). When you append and leave a column blank you can update that column with an update query. If you've never created an update or append query before. Just go to youtube and search for access update/append querys and you will quickly get a hand of it!

Hi! I would like to know how to make the abs function show if the abs value is negative or positive. Right now it automatically switches from negative to positive, I want to see if the abs value is negative.

Hiho.. Just finished my project when I realised one thing.. My query takes values from date()-1, the day before. But since we only get data from mon-fri, the monday data will be messed up.. Any suggestions on how to solve this? Right now I have the table[ReportDate] and uses the where...

if you have a lot of make-table querys then those take a large of space. Try using append and update querys instead!

Hi! For your first question. Have you tried using an append/delete query to save your data in another table? If not just set up a copy of your table, and you can easily append over the values for that table to your new table.

How are these columns suppose to be filled in? Do you import the values or are you going to fill them in manually?

Can't you just make an update query that only updates the values for the certain ID that you want to update?

Seems like my boss wants me to store the data to able to use them if neccesary...

However this problem was larger in my head than in reality... I just put a where [ReportDate]=Date() and it deletes properly.. Sorry for taking your time!

Ops yes, sorry about that. I have a macro that runs through different append/delete querys and the last table called [SecondaryTrades] is a table that stores different values for the current day. Each day this last table changes for each ReportDate. What I want to make is a table that stores...

Hi! I have just finished a report that saves values in a query. This query contains values that change for each day, so what I would like to do is create a way to store this informaton in another query. Basically I'd like to save data for each report-date. And if you run the macro the same day...