Search results

All, happy thanksgiving and thanks in advance. Attached is a data for this question. The requirement is to project monthly income for a user-selected From/To date. In the attached Database there are 3 tables: Assignments: This is the source data I have to work with. Fields descriptions in...

Simplest question ever and I can find the answer. I have a form [Accounts] which reads from a single table [Account.Data]. There are a few fields in the form and table, one of which is [Status]. I want a combo box at the top of the form that filters the [Status] field. The default value...

Thanks. I think my question was more about the underlying query and how to segregate and add the data by month. Your post is on the text boxes that will act as the filters, which I also needed, so thanks. If I should move this to the Query section of the forum please let me know.

Thanks in advance for any help. I need to create a report with projected earnings over a series of month end dates. The source table looks like this JobName | MonthlyAmount | StartDate | EndDate Job1 | $500 | 1/31/15 | 11/30/15 Job2 | $750 | 3/10/15 | 9/30/15 Job3 | $600 | 2/20/15 |...

The project requires that projections are done for monthly profits. The monthly estimated values are known = [MonthProfit] The Date ranges to which the projection applies are: [StartDate] and [EndDate] Given the following values: [MonthProfit] = $2,500 [StartDate] = 3/1/17 [EndDate] =...

Thanks to both. I'll give your suggestion a try

All, Thanks advance for the help. I have a form with 2 columns that need to relate. Both columns read from the same underlying table. Form Name: [Contact Skills] Form Fields being used: [Applications]; [Process] They both refer to the underlying table: [AppTable] The related...

Perfect. Thank you very very much

All - any help on this one would be appreciated In a master form (Form1) I have an embedded subform (Subform1). The subform will add records (rows) over time, so the height of the subform will of course grow. Right now the Form1 row height where Subform1 sits is fixed, I had to make the...

Easy one for anyone out there with skills... not me obviously. I need to filter a split form, including wildcards. Preferably I add a text box in the non-datasheet section, and the user types the string they are searching for. The datasheet then is filtered to just those rows that...

The attached database has your code and the following changes. I learned a lot from looking through your code and running a few tests. Thanks again for your help with all of this. “FYI” notes 1) The SOURCE table now has the correct information, and in the sequence that it will appear in real...

I'm really sorry for the different fields in the sources. The right combination to make a records unique is Account, Security and Date, as you noted. I'm working on a few different projects and may have attached the wrong one. The security code should be in there. If needed I can create one...

I need the results of the two queries aggregated together and then sorted and grouped. The _PRIORVAL query creates data I cannot create in the _ENANCED query and the UNION of those 2 queries needs to be sorted once put together. At this point I'm only looking for the syntax for the GROUP and...

Plog - thanks again. Im not totally getting what to. I hope the following helps. The data all starts in a table called Source. Two queries are run to setup and crate the data I need. Best I can tell I cannot merge these into 1 query, which leads me to the UNION concept. The two query names are...

Plog - thanks for the note. I actually already have the data in queries. The two entities I called Tables are really queries, so the source data is already setup as best I can. Given the nature and source of this data there is no way to get it into the same source table. Yes, agreed unions...

OK guys embarrassing question. I need the SQL to for the following , to GROUP Account_Ref, Account, AsOf, AND SUM BOPMV, EOPMV, Prod_Inflow, Prod_Outflow I keep messing with this and am doing something dumb.... Here is the query... SELECT Account_Ref, Account, AsOf, 0 as BOPMV, Prod_EOPMV...

All, Thanks again for all the help. It is really appreciated. I had to put this down for a week so sorry for the delay. Attached is a new database with a more data, but for upload reasons I could not send the whole thing. In the production version of this database there will be...

Hello all, Could use some best practice advice. Is it better to write a query and then create a form that reads/executes the query (as different objects) or is is better to develop the query from with the form itself. I see the advantage of a seperate query if it will be used by different...

Re: Stored procedure - can someone point me to a good how-to Stored Proc for dummies thing? I looked around and all of them take me outside of Access and into SQL server.

Unfortunately there are well over a million records and some of my queries are 4 deep so the database is getting hard to manage. If nothing else there are just so many queries to keep organized. I've tried consolidating them but it is not so easy considering the data I'm starting with and the...