Query parameters pop up

[jlr]

I created a query with one parameter "between and" type, however other parameters are popping up that I did not create. What could be causing this?

 

[GinaWhipp]

Hmm, what parameters? Also, can you post the SQL of the query, that will help detect the issue.

 

[jlr]

I do not know how to look at the sql. What do I do?

 

[GinaWhipp]

Go to the query in Design View, click the button in the upper left hand corner and select *SQL View*, highlight whatever you see there copy and then paste here. When closing if it asks you to save changes, say no.

 

[jlr]

SELECT tblDATASHEET.[Job ID], tblDATASHEET.[Account #], tblDATASHEET.[Acct name], tblDATASHEET.City, tblDATASHEET.State, tblDATASHEET.[Industry Code1], tblDATASHEET.[Industry Code2], tblDATASHEET.[Industry Code3], tblDATASHEET.[Date Arrived], tblDATASHEET.[Date Departed], tblDATASHEET.[Invoice #], tblDATASHEET.Technicians, tblDATASHEET.[Tech Salary], tblDATASHEET.[Salary Allocation %], tblDATASHEET.[Tech Salary Allocation Amt], tblDATASHEET.[Total Tech Salary], tblDATASHEET.SalesPerson1, tblDATASHEET.[Commission Percent], tblDATASHEET.[Commission Amt], tblDATASHEET.[Total Job Expenses], tblDATASHEET.[Invoice Total], tblDATASHEET.[Current Expense %], tblDATASHEET.[Current # of Pieces], tblDATASHEET.[Current Piece Revenue], tblDATASHEET.[Current Piece Expense], tblDATASHEET.[Last Year Invoice Amt], tblDATASHEET.[Last Year Total Expense], tblDATASHEET.[LY Expense %], tblDATASHEET.[Last Year# of Pieces], tblDATASHEET.[LY Piece Revenue], tblDATASHEET.[LY Piece Expense], tblDATASHEET.Comment
FROM tblDATASHEET
WHERE (((tblDATASHEET.[Job ID]) Between [Type the beginning Job ID:] And [Type the ending Job ID:]));

 

[GinaWhipp]

Okay, let's make that easier to read...

SELECT tblDATASHEET.[Job ID], tblDATASHEET.[Account #], tblDATASHEET.[Acct name], tblDATASHEET.City, tblDATASHEET.State, tblDATASHEET.[Industry Code1], tblDATASHEET.[Industry Code2], tblDATASHEET.[Industry Code3], tblDATASHEET.[Date Arrived], tblDATASHEET.[Date Departed], tblDATASHEET.[Invoice #], tblDATASHEET.Technicians, tblDATASHEET.[Tech Salary], tblDATASHEET.[Salary Allocation %], tblDATASHEET.[Tech Salary Allocation Amt], tblDATASHEET.[Total Tech Salary], tblDATASHEET.SalesPerson1, tblDATASHEET.[Commission Percent], tblDATASHEET.[Commission Amt], tblDATASHEET.[Total Job Expenses], tblDATASHEET.[Invoice Total], tblDATASHEET.[Current Expense %], tblDATASHEET.[Current # of Pieces], tblDATASHEET.[Current Piece Revenue], tblDATASHEET.[Current Piece Expense], tblDATASHEET.[Last Year Invoice Amt], tblDATASHEET.[Last Year Total Expense], tblDATASHEET.[LY Expense %], tblDATASHEET.[Last Year# of Pieces], tblDATASHEET.[LY Piece Revenue], tblDATASHEET.[LY Piece Expense], tblDATASHEET.Comment
FROM tblDATASHEET
WHERE (((tblDATASHEET.[Job ID]) Between [Type the beginning Job ID:] And [Type the ending Job ID:]));

 

[GinaWhipp]

Now what does the pop-up say?

 

[jlr]

The SQL did not work quite right. but I have fixed the problem. I had several fields in my report that were not in the query!

 

[GinaWhipp]

As long as you got it figured out!