A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Are If statements possilbe in Queries?



 
 
Thread Tools Display Modes
  #1  
Old May 3rd, 2010, 08:41 PM posted to microsoft.public.access.forms
Iram
external usenet poster
 
Posts: 122
Default Are If statements possilbe in Queries?

Hello,
I have a subform and in this suform I have a combobox field called
"Category". In this combobox I have a select query that pulls the Category
and TeamName. On the master form I have a floating combobox called Team. When
I choose a team in this field I would like the subform combobox to be
narrowed down a little as such if possible...

If the Team field on the master form is ACCOUNTING I would like the Category
combobox to be limitted to "Accounting" and "Other" team names.

If the Team field on the master form is ESTABLISHMENT I need the Category
combobox to be limitted to "Establishment", "Enforcement", "Legal", "Other".

If the Team field on the master form is ENFORCEMENT I need the Category
combobox to be limitted to "Establishment", "Enforcement", "Legal", "Other".


If this is not possible how else can I do this?


Thanks.
Iram/mcp

  #2  
Old May 3rd, 2010, 09:05 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Are If statements possilbe in Queries?

On Mon, 3 May 2010 12:41:58 -0700, Iram
wrote:

Hello,
I have a subform and in this suform I have a combobox field called
"Category". In this combobox I have a select query that pulls the Category
and TeamName. On the master form I have a floating combobox called Team. When
I choose a team in this field I would like the subform combobox to be
narrowed down a little as such if possible...

If the Team field on the master form is ACCOUNTING I would like the Category
combobox to be limitted to "Accounting" and "Other" team names.

If the Team field on the master form is ESTABLISHMENT I need the Category
combobox to be limitted to "Establishment", "Enforcement", "Legal", "Other".

If the Team field on the master form is ENFORCEMENT I need the Category
combobox to be limitted to "Establishment", "Enforcement", "Legal", "Other".


If this is not possible how else can I do this?


IF isn't the right tack here... you can use OR though. Base the Category combo
box on a query referencing the Team combo. You don't describe your table
structure but it would be something like

SELECT whatever FROM tablename
WHERE (Forms!MasterFormName!Team = "ACCOUNTING" AND Category IN("Accounting",
"Other")
OR
(Forms!MasterFormName!Team = "ESTABLISHMENT" AND Category IN("Establishment",
"Enforcement", "Legal", "Other")
OR
(Forms!MasterFormName!Team = "ENFORCEMENT" AND Category IN("Establishment",
"Enforcement", "Legal", "Other")
ORDER BY something useful;
--

John W. Vinson [MVP]
  #3  
Old May 3rd, 2010, 09:24 PM posted to microsoft.public.access.forms
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Are If statements possilbe in Queries?

Search on 'Cascading Combos' to find what you need.

--
Build a little, test a little.


"Iram" wrote:

Hello,
I have a subform and in this suform I have a combobox field called
"Category". In this combobox I have a select query that pulls the Category
and TeamName. On the master form I have a floating combobox called Team. When
I choose a team in this field I would like the subform combobox to be
narrowed down a little as such if possible...

If the Team field on the master form is ACCOUNTING I would like the Category
combobox to be limitted to "Accounting" and "Other" team names.

If the Team field on the master form is ESTABLISHMENT I need the Category
combobox to be limitted to "Establishment", "Enforcement", "Legal", "Other".

If the Team field on the master form is ENFORCEMENT I need the Category
combobox to be limitted to "Establishment", "Enforcement", "Legal", "Other".


If this is not possible how else can I do this?


Thanks.
Iram/mcp

  #4  
Old May 3rd, 2010, 11:03 PM posted to microsoft.public.access.forms
Dorian
external usenet poster
 
Posts: 542
Default Are If statements possilbe in Queries?

see reply in other post
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"Iram" wrote:

Hello,
I have a subform and in this suform I have a combobox field called
"Category". In this combobox I have a select query that pulls the Category
and TeamName. On the master form I have a floating combobox called Team. When
I choose a team in this field I would like the subform combobox to be
narrowed down a little as such if possible...

If the Team field on the master form is ACCOUNTING I would like the Category
combobox to be limitted to "Accounting" and "Other" team names.

If the Team field on the master form is ESTABLISHMENT I need the Category
combobox to be limitted to "Establishment", "Enforcement", "Legal", "Other".

If the Team field on the master form is ENFORCEMENT I need the Category
combobox to be limitted to "Establishment", "Enforcement", "Legal", "Other".


If this is not possible how else can I do this?


Thanks.
Iram/mcp

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:45 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.