Error Creating A Report From Query

Jul 18, 2005

Hello,

I can run a query but when I try to display this information on a report I get the following message:

The specified field “tblMachineData.TagName’ could refer to more than one table listed in the FROM clause of your SQL Statement.

Here is my SQL code from the quey.

SELECT tblMachineData.TagName, [tblMachineFloat Query].DateAndTime, tblMachineRunTag.TagName, tblMachineFloat.Val
FROM tblMachineRunTag INNER JOIN (tblMachineData INNER JOIN ([tblMachineFloat Query] INNER JOIN tblMachineFloat ON [tblMachineFloat Query].DateAndTime = tblMachineFloat.DateAndTime) ON tblMachineData.TagIndex = [tblMachineFloat Query].TagIndex) ON tblMachineRunTag.TagIndex = tblMachineFloat.TagIndex
WHERE (((tblMachineFloat.TagIndex)=0 Or (tblMachineFloat.TagIndex)=1 Or (tblMachineFloat.TagIndex)=3 Or (tblMachineFloat.TagIndex)=4))
ORDER BY [tblMachineFloat Query].DateAndTime DESC;

Any help is appreciated,
Bob

View Replies


ADVERTISEMENT

Reports :: Call Center - Creating A Report To Show All Associates Under Error Type?

May 23, 2014

The database is to track and evaluate call center associate phone calls. I created yes/no fields for multiple common errors (accurate/complete, Security, and client experience. and under each are @ 20 common errors)

(the problem is that I did not create a seperate table for each main category which I think might have made things easier)

Now what I am trying to do is create a report that allows me to show (or select) an error and have it show all the associates that had that error in a given time frame.

I already have a report to show all associates and all the errors that each had in a certain time frame. (so vertically I have associate detail and horizontal I have error detail).

is there a way, without creating 25 separate reports, to show all associates under an error type?

View 3 Replies View Related

Error While Creating Chart From Query

Oct 19, 2007

Wasen't sure whether this is a Reporting thing or a Querie thing as it resides inbetween the two.

Basically (and believe me I thought this would be pretty straight forward!!!!), I am trying to create a chart from a query that returns the occurences of concerns raised each month for a year. The query returns the following:

MthTextExpr1
Jan0
Feb0
Mar0
Apr1
May0
Jun0
Jul1
Aug1
Sep2
Oct1
Nov0
Dec0

In order that the user can specify a year that the chart will be applicable to, there is a field within the query that relies on the input of a year on an unbound text box on a form: [Forms]![frm_concern_frtpage]![Enter Year] is inputted into the critera box of this field.

However, if you try to create the chart it does not like this and just gives the following two error messages. If you enter a value into this text box and run the report containing the chart, it just gives a blank chart!!!!

Why is this error occuring?

I just want months along the X axis and the values from the Expr 1 column to be displayed on the Y axis!

View 5 Replies View Related

Creating A Report From A Query

Oct 19, 2004

Sorry about the simple question, but my brain is not functioning today. How do you create a report from a simple query?

View 2 Replies View Related

Creating And Running A Query For Report VBA

Sep 6, 2004

I've been reading up quite intensively on using QueryDef's collection to try to pass a Parameter to a Query in order to then Open a Report. But can't seem to get it to work. I've been trying to write an SQL statement that the VB will accept in code but never got it to work. Depite copy/pasting the SQL from the Query Access creates. regardless.. I really need some help with this one. Thanks. Procedure follows. Get error that Report not found... The name is correct... I just want to pass the integer (index) from the ListBox into the Query then Open the Report... Thats all...

Private Sub previewReport_Click()
On Error GoTo Err_previewReport_Click
Dim intSelectMonth As Integer 'The Index of the Item Selected in Form List Box
Dim db As Database
Dim smReport As Report
Dim smQuery As QueryDef
Dim month As Parameter

Set db = CurrentDb
Set smQuery = QueryDef![GetReviewsMonthQuery]
smQuery.Parameters![rvMonth] = 9 'Using 9 as September just for Testing
Set smReport = Reports![Review Schedule by Month/Analyst]

DoCmd.OpenReport smReport, acPreview

Exit_previewReport_Click:
Exit Sub
Err_previewReport_Click:
MsgBox Err.Description
Resume Exit_previewReport_Click

End Sub

View 2 Replies View Related

General :: Creating Report Or Query

Nov 9, 2014

I am quite new to MS access and started to develop a small database for my practice. I have made four tables that are for Patient details, their doctor detail, their problem and their treatment. I have successfully created form to enter the data.However I an unable to proceed, now I want to create a discharge letter which will be addressed to the doctor (based on the tables described above)

I want to make this in a way that if I enter the patient details i-e date of birth, ID and / or name a letter is created based on the tables above. I also want this letter to be saved for future use. how to design that letter and should it be a query or report.

View 6 Replies View Related

Forms :: Form Produces Error After Creating Query From 3 Tables

Feb 11, 2015

I have 3 tables:

tblMain
BalanceID PK
GasID FK
ElecID FK

tblGas
GasID FK? not sure
BalanceID

tblElectric
ElecID FK? not sure
BalanceID

I created 1 query from all 3 tables, then created the form from that 1 query.Now when I enter data into the form and click to save it , it produces this error message:The Microsoft Database Engine cannot find a record in the tblGas with key matching fields 'tblMain_GasID.The tblGas does contain a field GasID, but does it mean that the field should be tblMain_GasID

View 12 Replies View Related

Creating A Master Query Or Report From Multiple Queries

Mar 12, 2008

I have been running 5 reports to gather company information. I then take the data from these 5 reports and manually load them into an Excel spreadsheet to calculate a grand total. I would like to be able to run a query or report within my database to get the same information. I have attached a copy of my spreadsheet for review.

Could someone please review this spreadsheet and help me design an easier method of calculating a grand total.

View 2 Replies View Related

Queries :: Creating A Report From A Query With 19 Tickbox Fields

Aug 5, 2014

I am writing a small program for my sons school for there athletics day. We want to register all the students on a data basis. I have a form where you capture all the child's information and then tick box for each event that there will be for the day. So we will only tick the events that the specific child will participate in. I design the table to just import the information from each school from a excel spread sheet directly into the table. What my goal is to print report for each event that will only show the child's names that has register for that specific event and all the different age groups separate. I am stuck at the query and can't seem to get my mind around how to define the query.

View 2 Replies View Related

Reports :: Creating Report That Show Only One Record From Query Or Table?

Feb 19, 2014

I am using Access 2007. creating a report that show only one record from my query or table.

View 5 Replies View Related

OVERFLOW Error In Both Query And Report

Nov 10, 2011

I'm creating a database to store our Audit results. My issue is... I have all these different audit elements and each persons scores get entered into a form. I'm trying to get the average of everyones scores for each element. When I create a query and build the expressions to 'average' the score of these elements, it will only let me average 3 of them and then I get an overflow error. It acts the same way in the report as well.

I ultimately want to create a report that lists the elements followed by the percentage (average of the full company audit broke down by element). This way we can see our problem areas and where we need more training.

Only thing stopping me is OVERFLOW.

View 9 Replies View Related

Creating A Query / Report That Displays Data From Two Tables And Total One Set Of Data

Aug 10, 2012

I want a Text Box Query on my form to display the Status, Workshop, Time, Enrolled and Limit. The problem is these values come from two different tables and the Enrolled value comes from a single field that contains the different workshops.

What I mean is: In Table[Attendees] a row contains a customer's Number, First Name, Last Name, Workshop and Phone Number. The workshops vary for each customer so one row on the table could have John Doe attending Cover Letter Writing and the next row could have John Smith attending Resume Writing. What I want is to be able to count the different workshops within the Field[Workshop] and total them and then display the total in a Text Box Query. I have a Text Box Query set up displaying Status, Workshop, Time and Limit as these values all come from Table[Workshops].

So basically I need to Query to also display a result that is the Total for each workshop from Table[Attendees] and display the total for each workshop in a Query with data from Table[Workshops].

Here is a link to an Example Database [URL] ....

I'm trying to avoid putting things on different reports and the like because the people using this are basically computer illiterate and if they have to click a button (no matter how well labeled) they won't do it and the information might as well not exist.

And if there's a better way to do it, I'm all ears. The only thing is, I have to update these workshops month by month. Since they are dynamic, I want to avoid creating separate tables for each workshop.

View 14 Replies View Related

Queries :: Using Input From A Form As Criteria - Error When Running Report / Query

Aug 18, 2015

I have a query that uses the input from a form as criteria, which is then used in a report. The form input is a drop down based on another table. This is a sales pipeline report, and the list is a list of sales people. The report works perfect for all sales people except one. When I run it for the one, I get the following error:

"This expression is is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables".

I DO NOT get the same error when running the query by itself - so assuming there is something in the report causing this. I do have some sum formulas in the report.

Again, no other salespersons selected cause this error -- so I am assuming there is something in the dataset for this person that is causing the error.

View 8 Replies View Related

Creating Duplicate Values Error

Mar 29, 2006

I have a table with one primary key (ClientID) which is an autonumber (cannot be duplicated), and another field which is a number field which is set to a random 6 digits (also cannot be duplicated) whenever a new client record is created.

Now, the main database is on a desktop, and my partner and i are connected to this main database through our laptops whenever we're in the office. For the last 6 months, I had only the ClientID in the form (from the Client Table), and everything would work fine whenever we created a new record in the Form, even if we created a new record at the same time on our personal laptops, the numbers would automatically be increased by one w/ no error.

I just added the other field now, the regular 6 digit random number field, and sometimes (only sometimes) when we both have a different client and start a new record, we get error messages that says we're creating duplicates. When that error message comes up, one of us has to close down the form completely, and reopen and start a new record again. Not sure why this is happening. Here is the error message.

http://members.shaw.ca/hgkma/errormessage.jpg

Any help appreciated.!!

View 14 Replies View Related

Creating A Database For Common Error Messages

Aug 23, 2006

Hello to all. This is my first post on this forum. I'm currently working on a database for my company and would like to get some more guidance from you all. I work at a helpdesk. I'm trying to create a database that allows me to search for common error messages. My co-workers and I would be inputting the messages. I would like to be able to set up a query to search for these messages for future troubleshooting. I’m just looking for a start on what the tables and fields should be and how we can input the messages. All help is greatly appreciated.

View 3 Replies View Related

Receiving Error When Creating Calculated Field

Feb 4, 2013

I'm attempting to create a calculated field in a query called 'Test'. It's purpose is to determine if a certain field has a 'c' for closed and then returns the appropriate 3 months in a concatenated string. This previously worked when it was shorter. Now that I extended it for 2011 fields i'm getting an error that it is too long. I'm pasting the below code into the 'field' line of my query.

Code:
Test: IIf([DEC12_Status]="c",[OCT12_A] & " " & [NOV12_A] & " " & [DEC12_A]
,IIf([NOV12_Status]="c",[SEP12_A] & " " & [OCT12_A] & " " & [NOV12_A],
IIf([OCT12_Status]="c",[AUG12_A] & " " & [SEP12_A] & " " & [OCT12_A],
IIf([SEP12_Status]="c",[JUL12_A] & " " & [AUG12_A] & " " & [SEP12_A],
IIf([AUG12_Status]="c",[JUN12_A] & " " & [JUL12_A] & " " & [AUG12_A],

[Code] .....

View 4 Replies View Related

Modules & VBA :: Error Message On Creating Duplicate Record

Jul 25, 2013

I need to be able to produce an error on a form where the user attempts to create a new user that already exists. The error needs to be produced when the save button is clicked.

See below for the existing code on my save button which exists in form, 'frmAddEditUser':

Private Sub cmdSave_Click()
If IsNull(cboManagerID) = True Then
MsgBox "Please select a manager", vbExclamation, "Details Missing!"
Me.cboManagerID.Requery

[Code] ....

Currently, if I attempt to create a user with the same Payroll ID as an existing user, my 'User details saved' message box is displayed and to the user it looks like a new record has saved successfully which isn't the case.

I need a message box to appear displaying something like "Payroll ID n already exists" where n is the 'PayrollID' of the duplicate record. (Is it possible to combine a value from a certain control and ones own custom text?)

Note: PayrollID is a combination of letters and numbers, i.e. two letters, followed by 5 numbers, e.g. JD12345.

For reference, the table/field and and control are called, '[tblUser].[PayrollID]' and 'txtPayrollID' (on 'frmAddEditUser') respectively; it is from this field and control that I want the error to be produced if the user is entering the same values which are existing in 'tblUser'.

View 10 Replies View Related

Runtime Error 3436 Failure Creating File

Jul 18, 2014

I am trying to export my query to an excel file and I get the above error.

Here is my code:

Code:

Private Sub cmdExcel_Click()
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "queryA", "C:queryA.xlsx"
End Sub

Not sure what the issue is.

View 13 Replies View Related

Help Creating A Summary Report

Aug 23, 2004

Lets say I have table with the following information:

OrderNo. ProductId Count1 Count2
01 AA 2 0
01 AB 0 1
01 AC 1 0
01 AD 0 3
02 AD 0 2
02 AE 4 0
02 AB 0 1
.
.
.

A count in Count1 means 0 in Count2 and vice-versa

How do I create a report that looks like this:

OrdeeNo. SumCount1/SumCount2
01 (3) / (4)
02 (4) / (1)
.
.
---------------------------
Totals (7) / (5)


Thank you

View 1 Replies View Related

Creating A Report From Two Or More Tables

May 18, 2006

Hi all,

I am a complete newbie so please beware/be patient.

What I am trying to do is to create a report from two table, using the wizard it starts complaining about the relationships between the two tables, though I only want to produce the table on one report.

Please help.

Thanks,

The Gurkentopf

View 1 Replies View Related

Help Creating A Simple Report

May 17, 2007

AFternoon,

I have never used Access before and i have been asked to create a report that displays the cartridge name and the quantity. This part was easy. But, the problem i am having is that i have a field in the database called "DoNotOrder". If the cartidge has the box ticked in the field "DoNotOrder", I do not want it to be displyed in the report. I was wondering if anybody could give me a clue into writing a statement to do such a thing.

ANy help is much appreciated.

Thanks for your time

Ollie

View 1 Replies View Related

Creating Report From A Form That Has Subform

Dec 6, 2004

I have a form with a subform in it and I would like to print the contents of that form to a report. I am able to print now, using a "print" command button, but it only prints one record, just the one that is being displayed. I want to be able to print a report with all the records that are in the filtered result.

Also, when the press the "print" button I would like to give them an option "Print this record?" "Print All records?". depending on the input, it would print the report.

Can someone please help me with this? Much appreicated.
Thanks.

ronnie

View 1 Replies View Related

Reports :: Creating IIF Statement In A Report?

May 20, 2013

I am quite new to access 2007 but trying to create an IIF statement in a report but don't know where to start.

My report has lots of 'Label' fields with standard text based on a query for the fields components. I want one of my labels to only appear on the report for print IF a record field called 'Program' (which is from a list) has the word 'RHICHOP' at the beginning of it. If RHICHOP is not in the beginning of the Program then leave out the label text.

View 4 Replies View Related

Tables :: Creating Expression On A Report

Mar 4, 2013

I have a database of students that have taken tests. That database includes how many attempts it took them to pass. I have successfully generated reports that sort the exams by type, date, student, etc. I would like to also somehow insert a formula to show the pass rate of those exams on the top of the report. I know I can get into design view and build an expression, but how would I build an expression that would create a pass rate percentage based on whether or not a student passed an exam on the first attempt.

I have a DB with a column titled "Attempt" and the options "First, Second, Third, Fourth". I would like the expression to generate a percentage of students that have "First" in their box (as opposed to anything else) out of the total number of student records.

We need to track student pass rates in my school for a re-certification process.

View 3 Replies View Related

Reports :: Creating SKU By Store Report

May 21, 2014

I have a table, it is fairly large but pretty simple.

It lists store numbers in the first column. Each column that follows is a SKU, and in the field it either has a 1 or a 0 to represent 1 if it is stocked in the store, and 0 if it is not.

Can I write a report that will show what each store has, and how do I do that? I basically want it to return the sku number (and its description) if it has a one in the box, but not if it doesn't.

View 5 Replies View Related

Creating A Dropdown To Generate Report

Jun 9, 2015

I couldn't find a better way to organize my data for an ongoing history project and so am trying my hand at Access.

So, I've got an Access 2000 database built, with 3 main tables - have relationships set up and which look to be working fine (two of the tables each link to one field in the third, main, table).

What I want to do now, is to be able to have a combo box - whether on my existing form (or likely a separate one), that I can just pick the town I want, then the database would return all the records in the main table for that town, and put that into a report.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved