Search results

I put a form in front of the query and that helped. Thanks.

I have a UNION query that I pass two parameters to but those two parameters are used in both sides of the union. SELECT bill.TripDate AS Bill_TripDate, bill.voucher_nbr AS Bill_Voucher, bill.fare AS Bill_Fare, tbl_from_xl.TripDate AS XL_TripDate, tbl_from_xl.voucher_nbr AS XL_Voucher...

Thanks, that helped.

I have two queries that I use a UNION to combine the results. However, I am losing records from the top query. Why? If I run the top query alone I get all the records expected. Here is the query: SELECT bill.TripDate AS Bill_TripDate, bill.voucher_nbr AS Bill_Voucher, bill.fare AS...

I have not worked in Access for a while and now I have been tasked with writing some queries in Access 2000. Here is my simple query: SELECT tbl_from_bill.TripDate, tbl_from_bill.voucher_nbr, tbl_from_bill.fare FROM tbl_from_bill AS bill, tbl_from_xl AS xl WHERE (((bill.voucher_nbr)<>...