Search results

I don't have anything built yet. Wanted to see how best to do it before I dove in. The DB will have 7 or 8 sets of table comparisons like this, all with different fields, so that is a lot of iif's to write.

Here's one for you. I know how to do this with a load of IIF statements, but would rather avoid that.... I have 2 tables - Source - Enhanced They both have the same fields (12 in each table), and relate through a field in both called [AccountNumber]. What I want to do is create a query that...

Got it - both responses were helpful, thanks

Quick one - I'm a newbie. The following Group by logic is not working. What am I missing?. Thanks for the help. I'm sure it is a semi-colon or something in the wrong place. Code: SELECT Sec_Key, Sec_SourceKey FROM SecurityMaster_Source UNION ALL Select Sec_Key, Sec_SourceKey FROM...

All, Thanks in advance. I'm stuck. The union query below has 5 fields and 4 underlying sources. Problem is - not all sources have all the same data, and when I plug NULL it changes the formats of all the output to text. All should be number formats. Unfortunately I cannot plug "0" instead of...

This worked really well but in a different way - I added a new fake subquery (table) with just one fake record that had all the fields in the following 5 real subqueries, with appropriate value formats. Then when I added the other real 5 subqueries they followed the format of the fake one. I...

Thanks - that's a great tip, but I'm getting a "Number of columns in the selected tables don't match.... " blah blah error. Here is the actual code. Did I do this the way you explained? In the first subquery - the first 4 fields are text, and the last 5 are value types. SELECT [Portfolio...

All, Thanks in advance for the help. Problem is: I have a union query that merges 3 separate prior queries. Each of the 3 has slightly different data (data type fields), so I have to create some null or blank fields for the mis-matched fields. Like this (shorthand using Null as an example)...

All, Thanks (as always for the help), I have the following delete query giving me the "Could not delete from specified tables" error. DELETE DISTINCTROW DuplicateGTW_4_RecordsToDelete.MaxOfData_ID, Data_Start.* FROM DuplicateGTW_4_RecordsToDelete INNER JOIN Data_Start ON...

All - thanks for your input - and sneuberg - for the db samples. This makes more sense now. I'll move the functionality to a form and consider this thread closed.

Sorry this I still not working. I attached the DB. A few things. 1) I entered the IIF statement in the query. It does not seem to be reading from the [Combo105] value. 2) [Commissions] seems to run in a loop for 10 seconds after a date is entered. 3) Strangely [Combo105] is showing in the...

sneuberg - thanks. Im getting a syntax error with: Private Sub Combo105_Enter () IIf(IsNull(Reports![Commissions]![Combo105]), [MonthEnd], Reports![Commissions]![Combo105]) End Sub

Ranman - thanks but if I read your note right that means I have a button to open the report. I'm trying to filter the report after it is open based on a combo box value that can be dynamically changed and re-filtered. The body of the code you wrote is probably the same, but maybe it belongs in...

OK easy one for anyone that knows Access. I have a report named [Commissions] With a combo box in the header of the report named [Combo105] referencing a tale of dates The underlying query that [Combo105] will cross-reference is called [MonthEnd] So the question is: When [Commissions] is open...

Thanks in advance for any help. Simple stuff, I'm just stuck. I have a report Called [Financial Projections] that shows a series of months. I'm trying to filter it while in the Report. 1) I want to add text boxes for FromDate and ToDate so the user can dynamically filter the dates...

Plog - I'm being a little dramatic for effect. You are completely correct that a single referenceable query could solve the problem, but I'm trying a different approach in part to learn how to use Public functions and in part based on how the rest of the DB is setup.

All, Thanks for the help. Here is an easy one for those of you that know what they are doing.... I'll have a formula that will be used in 10 queries. I'd like to setup one Public formula and reference it 10 times instead of having 10 separate full formulas in the 10 different queries. I...

I got it. Simple iif statement. Thanks everyone for the help

stopher - I tried that method and could not get the query to work. I cross referenced the Assignments.YYYY_MM_StartDate and YYYY_MM_EndDate fields with a table of Month ends, using the same YYYY_MM format and no luck. Do you have any recommendations on how to get the results to come out as in...

I'm going to close this thread and move it to the Query section. I did not describe the problem very well. Thanks for the help.