I will check it again
Thanks&Regards...
victor1981
Last Activity: Sep 17 '08, 05:11 AM
Joined: Aug 10 '07
Location:
-
What I did is ,I imported only few queries and formed a new database but sadly its still not workin.Leave a comment:
-
Thank you so much the above queries are working fine but not the last one.I have already Run the compact and repair command and also rebooted my system but its not working.
Should I export all the tables and queries to a new Database?
Thanks&RegardsLeave a comment:
-
I don't know wats happening but when I run the final query,Its showing me this message "system resource exceeded".My system's RAM is already 1GB .Can u suggest what should I do.
Thanks&RegardsLeave a comment:
-
Oh! then you must take rest.
And Dsum is a function in MS access like Sumif in excel.But again I am very bad with the syntaxes in sql so i have yet to crack it but I believe it works well for running totals ,I just searched it on Google .Here is the link
http://support.microso ft.com/kb/290136Leave a comment:
-
Its giving me this result
Company Dte............ ...Qty YTD In actual it should be
a 4/1/2005 3:51:02 PM ...10 20............. ..............1 0
a 5/1/2005 3:51:02 PM ...20 40............. ..............3 0
a 6/1/2005 3:51:02 PM ...30 60............. ..............6 0
a 7/1/2005 3:51:02 PM ...40 80............. ..............1 00
a 8/1/2005 3:51:02 PM ...50 100............ .............20 0
a 9/1/2005...Leave a comment:
-
Yup but I wll have to show that in a different table separately,What we do in the report is give out top 10 companies and calculate there Monthly, Ytd and Mat sales.
Then we take out top20 Products sepeately and do the same for them Ranking is done on the basis of MAT sales.Leave a comment:
-
Yup here is the structure
Monthly Figures
......Company.. ....M1...M2.... M3....M4...M5.. ..... .etc
The Company......10 ....20 ....30.....40.. .50
Company Two.....12..... .24.....36....4 8..60
Final Ytd structure based on the above monthly data would be
......Company.. ....ytdM1...ytd M2....ytdM3.... ytdM4...ytdM5.. ..... .etc
The Company........ 10........30 .........60.... .....100....... 150...Leave a comment:
-
Nope you are not missing anything its me who has missed it,I apologise for that its just that we get data with a lag of 1 to 1 and half months so in march 2008 I have to make a report based on the feb 2008 data.
Also 2010 was coming because "-" was missing in the 59th statement of the query.
But finally the months got alright and are capturing the right data now as I just manupilated the date function which...Leave a comment:
-
I checked the query,It worked but still the months are not adding up as they should.and the dates are not macthing as the years are adding upto 2010 also the months are getting started from april2005 rather then feb2005.
Thanks&RegardsLeave a comment:
-
Exactly thats how I am doing this first I sumup and eliminate repetition and then we calculate the YTD from the monthly sales for both Products and Companies.
Meanwhile I did what you said and I changed the "YourLinkedTabl e" to my query name which is "0_Company_Mont hly_Total_Sum"
Also as you said I removed the where clause so it looks like this
SELECT DateAdd("m",-33,Now()-day(now())+1)...Leave a comment:
-
This is absolutely how my Data looks like, but there are certain issues,There are around 173 companies in my database and in your above query I will have to replace "The Company" by the name of a respective company from my database.
Also the next step in this report is to get the YTD (on the similar lines) for the products which are around 1700 in number.
I just had one idea and that can we somehow categorize...Leave a comment:
-
Sir, first of all Thanks for your reply and I am sorry I got you in this mess.
But there are few questions I need to ask:
Q1 Do I have to replace "YourLinkedTabl e" in your query by the name of the Query from which i am gettting the total months data.(I am actually retrieving this data from another query in which I sumup the monthly sales of each company as the names are repeating)
Q2 Can we...Leave a comment:
-
Calculating YTD
Hi everyone ,
I have an urgent report to make in Ms Access and consider me a beginner.
The problem is that I have data in an excel sheet which i have linked in the Access.It is a Pharma data and I have to calculate YTD sales for some Companies.
Its a 37months data and the months are categorized as M1,M2....M37 where M37 is the latest month. so the calulation for ytd would look like as
Ytd... -
Hi
Thanks for replying,But Sorry I am still confused.
Do you mean I should make different tables for sales,month,and year.
Also I forgot to mention in my query that all these sales are for products which are thousands in number.so actually data looks like this.
Prod Jan04 feb04 mar04 April04......se p07
AA 30 40 50 60 58
BB 70 40 ...Leave a comment:
-
creating dynamic formulaes in Access
Hi guys,
Its my first post and i hope that you will answer my query.
I want to transfer my salesdata report from excel to Access and The issue I am facing is that there are lot of formulaes in my excel file which are used dynamically.for eg.I have this monthly sales data
jan feb mar apr
30 40 10 56
So YTD sales for FEB would be sales of jan+sales of feb and so on....
No activity results to display
Leave a comment: