Recent content by MissAnna

Once again, thank you! It works perfectly! Much appreciated for your assistance, I don't know what I'd do without this site.. Cheers, Anna

Hi, I need to retrieve records from a query by date - the criteria is all records for the current month from last year or any year previous to last year ...i.e this month last year or before last year.. Does anybody know what the expression/criteria would be for this? Thanks to the help of...

Hi, Strike my last comment, they're not duplicate records after all.....thank you again for your help! It works perfectly... Anna

Thanks Jon! That appears to be working, thank you. The query is retrieving duplicates though, i.e. returning the same record 4 times, is there a way I can stop that? Thanks very much for your assistance! Anna

Hi Mitch, Thanks for that, it works for returning last years records which is great. Unfortunately the query is returning all months last year, as opposed to this month last year..do you know how I would fix that? Thanks for your help, Anna

Hi all, I need help retrieving records... the records I need the query to retrieve are from the current month one year ago, or this month last year Can anybody help me with this? Thanks! Anna

Have you tried adding a parameter to your query? i.e. under the date column in the 'Criteria' line type Between [start date] and [end date]

Ah, that makes sense. Thanks Pat! here is the SQL SELECT tblPayments.[Payment Type], tblPayments.Date, tblPayments.[Cost Centre], tblPayments.Account, tblPayments.Identifier, tblPayments.[Supplier Name], tblPayments.[GST Free], tblPayments.[GST Included], [GST paid]*10 AS [GST Exempt], [GST...

Hello, I have a query containing two parameters, one is for a date range and the other for an identifier. it looks like this In the 'or' line of the date column: Is Null or Between [start date] and [end date] and in the 'criteria' line of the identifier column: [Enter Identifier]...

Hi, I have several checkboxes on a form that represent different reports, I have a macro attached to a 'print preview' button that shows the report for the checkbox which is active, in the condition of the macro I have the following: [screen].[activeform].[chkboxname]= -1 then Action 'Open...