Search results

Hi Banana, I have tried to replace all inner join with left join but Access 2007 gave me the exact same result. Can you please give me a little more details on the 2 alternative solutions you suggested? Thanks.

Hi all, I have a working inner join query, but right now it is need to modify them as left outer join. However, Access 2007 complains it is not supported. Here is my Query: SELECT EName, Sum(tPOItems.Charge*tDelivered.DQuantity) AS Amount FROM tClient LEFT JOIN (tPOin INNER JOIN (tPOItems...

Hi all, In Access 2007, I tried to execute a query like this Select field as a from tbl where a="123" Access returned a popup box a asked me what is "a". However, if I do something like, Select field from tbl where field ="123" and it works. Isn't this specific to Access? If so, how...

But right now the biggest problem is that Access complains that: You have written a subquery that can return more than one field without using the Exists reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one field. Can someone please help.

Hi all, I have a query which purpose is to delete All records in table B which do not exist in Table A. The query look like this Delete From tTempPOOutSpInst as A Where (A.ManuID and A.POOutNum) in (Select R.ManuID, R.POOutNum from tTempPOinItems as L Right Outer Join tTempPOOutSpInst as R...

Thank You so much.

Hi all, My problem is that the report needs to process the variables in the Open event and make the RecordSource. If I use something.recordsource in the module, I couldn't choose which field to display in the Report Design View. So I would put that query directly in the RecordSource property...

Thanks. It is not exactly what I desired but it also works perfectly fine.:)

Hi all, For example, I have form A and form B which will call report C. However, report C needs to know if Form A or Form B is calling it so it will get the information the right way. So, how could report C know which form is calling it? Thanks,