Recent content by ianking

Not only do they ignore sorting in queries, but they appear in this case to ignore the report's own sorting. Its always gouped in ascending order not descending, no matter what I select.

I have a query which sorts the date field in a record in descencing order, yet when I create a report which groups these records by date the groups are always in ascending order even if I select ascending (by day, year or month etc) in the report wizard. Anyone know what is going wrong?

Yes it was a text filed - many thanks for the help - working now.

I'm using this code: If DCount("Barcode", "books", "Barcode" = [barcodetext]) > 0 Then but it never seems to return a value > 0 even if i enter a barcode I know is in the books table

Sorry - I'm not sure of the syntax for dcount. I need to check whether there is a record in the books table with a match for the barcodetext text box on the form My code looks like this Private Sub Commandborrow_Click() DoCmd.SetWarnings False On Error GoTo Err_Commandborrow_Click DoCmd.RunSQL...

Can anyone tell me the SQL code to check to see if a record exists or not? eg if a record exists where a particular field matches a textfield on a form, then update database else msgbox ("error")

thanks Worked a treat (with subquery) - many thanks!

Hi, I need to create a query using two tables which matches the first twelve characters in a string, but ignores the last one. eg 9781904024415 in field1 of table1 matches 9781904024419 in field1 of table2

Merging queries Thanks - I eventually twigged to that - I was trying to merge them the other way (B int A) and kept getting the "no records added" problem - once I merged Table A into Table A all records were added except the duplicates.

I have two tables with identical fields. I would like to merge them together without duplicating any records - there is one field which can be used to identify which data is to be transferred: fields are: Barcode, Title, Author, ISBN, and Date Borrowed Table A has some records with data...

me.requery Me.requery worked a treat. Thanks again, regards, Ian

I have a form which displays data from a query - the query uses a parameter value to select a record to display Is it possible to put a button on this form which will re-load it asking for a new value for the parameter? thanks for any help, regards, Ian

thanks again - happy now :-)

Got it now Many thanks - that did the trick! (any idea how I suppress the "You are about to update 1 row etc.." message) regards, Ian

Hopefully a clearer explanation I think that I've got it clear in my head what I want to be able to do - I think it should be possible..... The application (as you have probably guessed) is a library database with two tables - borrowers and books. The tables are linked with a relationship...