Search results

My mdb is not on a server yet. Is there any potential problem by putting on a server? Is there any way around why I can't see all queries please?

It's working now even though I did not change anything! When I try to import data from my database to Excel. I don't see all the queries in the DB end. Do you know why is that please? Also, a folder called 'My data sources' was created automatically in my documents folder! What is that? Thank you,

It's in the spreadsheet.

Hi, I have creatd an excel sheet that imports data from a query. I changed database location and changed the path by going to Data > import external data > edit query to reflect the new location. I saved and double checked that the path is the right path. However, whenever I press the refresh...

Found it. Thank you.

Hi, I can't find Office 2007 beta2 in microsoft's website anymore. I wanted to try it, but I don't know if it's still available for download or not. There is only a 'test drive' available! Has anybody been experiencing the same problem? Thanks, B

The book suggested by The Doc Man is excellent. I am reading some chapters of it at the moment. The author is called: Barry W. Boehm. Planning and updating the plan regularly is the key I think.

Hi, I have googled this; however, I could not find any templates/exmaples of time boxing. I only found definitions. Do you have an example template that you could share please? Regards, B

No, my query is not returning duplicate rows unecessearily. For each line in the query, it returns many different rows. I was thinking if there is a way instead of having the extra information dispalyed in a new raw, I want it displayed under a new heading.

Hi, I have made a query from different tables; however, my query is returning about 5 rows for each person because some fields in the query return more than 1 row. Is there anyway to fix this problem? Thank you, B

I need these two attributes. Is there any way of keeping them and getting the calculation right?

Hehe, Sorry. Ok, basically, I want to sum the values of the attribute VO_Price. The current values the database is returning are 656 and 2000. Both these values belong to customer number 2 and therefore they should be sumed up. Some customers don't have VOs. Hence the nulls. Do you think...

That did not work. it only took away the decimal point of the 'VO_Price'. Did it work for you? I want it to display the total of 2000.00 + 656.00. = 2656.00

Hi, Is there a recommeded limit to the number of attributes a query can have? especially if that query is used to print reports? If a query grows so big, what are the procedures that should be followed? Regards, B

Will do. Thank you.

Alright, I see:) Thank you.

Hi, I have used sum() function in a query where I have got other attributes. However, the sum() doesn't work for some reason. I could not attach my database as its size is too big. i have uploaded it to this server where you can download it. aimreda.co.uk/db Any help will be very much...

use the sum function.

Interesting post The Doc Man. I did not understand the parts that talked about 'Autonomy ' though.

What is the advantage of starting your application in run time?