If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
can you specifie criteria for a parameter query in an Auto Num
Try this
WHERE [2005 BuckSlips].[Number]=[Enter Number to Print:] Or WHERE [2005 BuckSlips].[Number]=cdbl([Enter Number to Print:]) Or WHERE [2005 BuckSlips].[Number] Like cdbl([Enter Number to Print:]) -- I hope that helped Good luck "Lea" wrote: SELECT [2005 BuckSlips].Number, [2005 BuckSlips].[Date Requested], [2005 BuckSlips].[Requested By], [2005 BuckSlips].Priority, [2005 BuckSlips].City, [2005 BuckSlips].County, [2005 BuckSlips].[State Route], [2005 BuckSlips].[Mile Post], [2005 BuckSlips].Location, [2005 BuckSlips].Recommendations, [2005 BuckSlips].Completed FROM [2005 BuckSlips] WHERE ((([2005 BuckSlips].Number)=[Enter Number to Print:])); "Ofer" wrote: Can you post the SQL? -- I hope that helped Good luck "Lea" wrote: I have created a parameter query, and specified criteria in an Auto Number field (which is also the primary key) and when i run the query i get no results. Why? |
#2
|
|||
|
|||
SELECT [2005 BuckSlips].Number, [2005 BuckSlips].[Date Requested], [2005
BuckSlips].[Requested By], [2005 BuckSlips].Priority, [2005 BuckSlips].City, [2005 BuckSlips].County, [2005 BuckSlips].[State Route], [2005 BuckSlips].[Mile Post], [2005 BuckSlips].Location, [2005 BuckSlips].Recommendations, [2005 BuckSlips].Completed FROM [2005 BuckSlips] WHERE ((([2005 BuckSlips].Number)=[Enter Number to Print:])); "Ofer" wrote: Can you post the SQL? -- I hope that helped Good luck "Lea" wrote: I have created a parameter query, and specified criteria in an Auto Number field (which is also the primary key) and when i run the query i get no results. Why? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
sorting more than 3 keys | Brooke | General Discussion | 3 | June 18th, 2005 04:52 AM |
Parameter Query Criteria | rwitosky | Running & Setting Up Queries | 1 | June 2nd, 2005 04:47 PM |
Help with null parameter | Mike Busch | General Discussion | 2 | March 22nd, 2005 03:13 PM |
Advanced Filter Criteria Parameter? | ethanreed | General Discussion | 1 | March 3rd, 2005 03:42 AM |
Complex query criteria - desperate appeal | Ted Allen | Running & Setting Up Queries | 5 | November 17th, 2004 07:14 PM |