Search results for query: *

Somthing like Cust LastYr ThisMonth YTD CO A 1500 230 1300 CO B 2000 500 1800 CO C 3000 100 1500 I have table with sales data for last 2 or 3 years and when I get the...

Thanks it works perfect. Can I ask one more question? How would I put sales for <b>this month</b> with sales by year?

I want to create 2 reports from table such as below. Tble Cust Prod Sale$ date abc a1 10 200010 abc b2 20 200105 abc c3 10 200208 bcd a1 30 200204 def c3 10...

Error is saying that one of the value is null but it is for different form. How do I declare it for different form? because I just copied the vba from different form and recycling it on another one. Thanks,

when debug this line is highlighted LastNum = CLng(Me![RECORD #]) what is Me!?

Someone please explain what this code do? Sub NewRec() Dim LastNum As Long Dim NewLastNum As Long DoCmd.GoToRecord , , acLast LastNum = CLng(Me![RECORD #]) NewLastNum = LastNum + 1 DoCmd.GoToRecord , , acNewRec Me![RECORD #] = NewLastNum End Sub I use this for...

Thanks so much for ur help tho, grnzbra

Hello, I am using access2k and I did it. mdb size has reached 2gb and db locked up i think. I can't open or access in anyway what so ever. try import from new table and use compact and repair and don't do any good. What should I do? Is there anyway to access the data without upgrade it to sql...

Grnzbra, I tried but it does not work. Funny thing is I don't get any errors and the DB is is just not responding. I shoulda split the DB long time ago.

I am running Access2000 on Windows 2000. The database is over 2GB and shows up as 1.99GB which is the limit for Access, I think. Can somebody help or suggest anything for me? I can't open it. Tried compact&repair and importing but I don't think any of them work because I can't open the...

Hrmmm... I tried Compact and repair but seems like the database is locked and nothing happens. Same for importing because I can't even get the prompt to show me the list. I guess this is more serious then I thought. -_- Should I upgrade it to SQL??? It seems like there could be some simple and...

Thanks guys for reply grnzbra, It is the whole database that is over 2GB not just one table. I have bunch of tables, queries and reports. Tom I will try and let you know how it goes. ^^

I just realize that there is 2GB file size limit on ACCESS 2000. I can not open the file at all because it shows up as 1.99GB. Please Any help will be very appreciated. ^^

Hey thanks for the reply and try the second method but it gives me the sum of the sales amout instead of the result I want. Am I doing something wrong?

One more thing all data comes from one table and tble a,b,c I have created from different period such as this year, last year, this month. What would be the best way to do this???

Hello I need ways to accomplish the following tbl1 name sales a 10 b 20 c 30 tbl2 name sales b 50 c 60 d 70 tbl3 name sales a 30 c 40 x 40 I want it to be like below: tbl1 tbl2 tbl3 a 10 30 b 20 50 c 30...

Some are general, text, and number. I have already tried paste by values but it didn't work. I even used the format brush but still same. One thing is that I get the data from mainframe if it helps any. Thanks,

Hello, I get the file from mainframe but for some reason the formatting is different and having trouble importing certain data to access. I have try change format but i didn't work. Visually when I look at the cell the alignment is different so I change the alignment but still data would not...

Hello, I am having trouble importing excel spreadsheet to Access but data in some fields are missing. The missing data have different alignment from the ones that were imported. I try to change formatting but it didn't work. So what should I do? Now it is more of excel question than...

Hello, I have to create report every month comparing datas from last year to this year like May 2001 and May 2002. Currently I change dates eveytime I run the reports. What would be the easiest way to set this up without having to make changes. Also, I have to do this for about 20 or more...