Query help

[Guest]

Hello, I have a query that gives me specific information by a date range.
Sometimes I have no information to get for some days in the date range im
asking to bring up but there is other things im asking for besides the main
item im needing. Is there some way that it will skip or not bring up the info
for the days there there is no information for? Here is the tables in my
query:

1) Machine (the machine that product was ran on)
2) Description of DT Maintenance (what was broke on the machine)
3) DT Maintenance Reason ( a text area description of why the machine was
broke)
4) Days Date (Im asking for a date range)
5) DT Maintenance ( How much delay or downtime the machine occured)

I guess my question is if I have now information in the "Description of DT
Maintence" table for a date in the date range given then I dont want it
brought up in query that im running. How would I go about doing this? Im new
to querys so please explain...

Thanks,
Chad

 

[Al Campagna]

oxicottin,

I guess my question is if I have *now information* in the "Description of DT
Maintence" table for a date in the date range given then I dont want it
brought up in query that im running.

I think you mean "no information"...
If you don't want to see any records where [Description of DT Maintenance] is null,
then criteria that field for

[Description of DT Maintenance]
Is Not Null
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Guest]

Al, yes I ment NO information but, if there is no information for that day
and information for the other stuff for that day I still dont want anything
to come up. I want everything to be based on whether there is information for
[Description of DT Maintenance] or not. I know what null means but what and
where would would I write a formula for this?

Thanks,
Chad

oxicottin,

I guess my question is if I have *now information* in the "Description of DT
Maintence" table for a date in the date range given then I dont want it
brought up in query that im running.

I think you mean "no information"...
If you don't want to see any records where [Description of DT Maintenance] is null,
then criteria that field for

[Description of DT Maintenance]
Is Not Null
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

Hello, I have a query that gives me specific information by a date range.
Sometimes I have no information to get for some days in the date range im
asking to bring up but there is other things im asking for besides the main
item im needing. Is there some way that it will skip or not bring up the info
for the days there there is no information for? Here is the tables in my
query:

1) Machine (the machine that product was ran on)
2) Description of DT Maintenance (what was broke on the machine)
3) DT Maintenance Reason ( a text area description of why the machine was
broke)
4) Days Date (Im asking for a date range)
5) DT Maintenance ( How much delay or downtime the machine occured)

I guess my question is if I have now information in the "Description of DT
Maintence" table for a date in the date range given then I dont want it
brought up in query that im running. How would I go about doing this? Im new
to querys so please explain...

Thanks,
Chad

 

[Al Campagna]

oxicottin,

If you don't want to see any records where [Description of DT Maintenance] is null,
then **criteria that field for**

[Description of DT Maintenance]
Is Not Null

This isn't "code", it's just to illustrate the criteria of Is Not Null in your query
against the [Description of DT Maintenance] field
(in the query design grid(

Al, yes I ment NO information but, if there is no information for that day
and information for the other stuff for that day I still dont want anything
to come up. I want everything to be based on whether there is information for
[Description of DT Maintenance] or not. I know what null means but what and
where would would I write a formula for this?

Thanks,
Chad

oxicottin,

I guess my question is if I have *now information* in the "Description of DT
Maintence" table for a date in the date range given then I dont want it
brought up in query that im running.

I think you mean "no information"...
If you don't want to see any records where [Description of DT Maintenance] is null,
then criteria that field for

[Description of DT Maintenance]
Is Not Null
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

Hello, I have a query that gives me specific information by a date range.
Sometimes I have no information to get for some days in the date range im
asking to bring up but there is other things im asking for besides the main
item im needing. Is there some way that it will skip or not bring up the info
for the days there there is no information for? Here is the tables in my
query:

1) Machine (the machine that product was ran on)
2) Description of DT Maintenance (what was broke on the machine)
3) DT Maintenance Reason ( a text area description of why the machine was
broke)
4) Days Date (Im asking for a date range)
5) DT Maintenance ( How much delay or downtime the machine occured)

I guess my question is if I have now information in the "Description of DT
Maintence" table for a date in the date range given then I dont want it
brought up in query that im running. How would I go about doing this? Im new
to querys so please explain...

Thanks,
Chad

 

[Al Campagna]

oxicottin,
Is Not Null is the criteria you should use against [Description of DT Maintenance] in
your query, to prevent any record that has no entry in [Description of DT Maintenance] to
not show.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

Al, yes I ment NO information but, if there is no information for that day
and information for the other stuff for that day I still dont want anything
to come up. I want everything to be based on whether there is information for
[Description of DT Maintenance] or not. I know what null means but what and
where would would I write a formula for this?

Thanks,
Chad

oxicottin,

I guess my question is if I have *now information* in the "Description of DT
Maintence" table for a date in the date range given then I dont want it
brought up in query that im running.

I think you mean "no information"...
If you don't want to see any records where [Description of DT Maintenance] is null,
then criteria that field for

[Description of DT Maintenance]
Is Not Null
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

Hello, I have a query that gives me specific information by a date range.
Sometimes I have no information to get for some days in the date range im
asking to bring up but there is other things im asking for besides the main
item im needing. Is there some way that it will skip or not bring up the info
for the days there there is no information for? Here is the tables in my
query:

1) Machine (the machine that product was ran on)
2) Description of DT Maintenance (what was broke on the machine)
3) DT Maintenance Reason ( a text area description of why the machine was
broke)
4) Days Date (Im asking for a date range)
5) DT Maintenance ( How much delay or downtime the machine occured)

I guess my question is if I have now information in the "Description of DT
Maintence" table for a date in the date range given then I dont want it
brought up in query that im running. How would I go about doing this? Im new
to querys so please explain...

Thanks,
Chad

 

[Guest]

Al, im sorry I get it you now! You want me to enter "Is Not Null" into my
tables [Description of DT Maintenance] criteria spot. Will this prevent the
getting of information from the other tables for that date? That is what I
want because the other information or "Tables" are useless if no information
was entered...

Thanks,
Chad

 

[Al Campagna]

oxicottin,
Well, not "into my tables" as you say, but rather into the query.
If your query delivered 100 records, 22 of which had no [Description of DT Maintenance]
entry, then a criteria of Is Not Null against that field, would cause the query to deliver
78 records.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."