ON/OFF Choice of

  • Thread starter Thread starter NickH
  • Start date Start date
N

NickH

Hi
I hope this is the correct Newsgroup.

I am trying to produce a form which will display data from
a query however,I would like to be able to only display
the data record which has a column in a set state
i.e "ON".

Example;

Query Table

SessionID: Type: Status: FreqScale: Point: Freq:
0 0 OFF 0 1 12
0 1 ON 0 2 13
1 0 ON 0 3 11
1 2 OFF 0 4 12

The general idea will be to display the just the Data,
where the status is "ON", and to merge it out to a word
document.
All data were Status = "OFF" will not be shown.

Whether this is easier done in Query or Form, I am open to
suggestions, any help would be much appreciated

Regards

Nick
 
If the column 'Status' can only have the values "ON" and
"OFF", I would recommend that you consider changing it's
datatype to Yes/No. This would improve the time taken to
execute your query.

Hope This Helps
Gerald Stanley MCSD
 
Ok
Thanks I will try this out

-----Original Message-----
If the column 'Status' can only have the values "ON" and
"OFF", I would recommend that you consider changing it's
datatype to Yes/No. This would improve the time taken to
execute your query.

Hope This Helps
Gerald Stanley MCSD
.
Click to expand...
 
Hi James

Thanks for the quick response

I Should have mentioned this before but due to my lack of
Programming experience, where is the code placed, I have
tried within the Form Header "AfterUpdate", but no success.
Would this require the data type in the table to be
changed to "Yes/No", which I have tried and which does
display the different state, although in the Query Form
the same column display's -1!

Rgds


Nick
-----Original Message-----
A query:
SELECT * FROM Table
WHERE [Status] = 'ON'



--
James Goodman
MCSE MCDBA
http://www.angelfire.com/sports/f1pictures/
Hi
I hope this is the correct Newsgroup.

I am trying to produce a form which will display data from
a query however,I would like to be able to only display
the data record which has a column in a set state
i.e "ON".

Example;

Query Table

SessionID: Type: Status: FreqScale: Point: Freq:
0 0 OFF 0 1 12
0 1 ON 0 2 13
1 0 ON 0 3 11
1 2 OFF 0 4 12

The general idea will be to display the just the Data,
where the status is "ON", and to merge it out to a word
document.
All data were Status = "OFF" will not be shown.

Whether this is easier done in Query or Form, I am open to
suggestions, any help would be much appreciated

Regards

Nick
Click to expand...


.
Click to expand...
 
Hi James

Just an up-date, everything works now.


Thanks Once again

Nick
-----Original Message-----
Hi James

Thanks for the quick response

I Should have mentioned this before but due to my lack of
Programming experience, where is the code placed, I have
tried within the Form Header "AfterUpdate", but no success.
Would this require the data type in the table to be
changed to "Yes/No", which I have tried and which does
display the different state, although in the Query Form
the same column display's -1!

Rgds


Nick
-----Original Message-----
A query:
SELECT * FROM Table
WHERE [Status] = 'ON'



--
James Goodman
MCSE MCDBA
http://www.angelfire.com/sports/f1pictures/
Hi
I hope this is the correct Newsgroup.

I am trying to produce a form which will display data from
a query however,I would like to be able to only display
the data record which has a column in a set state
i.e "ON".

Example;

Query Table

SessionID: Type: Status: FreqScale: Point: Freq:
0 0 OFF 0 1 12
0 1 ON 0 2 13
1 0 ON 0 3 11
1 2 OFF 0 4 12

The general idea will be to display the just the Data,
where the status is "ON", and to merge it out to a word
document.
All data were Status = "OFF" will not be shown.

Whether this is easier done in Query or Form, I am
Click to expand...
Click to expand...
open
to


.
Click to expand...
.
Click to expand...
 
Back
Top