Search results

I have one query(qry1) that has 4 fields in its output DeskNo ProcessID FullName ProcessText I have another query (qry2) that has same 4 fields as above. The DeskNo can be same also in both of the query output. I dont know how to merge the 2 query outputs. What query should I write to...

If you are getting the parameter from a form's control like say a textbox, then it will be a string. So, type cast and convert to data type matching the field.

I am running a parameter query in VBA code and although I specify the parameters in the form, I get rumtime error : too few parameters. How do i fix this error???

Thanks for your reply. I just figured it out what Rich suggested. It is working when I specify the type of the parameters in the crosstab.

I tried moving the parameter to the crosstab, but still i am getting the same Jet engine error??

If I move the criteria to the crosstab query then my query will be lot slower since it is not limited by the criteria.

I have a parameter query (BaseQry) that takes the parameters from the Form. THen I built a crosstab query using BaseQry. But when I try to run the crosstab, i get the following error - Microsoft JEt Engine doesnot recognise [Forms]![ReportMenu]![StartDate] as a valid expression. But if i...

How Do i send the totals to the excel sheet??? Can u please tell that???

How do I create a new temporary table from a parameter query?

Actually I have created a report in my company . The report has a title and a totals that is a total of column 3 of the query. Since,I was asked to generate a excel output so that we can send to the customer. My excel file should match the contents of the report ie the title in the beginning...

It is a parameter query and I would like to construct a temporary table by running the query in the VBA code.

How do I output a query to a table?

I want to add a title to the excel sheet after outputting the records. How do I do that?

I have a parameter query whose output goes into a report. But, I want the output of the parameter query to go into a excel sheet. How do i do this??

I have generated a report. My report has a Report Name in the beginning and Total in the end. I am sending the report output to an excel sheet. But the Report Name and the Total is not preserved. Is there a way to do it?? OR How to a edit the excel sheet to have the Name and the Totals...

Actually it is checkbox that the user checks if applicable. I am assigned to create a report with a count of selected checkboxs.

I have a field that is of type yes/no. My SQL view of the query is as follows: SELECT Count(QryRptMac.VioceMAC_ID) AS CountOfVioceMAC_ID, Sum(QryRptMac.Handset_New) AS SumOfHandset_New FROM QryRptMac HAVING (((Sum(QryRptMac.Handset_New))=True)); My result is FirstColumn...

I have a query that generated a report with 4 columns. I have sorted in my query the second and third coulmn. WHen It gets displayed in the report my output matches expected ouput as per the ordering of values in the column. But when I try to sum COlumn 4 by using the sum function the sequence...

I want to run a query in VBA and I know the query will always return only 1 record. I need the fields in the result record for further processing. If I run like this DoCMd.OpenQuery "QryNAme" the query runs , but how do I capture the result for furtehr manipulation.

I dont see a need for normalization. The Q1,Q2,Q3,Q4 correspond to one request. It is just the way of displaying has to be different.