Search results

I finally got it figured out. I went to the underlying query and placed the expression in the field line of a blank column and saved it that way. Going back to the report's design view I dragged the newly created expression to the page, created a label for it, and all worked out. Thanks so...

Sorry for the late response, but got busy at work late yesterday. I actually created a brand new query and report hoping that the date calculation formula would work from scratch. But having the same problem. Which is strange, considering the same exact formula works just fine when I used it...

I realized that I included the initial brackets after I sent the reply and went back and removed them around Date(). I ended up with the same formula as the one you have. However, I still ended up with the same issue. When opening the report I still get the date parameter dialogue based on the...

Thanks. However, if I enter the following formula: [Date()]-[DateReceivedinADR] into the control source for the unbound text box, then open the report, I get a date parameter dialogue box asking for dates. I just want to capture the number of days that have elapsed between two different dates...

I wasn't sure in which forum to ask this question, but here goes. I need to know the formula for determining the number of days between the "current" date and an earlier "fixed" date. The report shows cases that are still open in our office. Besides other criteria, I want the report to...

(Access 2007). I am having trouble creating a macro for a search button I want to place on my form. I want users to be able to click the button and then search for a specific record in the database based on the criteria of that particular field. Form Name= frmInventory Text Field= HPDNo...

I am running Access 2007. On my switchboard I would like to create a link to a stand alone PDF file located in a folder outside of the database. If I go to the External Data tab in Access it allows me to link to many different types of external files (text, HTML, XML, etc.). But I don't see...

pbaldy: Sorry for the late response, but just got back. Thanks for the tip, it did the trick. I appreciate your prompt assistance.

We have just updated to Access 2007 from Access 2003. As with any MS Office upgrade it requires weeks of wasted time learning where MS stuck once familiar commands. But that's another story!!! To wit: Having just created a form in Access 2007 that includes many text boxes, I now need to...

Thanks Beetle, now I feel really stupid :) I remembered it being a really simple expression, but I kept trying to make it more difficult. Appreciate the quick help.

I know I should know the answer to this, but it's been awhile since I've had to design a query. I have a table that includes a column named Status. Data entry for this field is limited to only two options: either Open or Closed. One of the queries on this table includes Status. If I want the...

As soon as I clicked Submit to send my question I found the icon. I am still getting used to locating functions with 2007's new menus and toolbars. Still transitioning between Access 2003 and 2007 and was looking for the Insert function that I was familiar with. Oh well...

I have yet to figure out how to insert a hyperlink in a report using Access 2007. I want to link to a Word doc on my computer. In Access 2003 it was very easy. Help.

Regarding an Access 2003 db that sits on a network. Occasionally one or two users will not be able to open the db (i.e. clicking on the db name in the Explorer directory tree will result in nothing happening at all) until everyone else has closed out of it. 99% of the time this group of six...

I have a calculated field in a report that keeps a running dollar total of invoices. The field name in the table is InvoiceAmount and the calculation is =Sum([InvoiceAmount]). Everytime a new invoice amount is entered in a form it automatically updates the report with just the new total dollar...

John, I keep getting a syntax error in the From clause whenever I enter the name of my table (I substituted the text myTable in your code with the actual name of the underlaying table the query is pointing to). And I think therein lies the problem. The database I am working with was created...

Thanks for the reply. I created a new query, selected the field named FacilitatorAssigned from the underlaying table, and entered your information under criteria. However, when using your query I get an error message stating "the syntax in a subquery is incorrect." Can you look at it one...

I have a report that lists the total number of mediation cases we have processed, along with other related relevant data for each record. The report is sorted so that the individual mediators are listed in order by their last name. This way we are able to easily keep track of the number of...