Search results

  1. B

    Left Join is not supported, how could I do that?

    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...
  2. B

    Select field as a from tbl where a=... Won't work?

    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...
  3. B

    Help in my query with Where in

    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...
  4. B

    How could I put variables from modules to RecordSource Query?

    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...
  5. B

    How could a report/form knows which form is calling it?

    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,
Back
Top Bottom