Search results

  1. E

    Linking Tables

    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?
  2. E

    Form will not open in access 2007

    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...
  3. E

    Incompatibilities

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

    Average

    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.
  5. E

    Average

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

    Begin and End Date

    I got it to work. Thank you rainman.
  7. E

    Begin and End Date

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

    Begin and End Date

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

    Begin and End Date

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

    Begin and End Date

    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.
  11. E

    Begin and End Date

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

    Begin and End Date

    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.
  13. E

    Begin and End Date

    What would I put in the report?
  14. E

    Begin and End Date

    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?
  15. E

    Find Average

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

    Find Average

    I figured it out. I used: SELECT [Customer Complaint Log].[Complaint Number], [Customer Complaint Log].[Date of Complaint], DateDiff("d",[Date of Complaint],[Effective Date]) AS Expr1 FROM [Customer Complaint Log] WHERE ((([Customer Complaint Log].[Date of Complaint]) Is Not Null) AND...
  17. E

    Find Average

    I need to make a query which counts the number of days between "Date of Complaint" and "Effective Date". This is what I have so far: [SELECT [Customer Complaint Log].[Complaint Number], DateDiff("d",[Date of Complaint],[Effective Date]) AS Expr1 FROM [Customer Complaint Log] WHERE ((([Customer...
  18. E

    Chart Adds Days

    I think there might be something wrong with my x-scale but I can't figure out how to change it.
  19. E

    Chart Adds Days

    I have an access 2003 database that shows when customer concerns were reported and when thay were resolved. I have a query that calculates how many days it took for each concern to be resolved. I used the query to make a report that shows all concerns which took more than 14 days to be resolved...
  20. E

    Dates

    How can I count the days between 2 dates and then make a report that shows when there are more than 14 days between the day something is reported and the day it is resolved.
Back
Top Bottom