Search results
-
T
Total group / sum bug?
I figured. Same with my tests. Sometimes it works. I'll post the db. -
T
Total group / sum bug?
All - thanks for your notes back. I'll post the DNA Friday night. Isla - always worked for me too. Add a new record with field = b and n = 4. Query that as it is with no total and exclude ID, then query the query and add the totals as you have it. In your example my issue produces a= 10... -
T
Total group / sum bug?
All, Anyone ever see a query Sum not work? Seems when there is only one record to Group by the related field being Sum(ed) is coming up 0 instead of the value in that one record. Same if Max or Min is selected. When there is more than one record bring grouped the related Sum is correct... -
T
Simple Union Query with Max, Group
:banghead:UGH! This is so easy and I'm getting syntax errors. I want to group the Activ_ID and Max the ActivEECO_UpdateDate fields. SELECT Activ_ID, Activ_DatePosted as ActivEECO_UpdateDate FROM Activity_Translated; UNION ALL Select Activ_ID, ActivEECO_UpdateDate FROM... -
T
Join with null values
Hey all, My query has multi-field joins between 2 tables. Is it possible to include Null values on both sides of the joined tables as equal values in one of the joins, so the records relate? In this case the first join is on actual values (the normal way), but the second could have null... -
T
Source Table as variable
Agreed this may not make sense. The use case is I have one Database that will be used across multiple clients. Each client has the same data but the table and field names are obviously different. In my (strange) example there is a translation table that the users could maintain through... -
T
Source Table as variable
hello all, Is it possible to setup a query that has the source tables/fields as a variable? Source Tables : They all have the same data but different field names Position_1: Fields = Account; Value; Date Position_2: Fields = Acct; Val; DT Position_3: Fields = AcctNum; Acctval; AcctDate... -
T
Multiple filters in a form
Finally!!!! Thanks very much Moke and everyone. Have a great weekend -
T
Multiple filters in a form
OK - got it. Took that out and still getting a syntax error. Please see the attached DB in last post. Thanks again. -
T
Multiple filters in a form
Here is the sample. The default "to review" Should only show the Joan record The All setting should show all records -
T
Multiple filters in a form
Moke - thanks. I see you put a lot of thought into this and I really appreciate it. The Invbillreocn is yes/no, the unitsdiff is a value I can do an example but before that I have to ask - it seems like the last code I have above gets me pretty close to where I want to go, but has a syntax... -
T
Multiple filters in a form
Still not working - so lets simplify. Sorry to be a bother. Lets let the just 1 combo box (instead of multiple) to hold the filter values and trigger (instead of the button) the filter. Combo317 has two value options, "to Review", and "All" To Review: will filter field Invbillrecon to only... -
T
Multiple filters in a form
The Code was added to the On Click event for the button. Compile Error: User-Defined Type Not Defined And it highlights the Dim strFilter As strFilter Unfortunately I cannot paste the DB. Full code now is Private Sub Command329_Click() Dim strFilter As strFilter If... -
T
Multiple filters in a form
Yes, default values are set to Combo317 = "Active" Combo319 = "OutOfBalance" Let me try your suggestion and see what happens. Thanks -
T
Multiple filters in a form
I cant get this to work. Lets try a slightly different approach. Maybe it is the same code with a small tweak. Lets set the combo boxes to their values then apply the filters with a button ("Command329"). On Click the Form filters based on the values in BOTH combo boxes. Combo Box... -
T
Multiple filters in a form
All, Thanks in advance for the help. I have a form with 2 combo boxes, both able to filter a given field. They both work fine in isolation, but I cannot make then filter together. When I run one filter the other turns off. Here is the code for each Combo Box Private Sub... -
T
Filter Forms - for dummy(s)
Perfect, thanks for the help. One tweak, how do I set the default to "Active" upon open? -
T
Filter Forms - for dummy(s)
All, Thanks in advance for the help. Super easy question and I can't find the super easy answer. I want to add a combo box to a form to filter the list of records, and I cant get it. I see the options to create another form and subform, etc. but it cant be that involved. The database is... -
T
append into source table
So I closed and reopened the db and it worked. Go figure. Thanks -
T
append into source table
I'm getting a validation rule violation on an append query. Cant figure it out. 1) Query #1 finds values in the [Sec_ID] field in the [Source] table nut not in the [Enhanced] table. 2) The append pasted those diffs into the [Enhanced] table The formats for all are Long Integer and the...