Search results

ok, i think i have a handle on this now, thanks so much Paul, when the report is widely loved i will give you a footnote!!

Would you be willing to show ow that SQL view looks?

well i attempted the <> as i want the record where the amount is not equal, trying to find if the Date, Driver and Amount in one table is not in the other table then add to the query, but i am continuing to hit road blocks. should i create the following queries table 1 unmatched date, table 1...

SELECT FuelmanImport_tbl.[Transaction Date], FuelmanImport_tbl.[Cardholder Name], FuelmanImport_tbl.[Card Expiration Date], FuelmanImport_tbl.[Prompted ID], FuelmanImport_tbl.[MCC Description], FuelmanImport_tbl.[Merchant Name], FuelmanImport_tbl.[Merchant Address], FuelmanImport_tbl.[Merchant...

yeah i am a little stuck tying to write the three selects and froms

Thanks Paul i will try working the union.

I am trying to create a query where i look at the [date],[driver],[amount] from table E and look at the same fields in table F and i need to know all the entries where they do not match. the inner join i am creating in the SQL view of Access (i cannot right code very well in VBA) is returning...

it looks like doing that and combining the tables in a query worked. thank you!!

the card will always stay with the same van, regardless of driver. I guess i am not sure how to link the tables if i do not need the van number in table 2. If i run a query on van 101 for between [startdate] and [enddate] on a parameter form, how do i link it to pull all the transaction details...

Hi i am somewhat new to access, self learning by google and these post for the past 6 months. i have two tables, Table 1 has Van Number and the vans gas card number (credit card) Table 2 is uploaded from an excel report weekly into access. it has a lot of transaction details and the gas...