Search results

I have a table with 25 columns, tried the "highlight/select table" then click report. I get a report that is about 10 columns shorts. Any idea why this happens. Need the report because I am going from report to excel via macro and the column sum in the footer translates nicely to excel that...

I have been going through the forums and found a nice solution to take a report to excel. My issue is that the report is gray headers and black text/details. Looks great. When exporting to excel it is the reverse.. black headers and very faint gray text for the data. Any idea how I can solve...

Actually, and I know this probably is not the right way, I have a table. This table is cleared by a delete query, then filled via 2 append queries as the data is coming from different tables and some other data manipulation is taking place. Then I have a query against that table that the...

Worked like a charm. Thanks! Can you do the same in a Report with the same form open? Can you get the displayed value from the combo box and not the ID (use ID for query, need displayed value for report)?

So edit the query object to take the values from the form? (not using a sql string) I will edit the criteria field on my query design and keep you posted.

I have a form with 3 fields and a button. On button click I need to run a macro that calls 3 queries in order. The 2nd and 3rd need 3 parameters, thus the form. How can I pass them in? Fill out form, click button, run delete query, run 2 append queries that need parameters then finally open...

Your comment about kicking it around in the designer got me thinking. Changed the GroupBy to Expression and voila....went away.

I put Diff in the group by replacing [ApprovedTaxCreditAmount]-[TaxCredit] as an attempt to fix the popup issue...to no avail.

Here is the query....the Diff column is the difference between a field and a calculated field. Why do I get a popup asking to fill out the Diff value. If I leave it blank and click ok it runs and is correct. SELECT DonationRecipients.RecipientName, DonationRecipients.ApprovedTaxCreditAmount...

Turned out to be the join...

SELECT BusinessDonation.DonationTo, Sum(Nz((SELECT [Percentage] From TaxPercentage WHERE [StartDate] <= [BusinessDonation.DonationDate] AND EndDate >= [BusinessDonation.DonationDate]),0.65)*[BusinessDonation.DonationValue]) AS TaxCredit, DonationRecipients.ApprovedTaxCreditAmount FROM...

I still get a 4x result...very odd

Looks good. Will swap the 0.65 with the dollar value and I should be good to go. (the slect TaxPercantage gets the 0.65, or whatever the percentage is for the date range.) THanks. will test and post back.

Public Function GetTaxPercentage(DonationDate As Date, DonationValue As Double) Dim tax As Double Set db = CurrentDb() LSQL = "Select percentage from TaxPercentage" LSQL = LSQL & " where StartDate <= #" & DonationDate & "# and EndDate >= #" & DonationDate & "#" Set...

I have a simpel query: select field1, sum(VBACalc(field2,field3)) as thing, field 4 from table groupby field1,thing, field4 seems to run fine, but always mutilplies the result by 4. I have edited my database table to have only 1 record. Stil multiplies by 4. I set a stop itneh VBACalc (which...

Fixed it. I had the listbox bound to a field. Once I removed the binding, all was well. Thanks all. Be back shortly with more questions! :)

Multiselect is set to none. I must have another setting wrong as Me.lstThings.Column(3) is Null as well. I would like to post a sample db, but it has too much proprietary stuff to trim it down and post. Edit: just noticed (not sure why I didnt see this before) that when I select any row, it...

Here it is: DoCmd.OpenReport "IndividualReport", acViewPreview, , "[IndividualReport_ID]= " & Me.lstThings.Column(3, lstThings.ItemsSelected) returns null on DblClick. OnClick does nothing.

Yes, I am doing this on the DblClick action...

I am debugging, then stepping through. ColumnCount comes out to 4.