MS ACCESS :: Query For Missing Values From Training Database

Need Training Database
I am trying to create a Microsoft Access training database for us at work and I’m not having much success. Can someone look at what I’ve done so far and see if they can make it work or if you know of one out there already that I could download and use that would probably even be better. If there is more to it than just training then that it’s probably better too because I want to expand this as I get time.

Thanks,

Mike

View Replies !

Setting Up A Training Database Help!
I have a table with the following fields

flddate
fldclassname
fldemployeename
fldstatus

I have data entered all current employee training and dates that training was done.

I am looking for an explanation on how I can set it up so i can see who of the employees have not recieved the training.

I am also looking for code for the query to calculate recurrent training dates (when the next training is due for each employee) Dates of initial training for each employee may be different, as well the training may be required every one year or every two years etc.

I am hoping that I am explaining this more clearly in hopes to get some input back from the experts on this site.

Thanks in advance.

View Replies !

Database To Record Training Data
Hi All

I am trying to setup a database to record details of who and where I trained staff. The ones I have found all include grades and marks which I don't want.

Does anyone have a sample database that can help get me started please.

Tee.

View Replies !

How To Use Expressions With Missing Values
I use a left join to join table A with table B. Table B has less matching records , so in the resulting table the field [RESULT] which comes from the table B has empty values.

If I use an expression for a new field PROCENT that involves [RESULT] I got #ERROR in all records with missing [RESULT] value. I tried various IF statements , but even IsError () function produces #ERROR.

It seems that ACCESS 2002 fails to detect missing values and gives an error for any operation. Is there any workaround for this problem?

Example
PROD_PERCENT: IIf([RESULT]>0,[RESULT]/[NETTO],0)

View Replies !

Help With Function/missing Values
Hello People!

I am trying to create a new variable that will indicate whether a person has a family history of breast cancer (1=yes). The values for the 4 source variables are either the number 1 or are blank/missing ("no" was not captured). Any help here is greatly appreciated.

Option Compare Database
Option Explicit

Public Function fnBrCaFaHx(BrstAny, BrstMth, Brst1Sis, Brst2Sis As Byte) As Byte
' Determine if participant has a family history of breast cancer.
If BrstAny = 1 Or BrstMth = 1 Or Brst1Sis = 1 Or Brst2Sis = 1 Then
BrCaFaHx = 1
Else
Exit Function
End If
End Function

View Replies !

Query To Find Ee's With Training Not Completed
I am working with a training database. I am a fresh newbie to access (more of an excel user).

I need to find employee's who have never completed a certain training (DPW Medication Training), which is mandatory.

I have the following tables:
Employee data TBL - Contains active ee's names
CompletedTrainings - Contains all trainings completed by individual
Events - name of all the trainings, including mandatory trainings

I have the following queries:
DPW Med Training - Lists all who have completed the training
DPW-Med-Last - Lists when each employee last had the training
Med_01 - Lists those who have had the training, but need it renewed

Any thoughts?

View Replies !

Missing Database?!?!?!
Alot of my databases entries are missing. today i went on MS access 2007 and it said "security risk" so i went to options and enabled marcros. but when i get on to my database there is only one entry! but i know the information is there. the file is 1700 mb. what should i do?

View Replies !

Database Objects Have Gone Missing!
We have an Access 2000 db, which has been used for some time and is split between a front and back end. We've come in today and tried to open the back-end, which contains only tables, and when it opens it's completely blank. We can't see any of the objects or the normal menu to access the tables, queries, etc. We can, however, import the tables into a new database, so they must be there.

Any idea why this has happened or how to stop it happening again.

Thanks.

View Replies !

Database Window Missing
Hi,

Can anyone tell me how to display the database window that shows all the forms, queries, tables etc in a database?

I have an Access database with startup restrictions and startup login screen. I can open the database by holding down the SHIFT key to bypass the startup options but when Access opens there appears to be no Database Window. I can create new objects in the database ok its just that there is no main database window from where I can browse objects. This is driving me mad - i know it's probably something simple but I rarely work with access

thanks
Maracatu

View Replies !

Your Database Contains A Missing Or Broken Reference To The File Accesibility.api
when i open my database i have the following message.

Your database contains a missing or broken reference to the file accesibility.api

How i can fix this? please help.

View Replies !

Missing Row In A Query
I have what seems to be a fairly simple question.

There are two tables in my database. A and B. Each table has the same criteria: Name, Number, and Date.

I have created a formula in my query which will add the Number fields together when they both have the same name. My problem is that when there is not a row for a particular name on table B, the calculation does not list that row in the results.

I would like for my calculation to insert a zero in the space and add Number.

I have tried the Nz function, but this results in a missing name and date and just the numbers are shown.

How do I get the results to show a row where the name is only on one field and still make sure that it places a zero in its spot and add the zero and the other number together based on the name.

Thank you in advance for any assistance.

Shawn

View Replies !

Missing Null Value In Query
Yes, another of my query troubles. I am running a query that is showing the number of demos booked, number of demos executed, then the percentage of demos executed. I have 2 demos that have 1 or 2 booked, but they have not been executed. They should show up in the query so I can get a percentage for them, but they do not. Here is my SQL:

SELECT [Promo count].PromoNo, [Promo count].[# of Demos], Count(Query6.Status) AS CountOfStatus, IIf([CountOfStatus]=0,0,[CountOfStatus]/[# of Demos]) AS Percentage
FROM [Promo count] INNER JOIN Query6 ON [Promo count].PromoNo = Query6.PromoNo
WHERE (((Query6.Status)="E"))
GROUP BY [Promo count].PromoNo, [Promo count].[# of Demos];

Anyone know what may be going on?

View Replies !

Query Help - Missing Something Simple
I have an ID field that is text. Here are some example ID's. The number is generated automatically and the letter is added by the user.
A10565
52073
C20633
RMA18941

I need to start numbering new id's automatically. I don't want to repeat numbers so I need to know which numbers have been used. So I am trying to remove the letters preceeding the numbers. However I can't seem to get rid of the records with more than 1 letter. Here is the what i've tried in the query -

test2: Left([ID],3)
newnum: IIf([test2]="A" Or [test2]="C" Or [test2]="F" Or [test2]="H" Or [test2]="R" Or IIf([test2]="RMA",Mid([ID],4),[ID]),Mid([ID],2),[ID])

after that is run this is what i get -
10565
52073
20633
MA18941

They are fine except the last one - MA18941 needs to be 18941.

I know I am missing something simple

View Replies !

Missing Records In Query
i have a query that contains two tables one contains the member details the other their transactions. the query is to show all members and transactions however if there is no transaction then the member details do not show - -the query only shows members with transactions . the query does have grouping to give totals of the transactions

View Replies !

Missing Operator In Query
Hi everyone,

I have a problem with a query.
Just for info, I export some table from SQL to access. The same query in SQL work fine but when I try in Access come out this error:

------------------------------------------------------------------
Syntax error (missing operator) in query expression 'tbl_Style.FABRICID = tbl_Info.Infoid INNER JOIN tbl_Info AS tbl_Info_1 ON tbl_Info.Parent = tbl_Info_1.Infoid'.
------------------------------------------------------------------

The query:

SELECT tbl_Style.STYLECODE, tbl_Info_1.Infodata AS [Fabric Type]

FROM tbl_Style INNER JOIN

tbl_Info ON tbl_Style.FABRICID = tbl_Info.Infoid INNER JOIN

tbl_Info AS tbl_Info_1 ON tbl_Info.Parent = tbl_Info_1.Infoid

I appreciate your help.

Regards,
Tombino

View Replies !

Record Missing From Query Report
i have made a query.. when executed it returns 4 results..when i view the report however (made using the wizard based on that query) only 3 results are displayed..i then add a record to the database... the query returns 5 results.. and again the report only displays 4 results...i believe that the first record entered into the database is missing from the report.. but it is present in the query.. could i have accidentally deleted the first record from the report when i was altering the layout in design view??anyone come across this before?is there a general rule with reports based on queries that only display results with certain criteria or something??

View Replies !

Showing Where Data Is Missing In A Query
I want to use a column in a query to show where data is missing in other fields.

In excel I have used this statement:

=IF(COUNTA(I5:J5)=2,"","error")

Basically, I have two fields PRICE and WEIGHT. I want a column in the query to show 'Error' (or any kind of flag) when either (or both) of these fields are blank.

Hope this makes sence.

Any advice?

Thanks

View Replies !

Query Problem (missing Operator)
Hi everyone,

I have a problem with a query.
Just for info, I export some table from SQL to access. The same quary in SQL work fine but when I try in Access come out this error:

------------------------------------------------------------------
Syntax error (missing operator) in query expression 'tbl_Style.FABRICID = tbl_Info.Infoid INNER JOIN tbl_Info AS tbl_Info_1 ON tbl_Info.Parent = tbl_Info_1.Infoid'.
------------------------------------------------------------------

The query:

SELECT tbl_Style.STYLECODE, tbl_Info_1.Infodata AS [Fabric Type]

FROM tbl_Style INNER JOIN

tbl_Info ON tbl_Style.FABRICID = tbl_Info.Infoid INNER JOIN

tbl_Info AS tbl_Info_1 ON tbl_Info.Parent = tbl_Info_1.Infoid

I appreciate your help.

Regards,
Tombino

View Replies !

Query To Find Missing Records
Hi.

i.e..............

Table A has records 1,2,3,4,5,6,7,8,9,10

Table B has records 1,2,3,4,5,6

How do I create a query that returns values 7,8,9,10 for Table B when I compare Table A and Table B?

What sort of query do I need? I tried the "Unmatched query" but this did not get the result I wanted.

Thanks for reading.....

Frank.

View Replies !

Query To Show Missing Records
I have a table for stock with two fields, KEY and DESCRIPTION; a table for manufacturers with two fields, KEY and NAME; and a third table which links to them both with a many-to-one join with three fields, KEY, STOCK-KEY and MFR-KEY. What I am trying to do is write a query that for a given manufacturer (entered via a parameter) shows a single line for all stock records that are NOT linked to it via the third table. I am sure it should be simple but all my attempts fail to exclude stock linked to the manufacturer if it is also linked to another manufacturer. Any ideas?

View Replies !

Training
I've been reading books to learn VBA for Access 2007, but I would like to take some training classes. Can anyone suggest any good online or onsite courses that I could take?

View Replies !

Append Query Missing From Query Tab, But It's There!!
Hi there,

I've got an Append Query in an Access 2000 database that is not visible on the Query tab. I know it exists because when I try to create a new query and call it the same name it responds with "The name entered already exists for another object of the same type in this database"

I've tried ticking the System and Hidden objects but to no avail. Somebody please tell me where this query is hiding??

Thanks in advance.

Paul

View Replies !

Record Missing Using Work Week Query
I got a problem regarding query work week in database.
The database contain data of year 2006 and 2007. When i query about work week, some record is missing.

i wrote the sql statement as
SELECT * FROM TBL WHERE FORMAT(MYDATE, 'WW', 1, 2) = 1 AND YEAR(2007);

There is one record missing... which is 31/12/2006 record.

So any idea to eliminate this??

View Replies !

Missing Records When A Table Is Included In A Query
I am working with a normalized database that has MANY tables. Most of these consist of lists of options to select from for the primary table. The primary table is linked to the secondary tables (and those to tertiary tables) by Primary Key ID fields, and the other tables contain additional information.

For Example, the Name list table is related to the Actions table by the SSN field, and the Actions table is related to the PayStatus table by an ID number collected by a lookup field.

When I pull all three tables into a query to display all the information related to a particular individual an his action, there are more records if I remove the PayStatus table from the query. It seems to only pull reports for which a PayStatus has been selected.

How can I get the query to display ALL the records, whether or not the individual has a pay status? Whether or not the individual has one is irrelevant, but I want his name to be displayed, whether or not he has one.

Thanks for any suggestions.

View Replies !