Over 1 million tech questions and answers.

Solved: "Type Mismatch in Expression" - Access Query Problem

Q: Solved: "Type Mismatch in Expression" - Access Query Problem

Hi all,

I just created an Access database and I'm having trouble running the query. I keep receiving the error message "Type Mismatch in Expression". I have triple checked all of my underlying fields and they all match so what am I doing wrong? I can't upload the file as I'm at work and don't have access to my FTP so if you are able to assist me with hosting this file, it'd be greatly appreciated. (Note: all names & addresses included in the database are fictitious).


Preferred Solution: Solved: "Type Mismatch in Expression" - Access Query Problem

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: Solved: "Type Mismatch in Expression" - Access Query Problem

Read other 9 answers

I am creating a report to display details from golf tournaments, it's part of my study.

I have a query to run the report but both display "type mismatch in expression". I have gone over every table the query is linked to and everything is the same. Any help/advice would be greatly appreciated.


A:Solved: Access 2010 "type mismatch in expression"

Read other 9 answers

Hello everyone,

I created a database using access and I'm having difficulties running a query, as an error messages keeps popping up stating "type mismatch in expression". Can someone help me with his issue, Thanks in advance.

Read other answers

I'm trying to set up aq_1 query and it keeps giving me the message "type mismatch in expression" I can't understand why?

A:Solved: Type Mismatch In Expression - Access 2010?

Read other 11 answers

Hello forum, I am having an issue related to Access 2010. I am trying to run the querie and honestly, I'm lost. I keep getting this message "type mismatch in the expression". I would appreciate if someone could check the file that I have attached and tell me what the problem is. Also, if they could explain it with really basic language. I am new to this program. Thank you in advance!
EDIT: I thought I had attached it. I'll attach it below.

A:Solved: Access 2010: Type mismatch in the expression

Here it is attached.Thank you.

Read other 2 answers

I am working on an assignment for school. I am following the book step by step and my query looks just like the books. I am trying to join 2 tables. When I joined the 2 tables I did not get the join line automatically even though my table lists and keys are again identical. I had to manually create it. When I include the 2 fields from the 2 tables I have 2 fields that are sort in ascending order. There are 5 fields total. Every time it run i get a type mismatch error. Help. I am using access 2013 and windows 8 operating system. (I also don't know how to zip a file to attach the database)

A:Type mismatch in expression (access 2013)

That message means that one field is a number and the other field is text or a date.

Read other 1 answers

There is a Lanier LD117 Printer recently installed in the office, which is connected to the network, to be used by the two computers in the office (both are Windows 7 equipped). However, the printer shows "offline" on the computers when the printer
is on.
Secondly, the printer says there is a paper type/size mismatch. After changing the printer (and the computer) settings to the correct ones, the printer still says its mismatched. And the confusing thing is if you select FormFeed manually on the printer,
the documents that are waiting will print anyways, even though it says it cant and even though the computers say its offline.

How can I reset the system so the documents will print automatically upon command via the two computers?



Read other answers

I recently built a call log database in Access 2007 for my team to use when calling agents on our top errors we see from a vendor's error report. My boss is requesting a report to see how many items have been resolved

I have a query started and I am trying to complete this task in a single query (if possible) instead of several queries (as I've done for a couple other things).

I have 3 tables I'm using: Assignment, AgtInfo and CallLog
Joins as follows: Assignment.st=AgtInfo.agcy_st

Fields in the results: Assignment.assigned_analyst, CallLog.rpt_mnth, CallLog.resolved

Resolved is a yes/no field. I've done a query that converts the -1 to a 1, so that the sum is a positive number for the "Yes" values. I'm not sure how to enter the expression to subract the "Yes" values from the total number of values (yes/no) to get to my "No" count.

Essentially, I'd like the results to display as:

assigned_analyst, rpt_mnth, CountYes_resolved, CountNo_resolved

Somehow the connection is just not clicking in my brain with everything I've read though searches. Any help is appreciated! Thanks!

A:Solved: Access 2007 Query: Return count of "Yes" and "No" values for Analyst/Report M

It is easier to add another column to counf the Nos, use
0 or is null
as the IIf statement and use a 1 to count them

Read other 3 answers

Hello Again,
I have a form (frmGPCustData) that is populated with a query (gryGPCustData) based on 3 linked SQL tables. I have created a report with the same query , I want to print only one record based on a the unique document number (SOPNUMBE). On the form a have placed a command button with the following code;

Private Sub cmdPrint_Click()
'Print Current Record
If IsNull(Me!SOPNUMBE) Then
MsgBox "Please Select a valid Record", _
vbOKOnly, "Error"
Exit Sub
End If
DoCmd.OpenReport "rptGPCustData", , , _
End Sub

I get "Data type mismatch in criteria expression" error.
All I want is to print the current record only, not the entire report

A:Solved: Data type mismatch in criteria expression

Read other 12 answers

I suddenly get the error: Data type mismatch in criteria expression. When I want to run the code which creates an invoice in our Access 2003 Database:

here is the code:

Private Sub cmdViewInvoice_Click()
On Error GoTo Err_cmdViewInvoice_Click
Dim blRet As Boolean


Dim stDocName, stLinkCriteria, fileloc, fileBak, fileBakbak, sHostName, sUserName, MyShell As String
Dim thisInv As Long

stDocName = "rptInvoicing"

' Get Host Name / Get Computer Name
sHostName = Environ$("computername")
' Get Current User Name
sUserName = Environ$("username")

''' do all checks here
If Nz(Len(Forms!frminvoicing.txtRef), -1) = -1 Then
MsgBox "Please provide at least one reference", , "No Data"
Me.Visible = True
Exit Sub
End If

If CheckInvoice() = False Then
If Nz(Me.txtInvChange, 0) > Nz(Me.txtInvPrint, Me.txtInvChange) Then
MsgBox "This invoice has been changed. Please ensure the correct invoice is sent to the customer and that all other copies are destroyed.", vbCritical, "Changed Invoice!"
End If
End If

thisInv = Me.InvoiceMainID

''''''''''''''' check for authorisation for credit notes.

If Forms![frminvoicing]![Invoicing].Form![txtTOT] <= -500 Then
If InputBox("Please enter the credit note code", msgboxTitle) = "chairmanmao" Then
'do nothing
Exit Sub... Read more

A:Solved: Data type mismatch in criteria expression.

Read other 10 answers

In my report I have multiple sorts on and in fields in headers and footers that all are set visible based on the value of a optionbox for each record. Ex. In the detail - show 1 if option is yes else 2. The same goes for the footer which has sums of 1 and two. I accomplish this by putting if statements referring back to the field in the table [option] in the on print event of the detail and footer. This has been working but recently I have made a form to make reports based on specific values. All of the filters work except one which says that [option] has no value. Is there some other way I can accomplish the hiding and showing of my fields and their sums?

A:Solved: Access "expression has no value"

madctch, it is more normal to place your VBA in the Header, Group Header, Detail, Group Footer or Footer "On Format" event procedure.
Do you know why your Expression has "no value"?
You can use the Report's "On Load" event to trap that kind of error and change it if necessary for use in the On Format event.

Read other 2 answers

What is this error message popping out whenever I try to open my Cafe-Manila version 8.2.0? Help me please... Thanks in advance!

A:Help! Cafe-Manila "Type Mismatch 13"

What is the "Type mismatch 13"?

Read other 1 answers

I get this error message however I can't seem to find where the problem is at. I'm sure its something simple but I can't figure it out. I've attached it.

A:Type mismatch in expression

Read other 6 answers

I had to change a text field into a number field. The existing queries all work fine, but when I try to open a report I get the error " data type mismatch in criteria expression". When I click on debug it shows the code behind a button as follows:

Private Sub Initialreport_Click
Dim strDocName As String
Dim strWhere As String
StrDocName = "initialreport"
StrWhere = "[Numberclient] = """ & Me. [Numberclient] & """"

(With this bit highlighted) DoCmd.Openreport strDocName, acPreview, , strWhere
End Sub

This code worked fine as long as the field was text. Now that the field is changed the error pops up. When I click on the report itself opens without a problem but then I get a continuous form where everyone is listed. It is just when I try to click the button to get the report of the active file that the error persists. I've
looked in the report design, changed the Numberclient field format to General Number but to no avail.

Any ideas?

Solved, saw on another forum that the quotation marks had to go since it was a number and no text or memo field.

A:Data type mismatch in criteria expression

If you go to the immediate window in vb when the code stops, you can type

msgbox Strwhere
. Does it return a valid location?

Read other 2 answers

Using Access 2003...

I have a query setup to only output the following expression when certain conditions are met (so that only the wanted records are output in the expression), the query being:

<name>[PROJDES1]![Project Name] </name>
<description>[PROJDES1]! [Project Description] </description>

where PROJDES1 is the name of the table, and the other brackets contain the field names whose values should be put there. But instead of the the whole query being output, I only ever get the following for each record that matches the query's conditions:

| Expr1 |
| <Placemark> |

What am I doing wrong? Thanks!

P.S. The query is setup such that the expression is in the "Field:" field, "Table:" field is empty (I get a syntax error if I try to fill that in with the table's name and then save the query), "Sort:" field is empty, "Show:" checkbox is checked, "Criteria:" field is empty and the "or:" field is empty ...there are of course other boxes in the query that limit it just to select records but that's not the issue so I won't go into how those are setup, thanks!

A:Solved: What's wrong with this MS Access Query expression?

Read other 7 answers

Alright so i am using BlueJ and i am very VERY new to programming. I am programming in Java and i am getting a compile error stating "Illegal start of an expression" on line 5 where it says "private String firstName;" Thank you in advance for your help!!

public class PlayerClass
public static void main (String[] args)
private String firstName;
private String lastName;
private int idNumber;
private int chips;
public Player()
public Player(String n1, String ln, int idnum, int ch1)

A:Solved: "Illegal start of an expression" error in Java

The Illegal start of expression error is being generated because variables declared in the main method cannot have what are called access modifiers(public, private or protected). Any variables declared in the main method can't be accessed by your class methods, Player() and Player(String n1....) so your two methods will through errors as they can't 'see' the variables you declare in main.

Anything you want accessible by class methods should be defined in the class, like this:

public class PlayerClass
private String firstName;
private String lastName;
private int idNumber;
private int chips;

public static void main (String[] args)

public void Player()
public void Player(String n1, String ln, int idnum, int ch1)

You may also notice that I added return types to your methods. These are needed to show what the method returns, for example if this was a method:


[COLOR="Red"]int [/COLOR]add(int num1, int num2)
int sum = num1 + num2;
[COLOR="Red"]return sum;[/COLOR]

you can see that this method returns the int sum. You need to tell the compiler what you will be returning by adding the type in the method (in red)
As your methods don't return anything, you give them a return type of void

Other stuff that doesn&#... Read more

Read other 2 answers

System is PC Win 7 SP1 64-bit for what that's worth in this situation. I'm a rank beginner in Java, pretty new to programming in general. The following code (within a larger program) generates 4 "illegal start of expression" errors (lines marked).

I've matched my brackets for the entire program, there are no methods within methods. Notice that all four errors are on "if" statements with logical operators && and ||. The code lines with a simple > don't throw errors. Am I using the operators wrong?

Thank you!

if (gender == "f")
if (age >= 25 && <= 29) //error 1
System.out.println("The female renter is " + age + " years old. The rate class is: Rate 1 - $50.00 per day or $255.00 " +
"per week.");
if (age >=30 && <= 62) //error 2
System.out.println("The female renter is " + age + " years old. The rate class is: Best rate - 40.00 per day or " +
"$200.00 " + "per week.");
if (age > 62)
System.out.println("The female renter is " + age + " years old. The rate class is: Rate 3 - " + (40 + ((age-62) * 2)) +
" per day or " + (200 + ((age-62) * 5)) + " per week.");
System.out.println("Sorry, the renter is not 25 years of age or older.");
if (age >= 25 && <= 32) //error 3
System.out.println("The male renter is " + age +... Read more

A:Solved: "illegal start of expression" -- I've checked -- what am I missing?

I figured out the problem. A noob syntax error. I cleared those all up and eagerly hit Compile only to be hit with a lot more errors. This program needs more work before a single Q&A will fix it. Thanks anyway and good luck to everyone.

Read other 2 answers


Is it possible to start the app without "Security Worning" window ("Cancel. Open, More Info" buttons)? If yes, how you can make changes then?

Is it possible to start the app without "Microsoft Access" window on the background?


A:Solved: Access 2003 - To start the app w/o "Security Warning" and "Microsoft Access"

Read other 6 answers

Hi All,

I have two forms to delete employees from 5 tables.
Employees are not the primary keys in those tables, the type is set to text for all and they are indexed (no duplicates). Only one table has a primary key, wich is an autonumber, called ID.
The first form is only a combo box to select the employee name to delete. The control source for this is one of the tables with no primary key.
The second form is a modal pop up and has a locked text field which displays the name of employee selected on the first form and asks the user to double check if they wish to delete. They have an option to select a command button called no, which will close the 2nd form. If they select the other command button called yes, it runs 5 delete queries then closes both forms. The delete queries clear all data from the 5 tables for the selected employee. The criteria of executing the query is that the name in the field matches the name selected on the first form.
To run the 5 queries and to close both forms I'm using this code:

Private Sub Command12_Click()
On Error GoTo Err_Command12_Click
stDocName = "Delete employee - from employee only tbl"
DoCmd.OpenQuery stDocName, acNormal, acEdit
stDocName = "Delete employee - from eployee tbl"
DoCmd.OpenQuery stDocName, acNormal, acEdit
stDocName = "Delete employee - from gloves tbl"
DoCmd.OpenQuery stDocName, acNormal, acEdit
stDocName = "Delete employee - from managers tbl"
DoCmd.OpenQuery stDocName, acN... Read more

A:Solved: Type mismatch in access 2003

Eva, if you are absolutely certain that everything is working OK you could switch off the system warnings until the code has finished and then switch them back on again.
The code is
docmd.setwarnings false
for Off and
docmd.setwarnings true
to switch them on

One point I would like to raise is that with correct Table/Relationship design you can use "Enforce Referential Integrity" and "Cascade Deletions", this allows you to run just the delete query on the Main table with the key field, Access will automatically delete any records related to that record in the other tables.

Read other 2 answers

I added a slave drive to my Windows XP Pro computer, and it appears to work properly.

However, when I open the "Documents and Settings" folder (on the slave drive E:\, which is Windows XP Home Edition -- not XP Pro), I do not see any of my documents, sub-folders, etc. There should be MANY sub-folders (inside the "My Documents" folder which isn't even visible), with hundreds of documents, jpgs, etc. within it.

When that drive is installed as the Primary drive in my other computer, the User "Larry" (which is me) has all Administrative privileges. On the computer that I'm running now (with the slave drive in it), I also have Administrator privileges. I own both computers.

My User Name "Larry" is password-protected when I login to Windows (when the drive is Primary and installed into my main computer (not this computer with XP Pro).

I've tried clicking on all the users; Administrator, Default User, Larry, Guest, etc. (Note: I get an "Access Denied" error when clicking on the Guest "Documents and Settings" folder).

So, the questions are:

1. Why can't I see any files or subdirectories in the "Documents and Settings" folder on the slave drive?

2. There's supposed to be a folder named "My Documents," but I can't find it. Normally, that path is "C:\Documents and Settings\My Documents".
--- Where is that folder? It contains all the files I'm looking for.
... Read more

A:Solved: Slave drive "Access Denied" on "Documents and Settings" Folder

Follow the directions here to take ownership of a file or folder.


Read other 2 answers

Can anyone please help! I'm allowing users to choose with a check box on a form whether they want to see all records or a specific one. Checking the check box, displays a list box with all available records. In the criteria field of my query I want to use an If statement like this:
IIf ([Forms]![Form1]![chkSelect]=true, [Forms]![Form1]![lsbRecs],Like "*")

If I use the above I get some error saying that the expression is typed incorrectly or it is too complex to be evaluated. Is this just some silly syntax problem or is it not possible to do it this way round?

A:Access 2K: Like "*" in IIf statement for query criteria

Read other 6 answers

I am trying to use the fsutil file setshortname to set "Program Files" to PROGRA~1,

but the system is giving me an "Error: Access is denied" response.
what I have typed:
Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.
C:\Windows\system32>cd /d D:\
D:\>fsutil.exe 8dot3name set 0
The registry state is now: 0 (Enable 8dot3 name creation on all volumes).
D:\>fsutil file setshortname "Program Files" PROGRA~1
Error:  Access is denied.
And I try it in Safe Mode.It is also "Access is denied.".
Can someone
help me?

A:"fsutil file setshortname "Program Files" PROGRA~1"=>"Error:Access is denied."

Hi TimFF,
This might be related with the UAC settings, check this thread:
give full permission for the users in program
files folder
The steps in the above thread is not recommended.
For the short name usage, we may consider to create a directory-junction from
PROGRA~1 to C:\Program Files:
With the following commands:
mklink /J "C:\PROGRA~1" "C:\Program Files"
Best regards

Michael Shao
TechNet Community Support

Read other 3 answers

In Windows XP, fully updated, I have several folders full of mp3's and want to see the bit rate and duration. I right click on a column heading and select "Bit rate". I then click on "More..." so I can get to "Duration", and I select that one too.

But all the figures in the "Duration" column appear to be in "hours" and "minutes", so I see "00:04" or "00:03", but what I want is "minutes" and "seconds".

Any thoughts as to how to change this?

A:Solved: Windows Explorer "Duration" Column - no "Seconds", just "Hours" and "Minutes"

Read other 16 answers

I have a question I hope someone can help me with.

I bought Windows 10 Pro License / Product Key cheap on Ebay.
I have verified it is a VOLUME_MAK Type Product Key.

I downloaded my ISO direct from Microsoft.

Installed and Activated ? no problems.

I am aware that MS could deactivate because re-sale of this type key is not permitted. I am not concerned with that. I am more concerned with the person I bought it from being able to gain access to my machine. So here is my question.

Question: Can the person who sold me this VOLUME_MAK Type Product Key use it somehow to gain access to my machine?

Thanks in advance for your help.

A:Can Seller Of "VOLUME_MAK Type Product Key" gain access to my system?

What you have done is software piracy. You cannot even defence yourself by telling you didn't know it's illegal, you knew very well that a volume activation key is not for resale.

Our forum rules strictly forbids all conversation about piracy. I have reported your post to administrators.

Read other 1 answers

Hi all
Previously the  "Save Picture"  box would put a web generated title in the box and automatically selected JPEG.  Now the title box reads "untitled" and the only file options offered are "png" & "bmp" 

Please note that a similar post has appeared, but the solution did not match the fault.  I'm seeking to restore the automatic response to save picture, that might have been upset by antivirus clean-up programme.

Thank youin advance for considering my problem

Read other answers

One feature I really liked in XP was the ability to look in a folder through My Computer and sort the files by extension. For example if I wanted to get all .jpg files to one side of the folder as I looked for a file, I could click View, Arrange Icons By, Type and make that happen. I don't see that feature in Windows 7. I'm using W7Pro and can't find that or a similar feature anywhere. Is it here and I just haven't found it? TIA


open a window ,click organise/layout /menubar.
then when you click view in the menu bar group by is in the list

Read other 3 answers

I am getting an "Access is Denied" error message on a hard drive that I am trying to recover files from that is from my HP Pavilion with Windows XP that fried. My hard drive is still good, and I am trying to rescue the files in the "Documents and Settings/Owner" folder. I have connected the hard drive to my laptop, which also has XP; but when I try to open the "Owner" folder in "My Documents", it tells me that "Access is Denied." And when I hover over the folder, it says "Folder is Empty." But it is not empty. I can also access everything else on the drive fine -- just not this folder. I suspect that this is a networking type of issue, but I am not sure how to resolve it. Can someone please help me?

Thank you,

A:Solved: "Access Denied", "Folder Empty"

Read other 9 answers

Hey everyone,
        I am trying to get the REST queries to work with the sharepoint end points instead of graph end points. I first created an app with relevant permissions and have given it the admin consent. Then I am hitting the https://login.microsoftonline.com/<tenant>.onmicrosoft.com/oauth2/token?Content-Type=application/x-www-form-urlencoded end
point with https://<tenant>.sharepoint.com as resource. I am then using the access token retrieved to give the rest call to https://<tenant>.sharepoint.com/_api/v2.0/drives/b!3indYSbqZ0-hVSPnCgIZy-2xDMh7jH9AuQnEzJMc6TEfQoSJvJT-R6tT0lFBQiPr/root/delta
but it is failing with "error":{"code":"generalException","message":"General exception while processing"}}. The REST response code is 401 Unauthorized. I have filed a Microsoft support ticket but they
have asked me to post on these forms. Can someone please help me with this? I am not able to move forward because the error is pretty generic and doesn't give any additional details.
Sai Kiran Katuri.

Read other answers

OK guys, im kinda new to this forum, so... hello.
My computer has a not so serious problem-When I try to open Local Disk C by double clicking it says:
Windows cannot find install.exe.
This program is needed for opening filed of type 'File'.

Type in the executable file to be used instead:

This problem isnt very serious, I just dont want my computer to remain "corrupt" if you know what I mean.

Help my and I will be grateful!

A:Cant open C:/:"Install.exe is needed for opening type of "file""

Hello and Welcome to TSF

Have you scanned your system for viruses lately? What antivirus program is installed on your system?

Read other 4 answers

Hello All,

I started a few weeks ago on the PowerShell programing and I got my answer from here only. So am putting up the error that I am getting now to get some help again.

Scenario : I wrote a script that checks a Folder on a server and counts the number of files in it.Then when it finds the resulting number to be more then a specific value(threshold) it sends up a mail to the required alias. To break it all along the portion to send a mail is generated through DBmail using another .PS1 file.

In the PS1 file containing the main checking of number of files I am trying to pass 2 parameters :

1. Folder path on the server
2. the Threshold value of number of files

Now when I created a job to run this powershell script as :

& "C:\PowerShell\Power.PS1" \\XXXX\\c$\Documents and Settings\ABC\Local Settings\Temp 10

IT fails with the error :

A job step received an error at line 1 in a PowerShell script. The corresponding line is '& "C:\PowerShell\Power.ps1" \\XXXX\\c$\Documents and Settings\ABC\Local Settings\Temp 10'. Correct the script and reschedule the job. The error information returned by PowerShell is: 'Cannot convert value "and" to type "System.Int32". Error: "Input string was not in a correct format." '. Process Exit Code -1. The step failed.

I really can not move forward on this.

Please help.

A:PowerShell issue ('Cannot convert value "and" to type "System.Int32")

Just to add for reference Below is the code for the Power.Ps1 file that I have used :


[string] $directory_string,
[int] $benchmark


[int]$directory_file_count = 0

# check that the directory exists.
$does_directory_exist = (Test-Path $directory_string)

# if it does, then continue
if ($does_directory_exist)

# Check for the number of files on the directory
$directory_file_count = (get-childitem $directory_string -name -recurse).count

# If number of files exceeds the limit, send mail to notify

if($directory_file_count -gt $benchmark)
& "C:\Powershell\DB_mail.ps1"
$subject= "XXXX"
$body= "XXXX"



& "C:\Powershell\DB_mail.ps1"
$subject= "XXXX"
$body= "XXXX "

& "C:\Powershell\DB_mail.ps1"
$subject = "XXXX"
$body = " XXXX"

Read other 5 answers

I have an Access file with multiple "queries" along with a "table" that exists on our volunteer fire company computer, with backup on my own. This is a database of all the residents in our fire district, and has to be altered from time to time as people come and go.

I just discovered that somehow the file is now "Read-only" and nothing can be changed. That is a disaster! I have found some info re eliminating the "R-O" restraint, but even though I go to Properties>General Tab>Attributes and have unchecked "R-O", the contents of the file are still not alterable.

Your assistance is badly needed and will be greatly appreciated.


A:Solved: "Read-only" problem within 'Access'

Read other 13 answers

I am receiving an error when creating a nested IIF expression in ACCESS 2010, about too many parentheses. However, when I do remove one, I get another error related to the syntax.
The following is the syntax (I believe the problem is my part, but I cannot figure it out!):

Original Component Cost: IIf([EL]=0,"",([Net Amount]/100*[EL])),
IIf([EV]=0,"",([Net Amount]/100*[EV])))

Read other answers

Not sure if this possible. I have a spreadsheet in Excel that we moved the data to Access. In the spreasheet it had a formula to calculate the Monthly growth.

I am trying to recreate this in a query in access. I have 5 fields in the query. 1)Total Customers 2) New Customers 3) Cancelled Customers.

The 4th field is the Netnew which has the expression[CustNew]-[CustCancelled]. The 5th field is the PctGrowth which needs to take the current [Netnew] and divide it by the prior months [CustTotal].

The problem I have is that if I put in [CustTotal] it uses the current and if I change it to another name it calculates it for all of the others records as well.

I am trying to have this be the control source for a field in a report. Let me know if this makes sense.

A:Access 2000 Query expression

Read other 12 answers


I have this access database that someone else created, I have now this error "mis-match in data", I know it is because my data is not in the right format in one of the files, but how do I figure out where and which one it is???

I am hoping that one of you can help me....


A:Access query - mismatch in data - but where????

It is most likely to be any joins between tables.
The other possibility is if you have any criteria in the query.

Read other 1 answers

my boss only know how to use google chrome, and he usually save websites in his own document library, and he always use "right click mouse > save as" to open his own document library directory, and sometimes he will save some pdf, but when he tries to open an pdf file through google chrome with right click > save as, he can only see file with html extension. any one can help to add "all files" in the drop-down menu next to "Save as type" in google chrome, so he can see all files types when he right click > save as through the google chrome browser.

Thks in advance

Read other answers

Hello, TSG!

Just yesterday I was using the computer normally until I got a Blue Screen. Getting a blue screen is usually something normal that occurs to my every so often, so I didn't mind it and rebooted the computer normally. However, I got two more blue screens within the next hour. The 3rd time rebooting, my computer starts to act strange as if it had a virus. Upon powering up the monitor would just display a black screen with two lines about something --- which I don't remember, sorry --- and stayed like that unless I plugged out the power cord or held on the power button to shut down. Then when after a few tries it boots and displays a message "Floppy Disk Failure" and "Drive 1 not found: Serial ATA, SATA-1" (and the same message for Drives 2 and 3) show up. Also it asks me to continue loading by pressing the F1 Key.

When Windows loads the first time, it displays a message saying a bunch of hardware has just been installed and ready for use. Also, my internal clock resetted itself back to Monday, November 07, 2005 (Which, if I recall, is the date when I got the computer) and my speakers do not work.

TL;DR Version
3 blue screens within a short time
Floppy disk fail
Drivers 1-3 not found: Serial ATA, SATA-1-3

Anyway, I browsed through Google but I haven't seen anyone with both problems. I disabled my Floppy Disk Drive and that message doesn't show up anymore, but the others do and my computer still isn't fixed. I ran a vir... Read more

A:Solved: "Floppy Disk Failure" and "Drive 1 not found" problem

Read other 9 answers

I tried to associate the file extension .txt to a new editor program
with the well known cmdline programs ASSOC and FTYPE.

No, assigning them through WinExplorer menu does not work.
But this is another problem which should not discussed here.

When I type now one of the following alternative commands at the CommandPrompt then Win7 returns me something like:

assoc .txt=txtfile

"Access denied"
The following error occurs: .txt"


ftype txtfile=D:\notepad++\notepad++.exe "%%1"

"Access denied"
The following error occurs: txtfile"


The command above work fine under WinXP


A:"access denied" when using "assoc" and "ftype" from cmdline?


Did you run cmd.exe with administrative previlliges?
Elevated Command Prompt

Read other 3 answers

Recently, I built a new PC. Everything was working fine, no issues whatsoever until one day I find that my internet is playing up. It started off as just being generally slow, only loading specific sites and a yellow triangle would apear over the WiFi icon and then I couldn't get any connection at all. My internet would switch from fine to having all these issues every few minutes so I decided to look into it, tried a few solutions and none of them worked. Worst of all however, is when attempting the final fix ( entering netsh int ip reset resetlog.txt) and then restarting. The PC restarted fine no issues but then there was no change in the WiFi issue. I then went into network and sharing centre and deleted my wireless network profile, tried to reconnect and was met with the message "Network Security Key Mismatch". I can't get past this screen and I am 100% sure that the security key is correct. I have tried manually creating a WiFi profile but this just causes it to attempt to connect but then it just fails.

Just having built my new PC this is very frustrating as I am unable to download any games or anything else for that matter. The fact that my internet would work periodically is what cofuses me most.

Any help is greatly appreciated, thanks.

Read other answers

Hey guys, need help with java not compiling, here is the code and errors.

/** PROGRAM ASSIGNMENT 1 DaltonBrandonP2.java
* Author: Dalton Brandon
* Class: Java, Online
* Due Date: February 8, 2012
* See if roof needs changed, calculate price per square foot
import java.util.Scanner;

public class DaltonBrandonP2 {
public static void main(String[] args) {
System.out.println("Dalton Brandon, Program Assignment 2, Java, online");
//New Scanner
Scanner input = new Scanner(System.in);

while (again == 1) {
//Year house was built
System.out.print("What year was the house built?: ");
int year = input.nextint();

//Square foot of house
System.out.print("Enter square feet of house: ");
double square = input.nextdouble();

//Total price
System.out.print("Enter total price: ");
double price = input.nextdouble();

//Does roof need changing?
void ifRoofChangeNeeded(int year){
if ((2012 - year) >= 15)
System.out.print("Roof change is needed");
System.out.print("No roof change is needed");
//Calculate price per square foot
void calcPricePersqf(double square, price){
int priceSqrf = price / square;
System.out.print("Price per square foot is: " + priceSqrf);
return priceSqrf;

System.out.print("Work on another house? 1 for YES, 2 for NO: ");
int again = input.nextint();

C:\Users\Dalton Brandon\Desktop\JAVA\Assignment 2\DaltonBrandonP2.java:32: error: illegal start of expression
v... Read more

A:Java ";" Expected and illegal start of expression

Read other 11 answers

Hey guys, I keep getting this error when I compile, and I can't seem to fix it.

This is part of my code,

public Class44 aClass44;
is highlighted in red.
public static void method205(Class44 class44, Class30_Sub2_Sub1_Sub4 aclass30_sub2_sub1_sub4[], byte byte0, Class44 class44_1)
aClass12_238 = new Class12(false, 50000);
Class30_Sub2_Sub2 class30_sub2_sub2 = new Class30_Sub2_Sub2(class44.method571("data", null), 891);

int i = -1;
int j = class30_sub2_sub2.method410();
aClass9Array210 = new Class9[20001];
if(class30_sub2_sub2.anInt1406 >= class30_sub2_sub2.aByteArray1405.length)
int k = class30_sub2_sub2.method410();
if(k == 65535)
i = class30_sub2_sub2.method410();
k = class30_sub2_sub2.method410();
Class9 class9 = aClass9Array210[k] = new Class9();
class9.anInt250 = k;
class9.anInt236 = i;
class9.anInt262 = class30_sub2_sub2.method408();
class9.anInt217 = class30_sub2_sub2.method408();
class9.anInt214 = class30_sub2_sub2.method410();
class9.anInt220 = class30_sub2_sub2.method410();
class9.anInt267 = class30_sub2_sub2.method410();
class9.aByte254 = (byte)class30_sub2_sub2.method408();
class9.anInt230 = class30_sub2_sub2.method408();
... Read more

A:Java help! "illegal start of expression" Error!

That line doesn't make any sense there. What are you trying to accomplish with it?

Read other 1 answers

I've been using DISM and ignoring Warnings, but I think the issue below is causing DISM to fail mounting of 'D:\temp\WindowsDefenderApplicationGuard.wim'.
C:\Windows\Logs\DISM\dism.log (Warning & Error lines only):

2018-11-30 15:06:40, Warning               DISM   DISM Provider Store: PID=9948 TID=11944 Failed to load the provider: c:\windows\system32\Dism\SiloedPackageProvider.dll. - CDISMProviderStore::Internal_GetProvider(hr:0x8007007e)

2018-11-30 15:06:40, Warning               DISM   DISM Provider Store: PID=9948 TID=11944 Failed to load the provider: c:\windows\system32\Dism\MetaDeployProvider.dll. - CDISMProviderStore::Internal_GetProvider(hr:0x8007007e)

2018-11-30 15:06:40, Warning               DISM   DISM WIM Provider: PID=9948 [ReadWimHeader:(1856) -> version/header mismatch] D:\temp\WindowsDefenderApplicationGuard.wim (HRESULT=0x8007000B)
- CWimManager::WimProviderMsgLogCallback
[9948] [0xc144012e]

2018-11-30 15:06:40, Error                 DISM   DISM WIM Provider: PID=9948 [WIMCreateFile:(426) -> Fail to read WIM header] D:\temp\WindowsDefenderApplicationGuard.wim
(HRESULT=0x8007000B) - CWimManager::Wim... Read more

Read other answers

So this didn't turn up in a couple of different searches. To be honest I'm hoping it's just a syntax error somewhere. When I try to compile the following Excel 2010 VBA I get a "constant expression required" on the bold pointer below (DBL_MARKER at about line 56). The quick info for that handle shows as a question mark instead of the value 0.01041666.... I really can't see the problem though, and this code was working perfectly until I added an argument to the function call about 10 minutes ago. Am I just declaring it incorrectly (i.e., did the reference change somehow between 2003 and 2010)?

Option Explicit

Public Function GetConfirmations(ByRef rngStatuses As Range, _
ByVal strStatus As String, _
ByVal dblStartTime As Double, _
ByVal intInterval As Integer) As Long

Dim rngStatus As Range
Dim rngUserId As Range
Dim rngConfTime As Range

Dim colCRs As New Collection
Dim objCr As ConfirmationRecord

Dim blnDuplicate As Boolean

Dim lngCounter As Long

Const DBL_MARKER As Double = 0.0104166666667 ' The floating-point representation of 15 minutes


For Each rngStatus In rngStatuses
With rngStatus
If Len(.Value & vbNullString) > 0 Then
If (.Value = strStatus) Then
Set rngUserId = .Offset(0, -3)
Set rngConfTime = .Offset(0, ... Read more

A:Excel VBA: "Constant expression required"

So, uh, I renamed the DBL_MARKER constant to dbl_marker, recompiled, and recapitalized it, and now it works. I'm guessing this may be a biproduct of compatibility conversion? Anyone with thoughts or prior experience?


Read other 1 answers

I double-click and get "search" instead of "open"--only when I click a disk, like Hard Drive C: or Floppy A: or CD F: and so on.

It didn't used to do this, so I must've inadvertently changed some setting somewhere, but darned if I can find it now.

Any ideas?

A:Solved: On the "my computer" list, I double-click on disks and get "search" instead of "open"

Read other 12 answers

Ok, so im new here so hey everybody..

to the point: my laptop is "stuttering"/lagging/skipping.
whatever you wanna call it its doing it.
my video/music/and cursor skip every second for a splt second it starts on start-up and dont stop til i turn my laptop off. it happens in a pattern its not random, ive done checked my drivers, spyware, and m RAM is good.. so can someone please help me? ***could it be because my battery wont hold a charger? so it has to be hooked up to the charger at ALL times or it dies Example: is the charger not got the "juice" to run the laptop by itself so it studders/skips..*** i dont know if this has anything to do with my problem but i ran "event viewer" and found this : The following boot-start or system-start driver(s) failed to load:


OS Version: Microsoft Windows XP Home Edition, Service Pack 3, 32 bit
Processor: Genuine Intel(R) CPU T2250 @ 1.73GHz, x86 Family 6 Model 14 Stepping 8
Processor Count: 2
RAM: 502 Mb
Graphics Card: Mobile Intel(R) 945GM Express Chipset Family, 224 Mb
Hard Drives: C: Total - 39723 MB, Free - 23484 MB; D: Total - 12684 MB, Free - 3633 MB;
Motherboard: Dell Inc., 0FF049, , .HWPLLB1.CN1296167S5169.
Antivirus: McAfee VirusScan, Updated: Yes, On-Demand Scanner: Disable

A:Solved: Whole computer "studders"/"skips"/"lags" .. have event viewer report (PLEASE

Read other 6 answers

Hello, and first of all thanks to whoever you are for taking the time to read this.

I am currently trying to get windows networking to work with an old laptop and have come to several issues. I am running Windows XP Home SP2.

I am able to connect to my network via the wireless connection and ping other computers on the network successfully. However, I can in no fashion connect to other windows machines through explorer.

When I attempt to "View Workgroup Computers" nothing at all is displayed, not even my own computer.

When I get the ipconfig information from the console it reports my node as "Unkown". I have followed several tutorials on how to reset the node of the network connection through the registry and have followed them all, I have always executed the edits and rebooted, however no matter what entries were in the registry my issue remained the same.

When I select the network connection in explorer and view in the left hand tool bar the little snippet of info under "Details" reads Peer-to-Peer, which I assume is the node type, which I have heard can prevent windows networking from operating correctly when enabled.

None of the tutorials I have found so far have been able to help me, perhaps my problem is a little more specific?

Once again, thanks in advance for your help!


A:Solved: Network Connection has "Unknown" node type, other issues

Read other 16 answers

Need help fixing Windows 7 Home Premium can't run any programs and no internet connection. Ran sfc /scannow, chkdsk /r /f and still get the same subsystem message

Trying to avoid Repair Install, Thanks in advance.

A:[SOLVED] &quot;The subsystem needed to support the image type is not present&quot;.

This solution is for Server 2008 but should work for Windows 7 too: Message "Subsystem needed to support the image type is not present" error when installing or running applications on Windows Server 2008 R2 Core

Read other 19 answers