Question about Computers & Internet

1 Answer

Please correct the code - problem -afer = the query gives multiple values so its not working

SELECT break_cat.[Main Catogorey] AS Expr1, breakdown_reg.[Breakdown Catogery], breakdown_reg.[m/cname], breakdown_reg.comp_noticed, breakdown_reg.wor_done, breakdown_reg.stop_time, *
FROM break_cat, breakdown_reg
GROUP BY breakdown_reg.[Breakdown Catogery HAVING (breakdown_reg.[Breakdown Catogery]=(SELECT [break_cat].[Catogorey] FROM break_cat WHERE [break_cat].[Main Catogorey]);

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Brigadier General:

    An expert that has over 10,000 points.

  • Master
  • 10,406 Answers

Check your spelling:

Catogorey] AS Expr1, breakdown_reg.[Breakdown
Catogery], breakdown_reg.[m/cname],
Catogery HAVING (breakdown_reg.[Breakdown
Catogery]=(SELECT [break_cat].[
Catogorey] FROM break_cat WHERE [break_cat].[Main
Catogorey]);
or find an upper-class student to give you one-on-one tutoring with your homework assignment.

Posted on Dec 03, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

What are the probable causes for DTC P0420?


Well, code 420 means the computer does not think the cat is working to spec.
The computer compares data from each O2 sensor - the rear sensor should be staying on the lean side or switching very slowly, while the front sensor switches back and forth between rich and lean several times per minute. If the cat is not working both sensors would read close to the same.
So if you replaced both sensors, and you still get code 420, the cat may be blown out.
A mechanic would use a scanner to watch the data stream from each sensor, and measure the surface temp of the cat.

Oct 08, 2015 | 2002 Toyota Tacoma

1 Answer

In php how to retrieve data while setting an conditon with multip


First of all, it's a Query that used in PHP. it should be like this.

select * from table_name where id in (value1,value2,value3 <---->

This will work

Jun 07, 2010 | The PHP Group PHP

1 Answer

Pin is blocked want,s me to enter puk


the PUK code is a "personal unlock key" assigned by a service provider to individual sim cards. This code was installed on the card to allow access to a device that has received multiple incorrect unlock queries. since these unlock key are unique to each sim card the only way to obtain the key is by calling the service provider imprinted on the sim card and request the PUK code. THey will ask you for the sim number and give you the code providing you can supply the correct verification info required by that company.

Oct 14, 2009 | Siemens M55

1 Answer

How to create a multiple access query and put altogether into 1 SQL Scrip(.sql file)


Suggest using Union Query. Thus, you can add more queries from many table and the output will be in one (1) query. Bear in mind that all fields must have same Field Name.

For example:
tblOne contains dtDate1 fieldname. Your query will select [tblOne].[dtDate1] As myDate.
tblTwo contains dtDate2 fieldname. Your query will have the following SQL:

Select [tblOne].[dtDate1] As myDate
UNION Select [tblTwo].[dtDate2] as myDate

Thus the output will result dates from tblOne and tblTwo in a column called myDate.

Regards,
Maha

Feb 05, 2009 | Microsoft Computers & Internet

1 Answer

Encryption and decryption(urgent)


Dazzling_ysi: If you do a project youare supposed to do research and not get the answer handed to you. You can ask for help with it and resources and a solution field is not big enough anyhow to write a "project". But to help you with it, this is a very goodresource on the topic:

http://eprint.iacr.org/2003/181.pdf

Let me citate some lines that I think even answer though shortly your question with FULL credit to the author:

" The advantage of multiple encryption: is that it provides bettersecurity because even if some component ciphers are broken or some ofthe secret keys are compromised, the confidentiality can still bemaintained by the remaining encryptions."

Disadvantage and danger:
" If a multiple encryption has a branch thatends with a parallel block, we are then able to construct an adversaryA that breaks it with only one key exposure query and one decryptionquery.
If a multiple encryption has a branch that ends with a sequentialblock, we may then be able to construct an adversary A that breaks itwith only one key exposure query on the last component and onedecryption query."

For more on the topic please read the pdf.

Jan 28, 2009 | Computers & Internet

1 Answer

Sumproduct or conditional sumif with multiple criteria in vba code...


i'll just reply to your conditional sumif query.

yes, you can do multiple criteria query but with a matrix formula. you may look it up. nonetheless, here is how one would look like:

{=sum(if(range1=A x range2=B x range3=C, sum range))} note that x (multiplication) is used to denote intersection of the criteria

initially, you'll enter it as:
=sum(if(range1=A x range2=B x range3=C, sum range))

then, edit the cell (F2) and press ctrl+shift+enter for the brackets { } to appear.

Jun 27, 2008 | Microsoft Excel for PC

1 Answer

Ms access


Stored Procedures don't exist in MS Access. You do have the following options though. Queries, which are just select or action queries. VB Code, which you can write using Query Objects as if you were writing a Visual Basic application. These can be Functions or Subroutines. In these, you would use the standard programming techniques with while and for loops, etc.

You can create complex situations combining the two of these. A function in the VB code area can accept through parameters, the single values (line by line, record by record) in a query and act on them and manipulate the values.

For example: create a query that does a select phone from address. Create a function in vb called public function StripDashesInPhone(Phone as string) which then uses VB coding to strip dashes from each phone value passed in. To make it all work, in the query on one of the field columns put "NewPhone: StripDashesInPhone([Phone])" and for every record processed in the query, the function is called with the [Phone] field value passed in to the function and the action is processed and returned.

Other than writing a function that is activated by a form button click, which opens the current db and opens a table and process it, just like in VB, this is about as close to cursors and oracle procedures as you get.

I wish it was more, but ...

Oct 09, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

52 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

101544 Answers

David Payne
David Payne

Level 3 Expert

14160 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...