Recent content by ecuevas

I have two tables in the same database. One of them is linked to another databse. The tables in the same DB have some fields that are the same. Can I make it so that when I type something into a form it is added to the corresponding fields in both tables?

I have a database that was created in access 2003. When I try to open a form in access 2007 i get an error message that says "the expresion On Click you entered as the event property setting produced the following error: the expresion you entered has a function name that microsoft office access...

Does anybody know of any incompatibilities between access 2003 and 2007?

I am using this average on a report. In Design View I double clicked the text box and changed Decimal Places to 2 but it still gives me 7 numbers after the decimal.

I have a query that finds an average. How can I get the average to only show two numbers after the decimal?

I got it to work. Thank you rainman.

how do I get a form to open up when I open a report.

Is there a way that I can get the dates onto the report from the query prompt instead of the form?

It says I did not enter the And in the Between...And operator

I changed it to Between ([Customer Complaint Log].[Date of Complaint])=[forms]![AVERAGE].[startdate] And ([Customer Complaint Log].[Date of Complaint])=[forms]![AVERAGE].[enddate] but it doesn't do anything when I run it.

I got the dates to show up but now the average won't show up.

I think you misunderstood my question. I already have a prompt. I just need the dates that I type in to the prompt to appear on the report.

What would I put in the report?

I have a report based on a query that finds the average response time. When I run the report it prompts me for a begin date and an end date. Then the report shows the average resopnse time between those two dates. How can I get the two dates I entered to show up on the report?

Nevermind I fugured it out. I put the parameter values in the COUNT query instead of the AVERAGE query.