Search results

0 hours, 24 minutes, 53 seconds

3.31 should be 3 minutes, 18 seconds

Hi, I am creating an access database for the results of my triathlon times and I am having trouble with the race results. Based on some information I found here, I am using number fields for the swim, bike and run times because I want to do calculations and also sort them and it doesn't sort...

Hi, Thank you for the links. However, I understand many-to-many relationships IF there is just ONE of them. But I do not know what to do if I have SEVERAL many-to-many relationships. Do I need a junction table for each of them? And it also does not help resolve how to best deal with tv...

Hi, I am trying to design a movie database. Yes, I know there are templates around but they do not go into enough detail. I am specifically having problems with many-to-many relationships. Do I need a junction table for each many-to-many relationship that exists. So if I have 5 many-to-many...

Hi, I have solved part of the problem by padding the field with an extra 0's and this has helped the sort of part of it at least. So now at least A/M 001 A/M 010 ADR 001 ADR 010 now sort properly. I am not sure about the J.1.1 and J.10.a etc. Thank you, Liane

Hi, I think the problem is the select statement. This is not just a 1 to many relationship with 2 tables. This is a many to many relationship involving a junction table and I have no idea which tables and fields to use in the SQL statement. Here are my tables. The 1 side is the tbldoctrine...

Hi, I would like some advice for fields for call numbers for a library database that I have at work. Right now the call numbers are structured as per below. The letters representing the category abbreviation and the numbers a sequential number. Except when it comes to journal articles which...

Hi, Thank you for your response. I tried to modify the query to this : SELECT tbldoctrine.title, ConcatRelated("lname","tblauthors","tbldoctrine.DoctrineID = " & [tblJncdocauth]![DoctrineID]) AS Expr1 FROM tbldoctrine INNER JOIN (tblauthors INNER JOIN tblJncdocauth ON...

Hi, I am trying to use this concatenate function, but I am getting an error in the SQL and I don't know how to fix the SQL statement because I have a junction table. Here are my tables. I am trying to create a list of books with the authors on the same line separated by commas...

Hi, I have the following example as records in a query. Only a few fields are listed for this example. Title Author Book A Author A Book A Author B Book A Author C Book B Author X Book C Author Y Book C Author Z Book D So as you can see a book can have either no authors, 1 author or more...

Hi, I have redesigned a database for tracking books, journals, journal articles and authors. So far I have these tables with some of the fields that I have included: TblBooks BookID - primary key CallNum Title TblAuthors AuthorID - primary key FName Lname TblBooksAuthors BookAuthorID -...

Here are the relevant fields in my query Case number Role Category Dispute 1 Claimant Child Family 1 Respondant Mother Family 1 Claimant Others Family 2 Claimant Teen Family 2 Respondant Uncle Family 3 Claimant Student School 3 Respondant Teacher School I want a calculated field in my...