Search results for query: *

Hi erixire, Did you find the solution as i am also finding for the same problem. Pls help me out. Thanks & Regards, zyabc

Hello Duane, I want my report to look somewhat like this with no Employee ID. Customer 51 Customer 52 22/01/2000 12 15 23/01/2000 12 20 The 12,15,20 are the sum of SalesAmt. Using the below query i am...

Thanks Duane very much. I am able to import the file & execute it successfully. Hope i am able to implement this concept. Will certainly inform you if it comes out well. Thanks & Regards, zyabc

Dhookom i tried to import CrossTab.mdb file. Thanks & Regards, zyabc

Hello Dhookom, Thanks for the tip. I downloaded the file & it worked fine. I created a new database & imported the file into the database since i am not able the view the source. I have Office XP with me. When i try to execute the new file I get the error saying .Edit is not found. Which...

Hello Dhookom, I am new to MS-Access. So, please excuse me if i wrong anywhere 1) I am using Crosstab Query currently. But i learnt somewhere that if i use crosstab query it actually creates a table internally with all the dates. If the user enters adds some more records it will pose a problem...

Hello All, I have a problem like davi123. Davi123 did you do it in Crystal Reports or in MS-Access Reports? Is it possible in MS-Access Reports. Can you please reply to this question. Thanks Thanks & Regards, zyabc

Hello All, Thanks for your response quite immediately. The above is just an example. It may be even between dates. For Ex: 27/01/2003 to 27/02/2003. Hence i would like to put first 6 columns plus the city in the first page & the next 6 columns plus the city in the second page & so on... Is it...

Hello All, I have a doubt. Pls do clarify this for me. I have created a crosstab query like in the example which andie18 has given 7/4/03 7/11/03 7/18/03 7/25/03 Calls 8 5 3 2 Appts 3 2 4...

Hello All, I have created a report which has numerous column headings & row headings. I would like to split it into different pages & repeat the row heading & the remaining column heading. Is it possible in MS-Access Report? For Ex: City Jan Feb Mar ABC 1 1 1 DEF...

Hello All, I have created a cross-tab query wherein the "date column" is the column heading & the "city column" as the row heading. It is working perfectly. But when i implement this query in the reports it is not able to display the data in a single page. It is getting...

Do you mean section as Detail? Pls clarify this issue

Hello All, Is there a word wrap function for text box which displays data in the report Thanks & Regards, zyabc

Hello All, Can anyone please help me how to solve the following. 1) If i get products desc from product table... I also would like to include another item called "All" so that the combobox displays like this All,Product1,Product2 etc., Is it possible to do combine both Table/Query &...

Thanks very much Duane it works perfectly well. Thanks to all of you for your quick response & helping me out. Thanks.

In the form, the "from date" & "to date" is got from the user. When the "Submit button" is clicked I open the report with the help of "where condition". I don't know how to set the criteria for chart in the rowsource which accepts "form values&quot...

I would like to first thank you all for quick response & trying to help me out. GingerR: SELECT (Format([EntryDt],"Short Date")) AS Expr1,Sum([Entry Date Report Query].Account_No) AS SumOfAccount_No FROM [Entry Date Report Query] WHERE ((([Entry Date Report...

Thanks for helping me out. I would like to copy the data from one table to dummy table. How to do it in VBA?

Thanks for replying.... I want to create a graph based on Report. In the rowsource it is working for static data but not for dynamic data. Can you pls tell me how to go abt for that. Here is the sample Row Source i am working on... SELECT (Format([EntryDt],"Short Date")) AS...

Did u find out how to go abt for it. Since i am also looking for the similar solution. Pls help me out.