Search results

When I entered the StartDate of anything greater than 07/16/1999 in this select query qryCrosstabTotalsDated (not a totals query, a regular select query) I'm getting an error that reads: The Microsoft Jet Database Engine doe snot recognize ''as a valid field name or expression...

I've been working on a database that has been converted from Access 97 to Access 2000 and then replicated. A few questions(I'm new with Builders.) -I lost 2 Macros, but not the Macro names. When I try to open up the Macro, it kept giving me the Expression Builder instead of the Macro Builder...

I created a replica of a database using "Tools-->Replication-->Create Replica...". The replicated database replicated tables and queries, but the forms and reports didn't get relicated. So I went into forms and did "File-->Get External Data-->Import" and try to import the forms in. It let me...

I created a crosstab query from 1 table with the following fields: -Group by Activity_Type, Collaborating_Agency, Duration as row headings -Group by Client_Type as column heading -Sum of No_per_Client_Type as value The following is the raw SQL: TRANSFORM Sum(final.[No_per_Client_Type]) AS...