Search results

Easiest question ever I am sure. I have a report [Report1] that gets its data from a query [Query1]. On [Report1] there is an unbound text box [EnterEndDate] that I want to use as a filter for the report criteria, and have it filter the report to show every report row with the value in the...

The 19 vs. 22 days part does not matter much to me, so either way is fine. Considering what we are using this for it does not matter, so either way you like. I am using 19 because people take days off and are sick so over the year it averages to about 19 or 20. ((5 days / week * 52 weeks a...

The 19 days [MonthlyProfit] is not critical, I just have it for the months that will be full to make the reporting math easier. You can use the daily and calculate up from there. I assume a month is always 19 working days since this is an average. If we can do actual working days for each...

Trying to get a formula or function for calculating profit for each month between selected dates. Partial month calculations are required. Source Data (record) examples: · Contract1: Startdate = 6/30/12; EndDate = 9/22/12; DailyProfit = $500; MonthlyProfit = $9500 ·...

So I did a left join taking all records from T1 for AccountNumber and MonthEndDate (I think this is what you meant) and got 6 good records and a 144 blanks. Sorry - I am not sure how to do the second part - capture the T1 values if they do not exist in T2.

I have a union query with 2 source tables T1 with 150 records T2 with 6 records each table has 4 fields in each MonthEndDate AccountNumber Value SourceTableName When I do the union query all 156 records result, but that is not what I want. If the same AccountNumber / MonthEndDate...

This is really great, thanks. Wil try it later but I'm clear so we can close this one.

anscombe - This is exactly the right idea, thanks so much Syntax: Result = DLookup(<fieldName>,<tableName>,[criteria]) Code: Public function getCycleDates(byval theCycle as string)gvFromDate = DLookup("fromDateFieldName","dataTableName", "yourCycleFieldName = '" & theCycle & "'" gvToDate =...

Defining SUers is one way to associate the values to a table, correct, but it is overkill for this app. What I really need is the ability to assign the results of QueryX to global valiables. Specifically: QueryX Returns [FromDate] and [ToDate]. What is the Public Function code to capture...

Thanks for the reply. How can I store a constant in a table when I have a split/shared database with many users accessing the same tables? If there is a single table with the selected date range then every user's session will be forced to use the selection in that table. I want each user to be...

There are results of a query that I wish to use as contants through my database and I'm not sure how to set this up. Background: The database will support different users who will request different data. For example, user1 may request data from "Test Cycle A" which is from 6/30 - 7/31, and...

I have a navigation form with a number of tabs/forms. As I move from tab to tab any filters that have been applied (form the sort and filter group) are removed. The user will have to toggle between a number of different forms, filtering each as needed. How can I keep the filters on forms so...

The value is incrementing with data entered in the popup. 1) the popup fields are completed by the user 2) user clicks the submit button; an append query is triggered to load the entered data into a table, and the assocaited queries that read that table automatically update. These steps work...

It is not a combo box, but a value that gets incrementally updated each time an entry is made into the "Popup". I tried: Forms![Form].[FieldName].Requery in the On Exit event in the Popup close button and nothing happened. I know that code in the Popup's On Exit event will update the Form...

OK - thanks. Before I try this is it easier to have the "Popup" close and refresh just the "Field" on the "Form"? If the refresh/requery was done only on that one "Field" it may solve the problem since only that one field is impacted by the "popup" entry - but I dont know the code to do a...

Background: I have a form "Form" that contains a data entry popup form "Popup". The data entered into "Popup" populates a table and through a query "Query" the important information from that table populates a field "Field" back into "Form". There are 1900 records in the database, the...

Unfortunately no. Far too much sensitive data to strip out.

pbaldy: Sorry, i reversed the wrong ones. Here is the current code. Now I get "Division by zero" error in the step noted below Private Sub PriceDietzUpFilter_AfterUpdate() If Len(Me.PriceDietzUpFilter) > 0 Then Me.Filter = "PriceVsDietz = " & Me.PriceDietzUpFilter Me.FilterOn = True...

Accessmsql: I did as you suggested and when the form was opened and I try to enter a value in the filter field again I get the message: "The expression after update you entered as the event property setting produced the following error: Ambiguous name detected: Pricedietzupfilter_AfterUpdate."...

AccessMSQL: I think I tried you suggestion correctly and got an interesting result... I used the Access filter on the PriceVsDietz field and in the Number Filter option typed "1". Up popped the error "Enter a valid value"