Why does this query ask for the start date and end date twice?
in [Queries]
|
Prev: How do I bring a filed from multiple records and join them tog
Next: Parameter Queries in Crosstab Query
From: GWB on 14 Apr 2010 16:38 SELECT Data1.Date, Data1.Shift, Data1.Thickness, Data1.Species, Data1.Plies, Data1.ValueLeft, Data1.ValueRight FROM Data1 WHERE (((Data1.Date)>=[Start Date] And (Data1.Date)<=[Stop Date])); Thanks for any help
From: KARL DEWEY on 14 Apr 2010 16:51 Because it has this -- WHERE (((Data1.Date)>=[Start Date] And (Data1.Date)<=[Stop Date])); and the objects [Start Date] and [Stop Date] are not fields in your table Data1. -- Build a little, test a little. "GWB" wrote: > SELECT Data1.Date, Data1.Shift, Data1.Thickness, Data1.Species, Data1.Plies, > Data1.ValueLeft, Data1.ValueRight > FROM Data1 > WHERE (((Data1.Date)>=[Start Date] And (Data1.Date)<=[Stop Date])); > > > Thanks for any help
From: GWB on 14 Apr 2010 19:51 What would be a better way to do it Karl? Thanks in advance "KARL DEWEY" wrote: > Because it has this -- > WHERE (((Data1.Date)>=[Start Date] And (Data1.Date)<=[Stop Date])); > and the objects [Start Date] and [Stop Date] are not fields in your > table Data1. > > -- > Build a little, test a little. > > > "GWB" wrote: > > > SELECT Data1.Date, Data1.Shift, Data1.Thickness, Data1.Species, Data1.Plies, > > Data1.ValueLeft, Data1.ValueRight > > FROM Data1 > > WHERE (((Data1.Date)>=[Start Date] And (Data1.Date)<=[Stop Date])); > > > > > > Thanks for any help
From: John Spencer on 14 Apr 2010 20:44 Probably because you have applied a sort while in datasheet view and saved it. This sometimes causes a query to run twice when you are showing the results in datasheet view. Quickest way to fix the problem is probably to copy the SQL. Open a new query and paste the SQL into the new query's SQL view. Then Save the new query over the old query. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County GWB wrote: > SELECT Data1.Date, Data1.Shift, Data1.Thickness, Data1.Species, Data1.Plies, > Data1.ValueLeft, Data1.ValueRight > FROM Data1 > WHERE (((Data1.Date)>=[Start Date] And (Data1.Date)<=[Stop Date])); > > > Thanks for any help
From: GWB on 15 Apr 2010 09:47
Thanks John "John Spencer" wrote: > Probably because you have applied a sort while in datasheet view and saved it. > This sometimes causes a query to run twice when you are showing the results > in datasheet view. > > Quickest way to fix the problem is probably to copy the SQL. Open a new query > and paste the SQL into the new query's SQL view. Then Save the new query over > the old query. > > John Spencer > Access MVP 2002-2005, 2007-2010 > The Hilltop Institute > University of Maryland Baltimore County > > GWB wrote: > > SELECT Data1.Date, Data1.Shift, Data1.Thickness, Data1.Species, Data1.Plies, > > Data1.ValueLeft, Data1.ValueRight > > FROM Data1 > > WHERE (((Data1.Date)>=[Start Date] And (Data1.Date)<=[Stop Date])); > > > > > > Thanks for any help > . > |