Over 1 million tech questions and answers.


Q: Query

Hi there, newbie here.
See attached scree shot.
Question is how do I bypass this page to get into my files?

Preferred Solution: Query

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Query

Thank you for writing to us!
Unfortunately the screenshot has not been attached. Kindly private message the issue also with the service tag and email address.

Read other 1 answers

NOTE: I could not post code because I must be really careful to protect proprietary information.

I work in an assembly plant and I've designed an Access 2003 program to deliver a set of 4 crucial parts to the floor all within a very narrow degree of tolerance. Further, the program integrates FIFO.

Ive done this by assigning each of the essential measurements codes and then running a series of queries:

Query 1 identifies the oldest Part A by sorting the available parts by the date they were inspected then by serial number (to break ties) and delivering the TOP 1.
Query 2 identifies the oldest Part B that is compatible with that Part A using the same method.
Query 3 identifies the oldest Part C that is compatible with that Part B.
Query 4 identifies the oldest Part D that is compatible with the other end of Part A. I have the parts in this order because we can begin assembly if we don't have a Part D on hand, but we must have Parts A, B, and C.
Finally, query 5 simply pulls the information from those queries into one location for a report.
As long as we have enough stock, life is good; but the moment a match cannot be made, it blows up. I cannot figure out how to make it go back to choose the next Part A. I need to figure out how and where to add code to each query to tell it that if no stock is compatible with the Part A produced by Query 1, to go back and pick the next one in line.

Can anyone help? Is the way I've gone about matching parts completely... Read more

A:Access 2003 – Query Based on Query – need code to rerun earlier query

Read other 11 answers

Hi there,

I'm very new to access and I hope I will get the simplest solution on my question below.

I have a table named "PurchaseOrder" and I'd want to create a query that will display the invoices that will due.


PONo Customer Quantity SalesPrice InvoiceDueDate
3241 A 421 $12 17-Oct-2010
6589 B 521 $19 14-Oct-2010
2234 C 987 $32 15-Oct-2010
8697 D 888 $88 18-Oct-2010

I want to create 2 queries.

The first query will display all the invoices that will due 5 days before the exact due date.
The invoice due date is 15-Oct-2010. The query will display information on 3241, 6589, and 2234.

For the second query, I want to display all the invoices that have exceeded the due date. The information on the respective invoices will be transfered from the query as mentioned earlier to the new query.

The scenario is as below:

Date: 16-Oct-2010


PONo Customer Quantity SalesPrice InvoiceDueDate
3241 A 421 $12 17-Oct-2010
8697 D 888 $88 18-Oct-2010


PONo Customer Quantity SalesPrice InvoiceDueDate
6589 B 521 $19 14-Oct-2010
2234 C 987 $32 15-Oct-2010
Date: 18-Oct-2010


PONo Customer Quantity SalesPrice InvoiceDueDate
8697 D 888 $88 18-Oct-2010


PONo Customer Quantity SalesPrice InvoiceDueDate
6589 B 521 $19 14-Oct-2010
2234 C 987 $32 15-Oct-2010
3241 A 421 $12 17-Oct-2010
Hope someone can help me with this. Really appreciate and hoping for ur help.


A:Query Access 2007 (how to transfer data from a query to another query)

The first query needs the following first Criteria Row of the InvoiceDueDate
between date() and date() + 5
The second query needs
< date()

I haven't tested it, just worked from memory. so let me know how it goes.

Read other 2 answers

I've got a lending table in which we lend items out, now they can be loan or permanent.

I can run a report with the query parameter on the ReqDate_Fld criteria Between [Report Start Date] And [Report End Date]

The report prints and counts everything borrowed.

Now I want to add more records to the report to include everything borrowed that was returned during that period specified by the criteria Paramenter set in the query. But using the Return Date (RetDate_Fld)

How can I select rows from the query based on the parameter date filled in when the query ran?
[Report Start Date] and [Report End Date].

I can build a separate report just for the returns using the current parameter but on the RetDate_Fld Between [Report Start Date] And [Report End Date] set by the query.

I've got it grouping at 3 levels to get it to break by Borrower, ReqID, and Request Date

Does this make any sense?

A:Solved: Access query report query paramater use the param

You would have to have another group for whether or not the RetDate_Fld was filled in or not.
Add a new column to the query with the following Heading

RetDatefilled: iif(not isnull(RetDate_Fld), 2, 1)

That should place a 2 in the new column when there is a date and a 1 when there isn't.
You can now group on that data.

Read other 2 answers

I have written a macro to make a table from data in an existing table. Then I use the data in the new table to select information in another table. That select query does not allow me to update the information in the 2nd table. It is like the records are locked. Even if I create a new table myself the select queries are locked but all my pre-existing queries work fine. Is there some type of setting I am missing that causes the information to be locked in select queries? I am thinking somehow the setting may have been changed. Any thoughts would be appreciated.

A:Solved: Access Make Table Query and Select Query

Read other 7 answers

I have created a search engine for a data base using Access 2007
The Form Basically Runs a query of multiple fields and loads the result into a Combo box.
The problem is the data base is not fully complete and the records with blanks in some of their fields do not appear in the search results.
For example lets say I am looking for a People with the same surname and in my database is
Name Surname
Mike Norris
Chuck Norris
The query will not find the record only containing Norris
Here is the query I have used.
Like "*" & [Forms]![Entry]![txtSurname] & "*"


A:Query, Query Searching Blank Matches

Read other 8 answers

Hi there,

Once again I need your help in Access. I'm trying to do a calculated field in a query that based on a query. For example, query B is based on query A. I want to add a calculated field called Totals in query B. The field totals does not exist in any of my tables.

Here is an example.

Totals: [Field1]+[Field2]+[Field3]

In the totals line I clicked on Expression. But the totals do not appear when I view my query. I get no errors on the formula. What at I doing wrong??


A:Calculated field in a query based on a query

Read other 7 answers

For a report I have a customer table, an invoice table and a revenue or payment table.

I need to produce a report that shows all the invoices created during a given month and year - that part is easy.

But then I also need to show the first payment given on that invoice. This is a situation where there is always a down payment made at the issuance of the invoice - but sometimes people will make more than one payment during a month.


I want the customer listed for each new invoice, the total amount of that invoice and what the inital payment on that invoice was: [CustomerID][Customer Name] [Invoice No][Total Invoice Amount] [Payment Amt]

So if there was an invoice issued for $100 and they paid 50 and 25 during the month it was issued and the balance on the next month, I still want to show it on this report as a $100 invoice with a $50 downpayment only.

(The tables are established and populated so it is too late to change the payment table to allow for a unique downpayment field. They all go in as payments.)

My problem is that if they made more than one payment during the month, the whole line with the customer name and invoice number shows up for each payment made. I only wnat the FIRST payment. I need a payment query that shows only the first payment in the month of invoice issuance.

Does that make sense?

A:SQL Query question for Access 2010 query

Yes it makes sense, I would create a pre-query that uses the Month & Year but is set to "Totals" and Date Minimum.
Then create the Report query using the pre-query linked to the new query's table via the InvoiceID this will limit both the month, year and minimum payment.

Read other 1 answers

I have a previously designed Access DB and there is a query that I am trying to understand. It has several tables that are queried more than once in a single query. First how do I determine the actual table name? I can only see the alias name. Also what is the purpose of using the same table twice in a query?

A:Solved: Access Query using tables more than once in same query

It is normally to do calculations or comparisons on prior or next records. It is the one weekness of Access Queries, the Totals function has some good arithmetic calculations like average, Count Sum etc but manipulating previous records like add or subtract values from the current record it can't do. So it requires more advanced SQl. Which is apperas you have.
Have you looked at the query in SQL view?
It should use the word "As" to designate the alias.

Read other 2 answers

Hi Access bods.
Can anyone tell me how to do an expression to query from DATATABLE (the name of table), containing

ID: Auto ID key for the table
SITEID: There are multiple sites
ITEMID: Each site will have multiple Items
QUALITYID: This is set to either F, or is left blank
Id like to find the Percentage of Non-F, to each SITEID and ITEMID combo. I hope this makes sense.

A:Solved: Access Query, Query

Read other 6 answers

...ookie crumbs?

Point 3. Clear out your temporary internet files and temp files.

What does this mean, is it....

Get rid of them?

Clean them of stuff?

What if there are things that i want to keep in these files, should i move them to a more permanant place?

orrrr, is this just a consequence i gotta put up with. Ok, so i lose lots of stuff i've saved (if there is lots, dont often check) but my computer will be clean and safe?

If there is something REALLY important in the temp file and clear means get rid of, is there a way of salvaging the contents that arnt bad?

A:Query ~ Instructions For Hijack This Log ~ Query

You should not have any files that you want to permanently save in Temporary Files. I have included directions for cleaning IE.
These instructions explain how to delete Temporary Internet Files. Microsoft Internet Explorer (IE) uses the Temporary Internet Files feature to store copies of Web content on the local hard drive. This feature improves network performance but can fill the hard drive with large amounts of unwanted data. IE allows many aspects of the Temporary Internet Files feature to be controlled, including the ability to delete temporary files as needed.
Difficulty: Easy
Time Required: < 1 minute
Here's How:

1. Open either Microsoft Internet Explorer or the Windows Control Panel.

2. In Microsoft Internet Explorer, open the Tools menu and choose the Internet Options... menu. In Control Panel. open the Internet Options list item. In either case, a new window titled "Internet Properties" appears.

3. In the Temporary Internet Files section of the Internet Properties window, click the "Delete Files..." button. A new "Delete Files" window appears.

4. In the "Delete Files" window, optionally check the "Delete all offline content" checkbox to also remove temporary files IE has saved for offline viewing. Click OK. A delay of up to several minutes may occur as IE proceeds to delete the temporary files it has cached. If the "Delete all offline content" checkbox is not checked, IE will not del... Read more

Read other 8 answers

hi there,

I have a large Access database and some of the queries are based on other queries (sql or other).

Now when I try and view the design mode of some of these queries, it takes an astonishingly long time as it appears that Access runs the child query contained before it allows the 'parent' query to show in design mode.

I can kind of see why it does it - but is there any other way of quickly viewing a query in design mode without Access first running the other queries it's based upon?

(NB: Someone said in the 'old days'(!) Access used to have this feature, but it is no longer there?!?!?!)


A:Trying to look at design of query based on another query...

Bounce in case of new eyes to the forum!

Read other 1 answers

I am pulling information from another program into Excel via Microsoft Query and one of the columns I want to pull in involves a date a payment is due. I am wondering how to write the query to have it always pull today's date +1 so essentially it would always pull tomorrow's payments due. Thank you!

I tried to add Where date = DateAdd("d",1,date()) but I am getting this error: "general odbc error." What does this mean and is there a way to fix it or alter query?

A:Help with date SQL query in ms query

Hello, in Access Queries you can just use
Date + 1
so perhaps it will work for MS Query.

Read other 1 answers

Can I set DNS as on router & systems?

A:DNS Query

I'm not really sure I know how to answer your question directly since I don't get it but what I can say is: if you set a DNS on your router, your wireless devices, including wired devices attached to your router will automatically use the DNS your router uses. There is no need to set them up separately. As for setting a local IP as a DNS (I'd assume it's the IP your router uses which is also used for DHCP), I'm not really sure how that would work or if it could even work. I don't imagine a router has the ability to look up and resolve IP as domain names. If it could, I can't see a reason why DNS companies like OpenDNS exist.

Hope my answer wasn't useless. I'm feeling I'm misunderstanding the question somehow.

Read other 8 answers

There is a PC where I volunteer, that seems to have been tampered with, all the files that were on the PC are still there, but the Microsoft Office seems to have been reset and the AVG AV has gone.

Anybody have an idea on how this was done ?

A:PC Query

What do you mean the "MS Office was reset"? == Does the PC have a password so only a few can enter it? If so those would be the people to ask.

Read other 9 answers

I tried to run a dvd that has stuff that can only be accessed via a dvd rom , but get told that I'm missing the software needed to run it. Is it possible to be able pick that part of Vista for free? When I got this laptop a good chunk of it was missing

A:DVD query

It might help to know what kind of data you are accessing it and the error that you are getting.

Read other 5 answers

Does anyone know how to write a DB2 query to list all stored procedures in a DB2 database?

A:DB2 Query

Read other 6 answers

I watch BBC I-Player on my Android Nexus 10 via an HDMI lead to my large screen TV. On trying to repeat this process with Sky GO I find that Sky have disabled HDMI acces to Sky Go applications.

Coukd I get round this using an MHL lead.

Any help would be appreciated.

Read other answers
Q: query

what is the best disc you can reccomend for backing up my vista

Read other answers

I Need help to create a batch file to add users, groups, group memberships & passwords..? (for IT course)

So far I have managed..

Net User /add Bill.Smith [email protected] (save as bat)


Users - Bill.Smith | Fred Bloggs | John.Blackmore
Passwords - [email protected]
Groups = Sales | Admin | Quality Control


A:net.exe help with query..

Try net help user instead of net user /?
You'll get a lot more info.
Net User and Net Group will do what you want.

You can put the users and their groups into a text file and use a For loop to read the data and then run the net commands as needed

If your data file is formatted like this:
Bill.Smith, [email protected],Sales
Fred Bloggs,[email protected],Sales
John.Blackmore,[email protected],Quality Control

Read the file with this:

FOR /F "tokens=1-3 delims=," %%I In (data.txt) Do (
commands here
%%I will be the user name, %%J will be the password, and %%K will be the group name. As you have both user names and group names with spaces, don't forget to put quotes around the variables.
You can add other info as needed like FULLNAME, USERCOMMENT, etc. Just change the tokens= line to match the number of variables. If you need to use a comma in a comment, you'll need use something else to delimit the file. A tab can be used, but you can't copy and paste a tab (it gets converted to spaces) so be aware of that. Entering the data in a spreadsheet and then saving the file as a tab delimited text file works quite handy though.

Would be a good idea to first test if the group exists. If it doesn't you'd need to add it first. (Think pipe existing group list to Find with %%K as the search string)



Read other 1 answers

Connecting to home network from remote location (Windows XP) - can connect OK to same workgroup but cannot see other (remote) PC's once connected. Can ping the remote router & other PC's OK but they don't show up in "My Network Places".

First time VPNer so please excuse if I'm missing something obvious but can anyone point me in right direction please?

A:VPN Query

Read other 7 answers
Q: Query

Have a friend who bought a used machine for his young teenage son that I think is dodgy - bought it as seen from one of his wife's work mates.

I suspect the 7 he has is not an entirely genuine one as the machine was originally a Vista one and there is no MBR (I think the HDD has been scrubbed or replaced)and I can find no way of factory defaulting it -I've tried numerous ways but nothing.

The only thing I have is the OEM Product ID in "System" and I don't want to go checking too deeply as obviously as I don't want to get him into strife, as he is not computer savvy - nor am I for that matter but I can spot something not quite right like this puppy.

I did find some cookies of porn sites on it that I cannot get rid of - ideas?? I can clear them with CC but if one uninstalls and reinstalls the CC the cookies come back!


Can you post the specs of the rig you are working on?
Can you post a screen shot of Disk management?
Screenshot tools.
A Preferred Method of Uploading/Posting Screen Shots
How to Use the Snipping Tool in Vista - Vista Forums
Snipping Tool - Windows 7 features - Microsoft Windows
Use Snipping Tool to capture screen shots
Screenshot with Paint
Screenshot and Upload using MWSnap
fscapture free download

Use Snipping Tool to capture screen shots

Read other 9 answers
Q: A query

does java jdk will be installed on windows7ultimate which has 32-bit has operating system

A:A query

Quote: Originally Posted by naveenkumar

does java jdk will be installed on windows7ultimate which has 32-bit has operating system

Excuse me. I dont understand the question.

Read other 2 answers
Q: Query

I have a table of staff names who took inservice courses on different dates. I want to query the table to give me the names ofmall staff who took the inservice cours in January and not in March so I can have them take the course again
Any suggestions


I purchasing a new PC and would like to buy one that will last me a while, currently I am running 1Gb and have heard some people say that 2Gb is not really need now but in the near future, so I thought about getting it now and then no need to worry about it later (getting the same stick and configuring etc).

The PC is a gaming PC and Camcord to DVD working/burning.

The question is what is better 4x 512MB or 2x 1GB

AMD Athlon64 3700+BOX,Socket939,SanDiego
Asus A8NSLI Deluxe,
Corsair TWINX10243200C2, 4x512MB DDR400DIMM,CL2
Western Digital Raptor WD740GD,10000rpm,74GB,SerialATA
Silentmaxx HD Silencer
160HB 7200rpm.
3.5 Floppy
NECND3500A, 16xDVDRWWriter, DoubleLayer,Bulk
Asus 6600GT 128Mb
Be Quiet Blackline BQTP5470WS13
Thermaltake Armor VA8000SWAD,Silver,Aluminium
Coolermaster AerogateIIALDV02 silber
Arctic Freezer64, Socket754/939/940

I do not see that 2Gb will need to upgrade before 3 years and if so will bite the bullet then should I need more RAM, therefore filling the 4 RAM slots on the board is not an issue

A:RAM Query

Read other 7 answers

Hi! 1)What is the highest version of Internet Explorer that I can run on Windows 2000 OS? 2) What is Active X?
Whenever I open Gmail it says that my browser isn't fully supported. Hence I need to upgrade to a higher version of Internet Explorer. Thanks .

A:Query: I.E

IE6 Is currently the highest version available. IE7 is available, but it`s still in beta form and I don`t recommend you try it.

If you run Windows updates you will be able to get IE6 and any other updates for your system.

ActiveX see HERE for info.

The reason Firefox etc don`t support ActiveX is because it`s considered a security risk. The sooner websites stop requiring the use of ActiveX controls the better.

Regards Howard

Read other 2 answers
Q: Query

Does anyone know what this is ... "Se00bldsv" ?
I found it listed in services under Administrative tools. ( XP Home SP 2)
It is disabled ... but when I googled it I did not get any hits.



Definitely looks suspicious to me...I can't find anything about it either. What does it give for a description in "services"?

Read other 1 answers

Looking for someone with significant knowledge of PXE boot OS installations. Trying to learn to perform this taskt with a spare laptop, Vista Ultimate desktop and a Linksys router. Information is difficult to find.

Read other answers

Hey guys,

Not sure if this is the correct place to ask for SQL help, but I couldn't find any other place. If it is, I'm sorry.

My problem is that I am trying to find all of the records in a table that do not have the proper date. Here is an example of the proper/incorrect dates

Proper: 04/04/2007 23:59:59
01/17/04 03:59:59

Incorrect: 04/04/2007

I basically need to go in and ad 23:59:59 to each of these records "end dates" after finding which ones in deed need them.

So far, I have...

select * from table.records rc
where to_char(rc.enddate, 'hh24:mi:ss') not like ('23:59:59')

But this only pulls the entries where the date is not that particular time. I have entries where the time may be 10:00, 11:00, etc...

Is there an operator out there or some way where I can just say only give me the records where the date does NOT have an hourperiod attached to it?

If theres anything else you want to know, just ask.


A:SQL query help

Hello, Scott, I am not an SQL man, only by using it in Access.
Wouldn't you be better trying something like Isnull(rc.enddate, 'hh24:mi:ss')
or Val(rc.enddate, 'hh24:mi:ss')) = 0

Read other 2 answers

hi guys, i have a Laptop that has 256mb of ram. now i have just downloaded the public release of windows vista and i am trying to install it.

the setup demands that i need 256mb of ram which i already have and exits. now when i go on system properties, it says i have 244mb of ram. why is this and is there any way i can make this 256mb?



A:RAM query

you may have memory allocated for video - although 12MB seems a little low - but that may be the min

Read other 3 answers

I hava table iwth the following data:
Albania Europe 28728 32000 66500
Algeria Africa 140000 8600 8500
Belgium Europe 30528 29000 60900
Benin Africa 11262 6000 3630
Chad Africa 38000 7200 4600
Mexico NorthAmerica 68000 25500 38000
Italy Europe 31200 38500 68000

Now Im trying to find out the regions having total populations less than 30000.
Could anyone help me out with this??

A:sql query

Read other 8 answers

does anyone know how , please can you let me know thans..

A:help with query!

sam5577 said:

does anyone know how , please can you let me know thans..Click to expand...

I would suggest that you Google

Read other 2 answers
Q: Query

Can someone please tell me the difference between V.35 and G.703 standard. IT and Telecom companies tend to use them interchangably for E1s. Kindly explain the difference.


What is the difference between G.703 and V.35 ?
V.35 is a balanced connectivity provided with Winchester type connector. It has 34 pin, DTE type connector terminated with end equipment. G.703 is an unbalanced connectivity using co-axial cable with BNC connector.(75 ohms) is terminated with end equipment.

http://www.querycat.com/search?q=difference between V.35 and G.703:up:

Read other 3 answers
Q: Query

Windows 7 build 7601 this copy of windows is not genuine.how to make it genuine

Read other answers

I am just wondering what programs are available that are like mac and ubuntu.

Here is what i am looking for:

Toolbar like mac and ubuntu have
Its like an interactive toolbar thing that you have on screen where you can place the icon for programs.
Mac and Ubuntu both have them i think.

Hope you know what i mean.

If you do could you suggest any free programs i could use as they look cool.

Also, are there any disadvantages to this??


Read other answers

According to my device manager I have one USB 2 port and 4 USB 1 ( I presume), is there a way to find which is the USB 2 port. For instance will one be marked as such or is it trial and error to find the faster port.

Read other answers

According to my device manager I have one USB 2 port and 4 USB 1 ( I presume), is there a way to find which is the USB 2 port. For instance will one be marked as such or is it trial and error to find the faster port.

A:USB query

This Wikipedia website might help you.


Read other 4 answers

I am testing SUS on an XP SP2 PC. The registry settings download the updates
to the PC from the server but they do not install. Why is this. The registry
settings I used are below. Thanks for any replies.



Read other answers

Trying to VNC from my networked computer to another on a network. I've tried putting in the main IP for that network but obviously it won't connect nor will putting in the local IP. Does anyone have any clues to a way I can access?

Thanks in advance,


A:VNC query

Just some clarification. Are these computers on the same physical network or are they on different networks and you need to use the internet to get to the other one.

Read other 3 answers

Hi Guys

I have a few computers connected to each other via a switch, the rough diagram of which is as follows:

Please help with answers with the following doubts:
I have enabled Internet sharing in PC1, which actually gets connected to the net via ADSL Modem. At present I am able to access from all PC's without a problem. Even if PC1 is not connected to the net, if I try to access the net from any other PC, PC1 automatically gets connected.
What I want to know is that is it possible to disconnect the internet connect from other PC's other than PC1.
As there are ways to switch off / restart / log off any PC in the network, is there a way to a PC to standby mode via some other PC on the network. I actually want to put PC1 to standby from PC2. Is it possible.
If I enable file sharing of any drive in any particular PC, all other PC's are able to access the files without any restrictions. Is there a way to set a password so that only the person with the correct password can see the files.
Please help.

Thank you.

A:LAN query!!!

Read other 6 answers

Hi Guy's
hopefully somebody can answer my query.... I have a memory (RAM) question.
Currently have a PC with 3Gb of RAM installed, 2 Hdds.... XP Pro & Vista H Premium, dont use the Vista option very often..my query is.... the 3Gb is recognised as being 3Gb, I have just purchased another 2Gb stick & removed the 1Gb so now I have 4Gb however the PC only recognises 2.50Gb in both XP & Vista? tried both sticks on there own both show as being 2Gb

Motherboard Max Capacity: 4096
Memory Slots: 2

Both sticks 400MHz DDR2 800

Any advice

A:Ram Query Xp Pro Sp3

Hello frazzeld,

From what I understand, Vista uses a portion of memory to perform other functions. This ammount is then discounted from the total.
With XP, do you have intergrated graphics? If so you may find that the graphics is using some of the RAM.

Read other 3 answers

Hi everyone,

I have an sql query that pulls together (from a list pasted into a table) the names which go with the list... just basic cross referencing.. looks like this:

SELECT [table1].[no], [table2].[name]
FROM table1, table2
WHERE [table1].[no]=[table2].[name]
ORDER BY [no];

which works fine, but as a bit of fine tuning, can I make the query return a string such as "N/A" when a [no] is not found... instead of just omitting it from the results?


A:SQL query, query :)

You can try this.
I already tested this on our Ingres DB.

SELECT IFNULL([table1].[no],'N/A'), [table2].[name]
FROM table1 LEFT JOIN table2
ON [table1].[no]=[table2].[name]
ORDER BY [no];

Take note of the LEFT JOIN Clause, and the ON Clause.

I hope this will work for you.

Read other 3 answers

can a 5"14 diskette be used as a boot disk? (you know, the primitive ones)


Yes, provided it is set up as the A drive. Most floppy cables have two connection positions, one for A and the other for B. The A position is at the end of the cable and has a few wires that are separated and twisted at the end. The B position is between where the floppy cable connects to the main board and the other end.

You cannot boot from B, only A.

Most 5.25" drives have a connector very different from the one on the 3.5". You'll need a floppy cable that has both styles on it. These are usually found on older systems. I have noticed that no new boards are shipped with the dual-style floppy cable connectors.

Read other 2 answers

Hi guys,

I'm trying to solve a little sql problem -- I need to cross reference and dump out a list of records that don't belong. The existing query uses a left join between two tables... I need to add some more 'AND' statements in the WHERE line because the query needs to take into account other tables... hence I need to include those tables in the from line. How do I do this, when there is a left join already there?

For example:

FROM tblOne LEFT JOIN tblTwo ON [tblOne].[item1]=[tblTwo].[item2]
WHERE ((((DatePart("m",[Date])=[Enter Month])) And [tblTwo].[item2] Is Null));

How can I go about adding:

WHERE ........ AND [tblThree].[item3] Is Null AND [tblFour].[item4] Is Null));

To the end of that?

Quick responses will be much, much appreciated.

Thanks guys!

A:SQL query ;)

Read other 7 answers
Q: query

can I install windows xp on my linux laptop


Yes you can. However, you'll lose your Linux. To run dual operating systems you need Windows on the 1st partition of the 1st hard drive. Windows followed by Linux.
If you let XP take all the drive, then Linux will automatically take the amount of disk it requires and leave Xp good. Linux will install a Boot manager. You then select which ever OS you want at Boot.
NB. After this install Xp will go to a Blue checkdisk screen, just let it run and all will be OK.

Read other 1 answers

good afternoon eveyone....

i have a question regarding my ram its not really vista related i bought 2 new sticks gskill pc8000 1000mhz 2GB (1GBx2) i wanted to find my max overclock with this ram but it means removing my current 3GB pc5300 667mhz (1x1GB 1X2GB)
once i find my max overclock i want to stick those sticks back in with the gskill i know they are different native speeds but will they work.....
if so will they run at the lowest speed - 667mhz

this is only till i get 2 more gskill matched pairs
though i might as well let vista munch its way through 5GB instead of letting them rot..

what do ya think....?

A:ram query

Hi skunksmash,

Your ram will run at the speed of the lowest mhz stick installed. What mhz is the max overclock sticks? You might experiment to see if your system will run faster with just the gskill 2GB @ 1000mhz ram versus the 5GB @ 667mhz. It may be faster with just the 2 GB @ 1000mhz if you do not have alot running at one time. If your max overclock sticks are faster than 667mhz, say 800mhz or higher, then it may be worth having them with the gskill 2GB sticks. You will just need to try each setup and run it through it's paces to see what feels faster for you.

Hope this helps,

Read other 3 answers