Search results

I'm sorry to bother, this is now solved. I had change the name of one of the elements in a subreport and it didn't get saved. I apparently had to get out of the report and in again to use the new name

I am trying to make a simple operation in a report with elements from 3 different sub-reports. It looks like this: =([qryQuotationalSavingsReport subreport].[Report]![Saving])+([qryAuditSavingsReport subreport].[Report]![Saving])+([qryRejectionSavingsRep subreport].[Report]![Savings])...

I finally made it work using one of the first suggestions. I created an expresion in the query extracting the year and a criteria to match the year from the desired date fiel. Thanks all for your help!

Thank you very much Pat and Galaxiom for your answers... this looks so right, but still there must be something that I'm doing wrong! My query is coming out empty My criteria looks like this: "WHERE [DateInvoiceReceived]" Between DateSerial([Forms]![Main Menu].[YearSaving];1;1) And...

For some reason, when I do an extra field in the query Yr: [Forms]![Main Menu]![DatSav1] the results of the Yr column are all blank.. If I create an extra textbox in [MainMenu] YearSaving=Year([DatSav1]) I get the year in that one..

I am trying to apply a criteria on a query with a list of dates. I want to extract the year from a form and I want to see the dates for that year on the query results. I am trying in the criteria for the date: Year([Forms]![Main Menu]![DatSav1]) The query results are empty.

This worked! Thank you very much!! :)

Thanks, Demark

It asks me for a parameter value for both SavingsAmount(GBP) and EstSaving see the attached. Thanks for trying to help :)

Ok I did and the error is "invalid syntax" The real one is this: Savings: IIF([qrySavingsReportTemplate]![SavingsAmount(GBP)]>0, [qrySavingsReportTemplate]![SavingsAmount(GBP)] , [qrySavingsReportTemplate]![EstSaving] )

Thanks but it's not that. The regional settings for my office package is configured like that. The union for function's elements is ";" instead of (,). Same thing in excel...

Hi all, I have a query (qrySAV) with 2 components A and B. I want to create a new one "C" in which If A>0, C=A, if not, C=B I have tried: IIF ([qrySAV]![A]>0;[qrySAV]![A];[qrySAV]![B]) I am not sure if it is necesary to refer to qrySAV when the elements are in the actual query. When I...

I have 3 tables: *Members (MemberID) *Cases (CaseID, MemberID) *Activities (ActivityID, CaseID) I am trying to do a query to see a count of cases and activities by members. When I do Members->Cases(count) I get the correct results for nr of cases: Member 1, 19 cases When I try to add...

Thanks. Sorry I am such a newby in VBA. Please see the attached. Should I put the first part (Private Sub Workbook_open() ) in the "ThisWorkbook" object and the other in the Sheet1 object?

It would be, but I would prefer if the excel spreadsheet was dynamic.

Dear all I have a query in a protected access DB that I need to import into excel. I've searched the forum and on the internet, but I couldn't find a comprehensive answer explaining how to do it. I know how to import the query from a non-encrypted db. Thanks

Hi All, I have a Form "Activities" and another one "Customers" I would like to trigger an action to auto-populate an "Activity" on all "Customers" that meet a specific criteria (I can get the list of these on a simple query). Is this possible with VBA? Could someone point me on the right...

Thanks! It's weird. Did this before (without the compact and repair though) and did't worked. Now it does! Thanks a lot!

The team will be registering cases backward and they will have to put dates from last month. I just want to have the option to have a "Now" button for current cases.

No, it's just the Date/Time record from the table