Search results

I have 3 different yes/no checkboxes. I would like to create a calculated field in my query that looks at all the checkboxes and displays text based on which checkboxes are selected. Here are my fields SpecialSS SpecialDT SpecialSGT So if for example SpecialSS is checked off, I would like the...

Hi, I have a combo box in a table tblTypeResultList that lists decision results- example - awarded, denied, allowed and has fields ResultID, Resultdesc. I also have another combo box in tblTypeCase that lists types of case example - costs, jurisdiction, governance and has fields...

Hi, I have a combo box with a list of queries that I can choose and then run the query. I just have some simple code : Private Sub cbochoose_AfterUpdate() DoCmd.OpenQuery Me.cbochoose End Sub But now I want to add the possibility of reports as well. So I would need some code to say that if it...

Hi, I have a query that is hard coded with a date range. SELECT tblCase.CaseId, tblCase.ReqReceived, tblCase.Letter_AMPI, FROM tblCase WHERE (((tblCase.Letter_AMPI) Between #4/1/2014# And #3/31/2015#)) OR (((tblCase.ReqReceived) Between #4/1/2014# And #3/31/2015#)) ORDER BY tblCase.CaseId; I...

Hi, I have a query as follows : SELECT tblCase.CaseId, tblCase.ReqReceived, tblCase.Letter_AMPI FROM tblCase WHERE (((tblCase.Letter_AMPI) Between #4/1/2014# And #3/31/2015#)) OR (((tblCase.ReqReceived) Between #4/1/2014# And #3/31/2015#)) ORDER BY tblCase.CaseId; I am looking for all records...

Hi, I have built a database for my triathlon and running race results. My goal is to enter my swim, bike and run times and then calculate based on the distance of each, the time per 25m for the swim, the km/hr for the bike and the km/hr and min/km for the run. And if I just do a run, the...

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, 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 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, 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...