Search results

I realy do not see a need in a tblalbumtrack unless you are trying to mix the same tracks in the different albums and tracks are independent of the album. I am pretty much sure that this is not the case. Make the Albumid go directly to the tbltracks as a FK.

I think there is a redundancy in keys Location>Facility>Room>tblclass all of them 1-M relationship while in your structure tblroom has redundant key - Facid tblclass has 2 redundant keys - Facid, Locid

So what is the problem ? Pull two tables link them by job number, leave the PK field from the first table and order details fields from the second table, run query ,check if everything correct and then create "make table query" out of it. Then add the new field to the newly created table and set...

You want to extract the PO box information from a certain field and then place into another field?

Is this what you needed ?

For both questions yes. 1. use find unmatched query. 2. use append query.

if = iif in Access

Here is db that checks as well if there is an overlap, Thank you Pat, The first time I saw the "composite key" was in JDEdwards which is not a relational dbase but I thought that this is the common pratice. Pat, do you have any good examples of composite key usage? Best regards Alexei ( he ) :)

I used a composite key for this look in design of the form

Create two combo's, the query behind the second combo will have a criterea eq to value in first combo. Then on change event of the first combo place a code : me.combo2.requery

It is possible if you do it in two steps first you will create a query that will group the year and the applicant name SELECT Format([yourdatefield],"yyyy") AS [Year], (yourtable.yourapplicantname) AS [Name], FROM yourtable GROUP BY Format([yourdatefield],"yyyy"), yourtable.yourapplicantname...

SELECT Format([yourdatefield],"yyyy") AS [Year], Count(yourtable.yourapplicantname) AS CountOfApplicant, yourtable.yourapplicantname FROM yourtable GROUP BY Format([yourdatefield],"yyyy"), yourtable.yourapplicantname; this query counts how many times applicant applied for courses within the...

First, why your query gives you duplicate records? Are they really duplicates ? You can prevent this by going to SQL mode of a query and typing after the Select - distinct. so that SQL would look like Select distinct ............

Not sure but: Parent (P) Child (C) "Subsection" is P to "CostCenter" C "CostCenter" is P to "Employee" C "Employee" is P to "Workstation" C "Workstation" is P to "Equipmentuse" C "Equipment" is P to "Equipmentuse" C Cost Center number is already a unigue number no need for Autonumber. Pass...

You are actually seeking on a number field (mission_ID) which is probably linked to some other table where your identification text is stored with unique number. If so then there are couple of ways. You can go to that table, add new field which will indicate what type of value is it (training...

Can you post a db?

You need to create the runningsum query and then subtract the results from the total value

Hello bmiller You can use Union select query Syntax for union select is following: Select yourfield From yourtable where(((yourcritirea)) Union select your field From yourtable (((yourcritirea)); Here is live example: SELECT distinct Table1.Field1 FROM Table1 WHERE (((Mid([field1],1,2)) Not...

try this: >FormatDateTime(Now(),4)

Create new query, then go to the sql view of it and replace the code with this code: SELECT distinct Yourtable.Yourfield FROM Yourtable WHERE (((Mid([yourfield],1,2)) Not In ("Ae","Be","Fe","Ge","He","Me","Pe","Te","Ve","Xe","Ze","Au","Bu","Fu","Gu","Hu","Mu","Pu","Tu","Vu...