Search results

  1. B

    Report Header Problem

    I am new to using the report section of Acccess, so forgive me for not knowing the easy stuff. I am running Access 2003, on Windows XP system. I have created a report, and works fine, but when I go in and change the header information (I'm just trying to format the header), such as...
  2. B

    Date Parameter Input Mask

    I have a query that has a date/time field (mm/dd/yyyy hh:mm:ss), I have created another field using the following syntax " Sdate: Format([AgentCallDetailInCalls.StartTime],"Short Date") ", I prompt the user for a date using this sdate field I created. The prompt syntax is [Please Enter Start...
  3. B

    3 queries, Need Records from both even when the calculated value = 0

    (Phone usage report) I have 3 queries, Query 1 counts number of calls in for a phone extension. Query 2 Counts the number of calls out (dialed calls). The information is keyed on the phone extension. Query 3 runs the first 2 queries (By date via parameter). Each query is keyed on Extension, I...
  4. B

    Make Table Query Macro

    I have 2 query's, they both make tables, I have a macro that runs these 2 queries, and I would like it to run without prompting the questions: "Do you want to paste x amount of records to the table?" or any other prompts. Can someone tell me how to get around this? Thanks In Advanced. :cool:
  5. B

    Null value's in queries

    I have 3 queries, one generates a calculation for a phone extension, the other generates a calculation for another field for the same phone extension, in the third query, I am using the data from the first 2 queries to show the data side by side, but when I run the third query, if any of the...
  6. B

    Time Calculations or mis-caluculations in this case

    I have a query with 2 time fields, a start time, and an end time. I am subtracting the endtime from the starttime and I am getting funny numbers. Example: 12:12:04pm - 12:05:20pm and I am getting #Error. Where am I going wrong? Your help is greatly appreciated.:eek:
  7. B

    Table calculated field creation?

    Is it possible (and logical) for me to create a table with a calculated field from 2 other fields in the same table? Example; I have a long time field (mm/dd/yyyy hh:mm:ss) aka StartTime, and a long time field EndTime. I would like to subtract the StartTime field from the EndTime field to get...
Back
Top Bottom