Access Options

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am building queries in design view and am having an issue. I will put the
all the feilds that I need to pull from in and change the total to 'where'
for fields I will not use often. When I save the query and reopen it does not
save any of the 'where' fields. I dont want to have to add these back every
time I need them..... Any suggestions?
 
You would need to put something in the criteria if you want the Access query
designer to retain the fields.
 
So if the particular field does not require criteria then there is nothing I
can do to save the field except change the total to something else?
 
So if the particular field does not require criteria then there is nothing I
can do to save the field except change the total to something else?
 
So if the particular field does not require criteria then there is nothing I
can do to save the field except change the total to something else?
Click to expand...

What do you want to save the field *for*? If you don't want to sum it, don't
want to group by it, don't want to use it for criteria, and don't want to
display it... what benefit is there to including it in the query?

John W. Vinson [MVP]
 
Correct. If you have a WHERE, don't have any criteria, and aren't showing the
column then the query designer helps you by removing the column since it
really wouldn't show up in the SQL statement.

SELECT fieldA, FieldB
FROM tblA
WHERE FieldC ...

This can't be saved since Access doesn't understand how the WHERE should be
stated: =, Like, ....
 
I want to save it for future use... for example I would build something where
one week I need to know what region the information is for... the next week I
need the employee ID... the following week may be something different but all
for the same set of criteria. I have a fairly standard set of pieces of
information I may gather and dont want to build a new query for each one when
the criteria will not change. It's easier to build and label all the fields
in one shot... I have a fairly extensive library I pull from.
 
Thanks, that makes sense.

Duane Hookom said:
Correct. If you have a WHERE, don't have any criteria, and aren't showing the
column then the query designer helps you by removing the column since it
really wouldn't show up in the SQL statement.

SELECT fieldA, FieldB
FROM tblA
WHERE FieldC ...

This can't be saved since Access doesn't understand how the WHERE should be
stated: =, Like, ....
Click to expand...
 
Why not create a QueryDef and use a form to alter the query as needed.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Steve said:
Why not create a QueryDef and use a form to alter the query as needed.

PC Datasheet
Click to expand...

Get lost Steve !! we don't need you here!! , but ....
==>Let's ask it the 'nice' way...
Would you please, please go away Steve ??

This is to inform 'newbees' here about PCD' Steve:
http://home.tiscali.nl/arracom/whoissteve.html (updated, mainly the 'abuse-reporting' page...)
Until now 3800+ pageloads, 2400+ first-time visitors
(these figures are real and rapidly increasing)

Why is this ???
Because Steve is the ONLY person here who continues to advertise in the groups.

It is not relevant whether he advertised in *this* particular post or not...
==> We want him to know that these groups are *not* his private hunting grounds!

For those who don't like too see all these messages:
==> Simply killfile 'StopThisAdvertising'.
Newbees will still see this warning-message.

ArnoR
 
Back
Top