I have an access data base with three tables named DD, Export , and RPL I have the result of a inner join betweent EXPORT AND DD which is working fine Now with those results I want to update a third table RPL which is currently empty but has those fields to be populate for example RPL.[Hotel ID] should be
Tag: ms-access
How can I include a “Select All” option in my combo box?
I have a combo box that has the list of my distributors, when I select a distributor in the combo box I have a sub-form that list the transactions of that specific distributor. Now I want to include a “Select All” option in the combo box that will display all the transactions of my distributors. I tried to do it
Using Aliases with two Joins on MS-Access Query
I am attempting to add Joins that will allow the query to display the corresponding tbl_ICA.[Abbreviation] for both tbl_AssyMoves.[To ICA] and tbl_AssyMoves.[From ICA] in each record. (tables are …
Access Unmatched or similar query where a column does not contain or is not like another column
I want to design a query that basically does a mass amount of “Not Like “*x*”, except all of the things I would not like the query to contain are in another column. I know I can do this one at a time …
How to make a Query in MS-Access that returns the intersection of three other queries?
I have a “search” form that allows the user to input location, date, or ID. This form generates three queries, which return appropriate results, or all records if no search term was input for that …
Data exclusions based on two-tables MS Access
I have table A which includes all data based on a read date. For example: Read Date—-Data 1/1/2016—–3 1/2/2016—–10 1/3/2016—–42 1/4/2016—–16 12/25/2016—-32 12/26/2016—-12 12/27/2016-…
how to show results of postcodes within a radius of a point
hi back with another problem lol, i have a table with several columns; 2 of which latitude and longitude and other is crime types, what i need to do is work out how many crimes were committed within …
Multi-Field Search Button (Query) Showing Records With or Without Missing Fields
I have a database with only 1 table, this table has 27+ fields and not all of them will contain a value (some will be empty). I have a button (“search alarm”) on a navigation form that performs a …
Two tables, join not returning data from one table
I have two tables, one (Organisations) with 60 rows of data and the other (Question Data) which has hundreds of rows of data. They both have a column OrgID which is a text field of 5 characters length….
Get HIGHEST and SECOND HIGHEST value for each ID (SQL)
New to SQL. In Access 2016. In a table of different equipment (EQUIP1, EQUIP2, EQUIP3), I want in a query the last and second to last maintenance dates. Many fixes I have searched for do not account for grouping by an ID (EQUIP# in my case) What I have: What I need: EDIT: Thanks! Got a little caught up on