ms access - Date parameters in query -
i have form enter data. sort order, start date , end date. once data entered, report generated. , error. error: "the microsoft access database engine not recognize '[forms]![auditptetotals]![startdate]' valid field name or expression. this crosstab (auditptetotals_crosstabdaterange) query uses data retrieved query (auditptetotalsdaterange) transform sum(auditptetotalsdaterange.ptetotal) sumofptetotal select auditptetotalsdaterange.companyname, auditptetotalsdaterange.regnum, sum(auditptetotalsdaterange.ptetotal) [total of ptetotal] auditptetotalsdaterange group auditptetotalsdaterange.companyname, auditptetotalsdaterange.regnum pivot auditptetotalsdaterange.description; and auditptetotalsdaterange select customer.regnum, customer.companyname, scraptiretype.description, scraptiretype.pteamount, scrapcollectiontiretype.amount, scrapcollection.ptetotal, scrapcollection.date (scrapcollection inner join customer on scrapcollection.regnum = customer.regnum...