Search results for query: *

I have a current project I am working on which shows the percent of sales completed. There are two fields called Sales Quota and Individual Sales. I want to using the ProgressBar6 active X control that shows a bar showing the percent of the individual sales to the sales quota. I have checked...

Actually this is a two fold question. (1) I am developing a database that titles of documents are linked to the pdf version of the document. For example, there is a form called frmFADocuments and based on a parameter query it can pull up documents for any year as the parameter query ask the user...

You could develop a query that will count the referrals. I am assuming that you have a provider index code for which to count. Then create a macro that runs when the form opens it runs the referral count query and displays the number of referrals in the appropriate box.

I actually solved the problem by developing a query that would not pull those records that had a null value. Then from that query I built another query with the first and last functions. It then did not matter if it was for year 2001, 2002 or 2003 and it compared the values to 2005. Thanks so...

I have a report that has several sub reports in it and within each subreport there is at least two subreports. I have data for fiscal years 2001 through 2005. There is missing information in some 2001 fields but for the most part many of the fields do contain data for 2001. Ex. Total caseload...

That worked... Thank you so much... I can adapt it to the other 8 lookups I have to do and I see what is making it work correctly now. Thanks for all you did!

I don't think I explained this well enough to say what I am trying to do. I have 1 table called tblFFIncStd which is my lookup table. I have a second table called tblbudget which my form is based on. I have two fields on the form one called BeginBudStd and the other NSAG. In the lookup table...

OK, When I added the following code: ","[dteBeginDate] = #" & Format([Forms]![frmFFBudgetEntry]![BeginBudStd], "mm/dd/yyyy") & "#") & " " & then I got stuff I did not need. For example, I should have gotten when the year was 7/1/04 I should have gotten a standard of 1713 and when the year...

Hello, I have the following code in a text field called GIS. =DLookUp("[GIS]","tblFFIncStd","[dteBeginDate] = " & [Forms]![frmFFBudgetEntry]![BeginBudStd]) & " " & DLookUp("[GIS]","tblFFIncStd","[AGSize] = " & [Forms]![frmFFBudgetEntry]![NSAG]) I am trying to pull over data from one table...