Getting proper data for report

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

Guest

Hello,
I am trying to run a report that contains only the data for days where
all the information is filled in. I currently have a report that I run that
gives me the daily info, even if it is not finished. I also have a query &
report that gives me all the outstanding data. These run and work fine. But
for the finished report, it can only have the data for days where all the
information for each record with that date is filled in. I tried making a
query that used the receiving query, and the outstanding query, then had the
statement <>[outstanding]![date] in the field for the receiving date. This
doesnt' seem to work though, it gives me record for almost every day's data
that i have keyed in. Can anyone give me any suggestions.

Thanks,
Mike
 
Are we supposed to understand "all the information is filled in"? Perhaps if
you provided some sample records and told us which one should be included
and which ones should be excluded someone might have a clearer picture of
specifications.
 
Here is some sample data into my database. The first set of date, for
9/7/2004, I would not want included in the report. The reason for this is
because the second line has a 0 in both the CS rec and the pcsrec fields, and
also the date finished field is blank. With the second set of data, for
9/15/2004, I would want it included in the report becuase all the fields for
this whole date is filled in.


Day Date Whse Door Carrier Vender PO Num Type Cs Weight Cs
Rec PcsRec Receiver Appt Time Arive In Out KeyRex Date Finished
Tue 9/7/2004 8051 3 JB HUNT QUAKER
OATS 35-2168 DISTRO 1200 44400 1200 9600 BOB 12:30 PM 1:00 PM 1:05 PM 3:05
PM 78368 9/7/2004
Tue 9/7/2004 8051 5 CDM TRK CDM 80-2979 DISTRO 2TRKS 20000 0 0 SHAWN
MARK 7:00 AM 7:40 AM 7:40 AM 8:05 AM 78358
Tue 9/7/2004 8051 1 WELLS KIMBERLY
CLAKD 45-3008 DISTRO 713 18197 739 10276 BOB SHAWN 7:00 AM 7:00 AM 7:00
AM 10:00 AM 78360 9/9/2004


Wed 9/15/2004 8051 2 FIRST CLASS DELUXE DIST.
35-2465 DISTRO 890 5000 890 10680 GARTH 7:00 AM 7:00 AM 7:00 AM 7:45
AM 78450 9/15/2004
Wed 9/15/2004 8051 5 CENTRAL VALUE
MERCH 80-9564 DISTRO 8PLTS 4550 182 6552 GARTH 12:30 PM 11:55AM 12:05PM 1:10
PM 78457 9/15/2004
Wed 9/15/2004 8051 1 BTT FOURSTAR 85-1770 HOLD 1CONT 11243 400 400 BOB
SHAWN 7:00 AM 2:00 PM 2:15 PM 9:10 AM 78459 9/16/2004

If anyone has any suggestions let me know.

Thanks,
Mike


Duane Hookom said:
Are we supposed to understand "all the information is filled in"? Perhaps if
you provided some sample records and told us which one should be included
and which ones should be excluded someone might have a clearer picture of
specifications.

--
Duane Hookom
MS Access MVP
--

Mike W said:
Hello,
I am trying to run a report that contains only the data for days where
all the information is filled in. I currently have a report that I run
that
gives me the daily info, even if it is not finished. I also have a query
&
report that gives me all the outstanding data. These run and work fine.
But
for the finished report, it can only have the data for days where all the
information for each record with that date is filled in. I tried making a
query that used the receiving query, and the outstanding query, then had
the
statement <>[outstanding]![date] in the field for the receiving date.
This
doesnt' seem to work though, it gives me record for almost every day's
data
that i have keyed in. Can anyone give me any suggestions.

Thanks,
Mike
Click to expand...
Click to expand...
 
Your sample data is a bit messed up. I don't know where one field name ends
and another begins. Have you considered using criteria in a query like
[CS Rec]<> 0 AND pcsrec <>0 and [Date Finished] is not null


--
Duane Hookom
MS Access MVP


Mike W said:
Here is some sample data into my database. The first set of date, for
9/7/2004, I would not want included in the report. The reason for this is
because the second line has a 0 in both the CS rec and the pcsrec fields, and
also the date finished field is blank. With the second set of data, for
9/15/2004, I would want it included in the report becuase all the fields for
this whole date is filled in.


Day Date Whse Door Carrier Vender PO Num Type Cs Weight Cs
Rec PcsRec Receiver Appt Time Arive In Out KeyRex Date Finished
Tue 9/7/2004 8051 3 JB HUNT QUAKER
OATS 35-2168 DISTRO 1200 44400 1200 9600 BOB 12:30 PM 1:00 PM 1:05 PM 3:05
PM 78368 9/7/2004
Tue 9/7/2004 8051 5 CDM TRK CDM 80-2979 DISTRO 2TRKS 20000 0 0 SHAWN
MARK 7:00 AM 7:40 AM 7:40 AM 8:05 AM 78358
Tue 9/7/2004 8051 1 WELLS KIMBERLY
CLAKD 45-3008 DISTRO 713 18197 739 10276 BOB SHAWN 7:00 AM 7:00 AM 7:00
AM 10:00 AM 78360 9/9/2004


Wed 9/15/2004 8051 2 FIRST CLASS DELUXE DIST.
35-2465 DISTRO 890 5000 890 10680 GARTH 7:00 AM 7:00 AM 7:00 AM 7:45
AM 78450 9/15/2004
Wed 9/15/2004 8051 5 CENTRAL VALUE
MERCH 80-9564 DISTRO 8PLTS 4550 182 6552 GARTH 12:30 PM 11:55AM 12:05PM 1:10
PM 78457 9/15/2004
Wed 9/15/2004 8051 1 BTT FOURSTAR 85-1770 HOLD 1CONT 11243 400 400 BOB
SHAWN 7:00 AM 2:00 PM 2:15 PM 9:10 AM 78459 9/16/2004

If anyone has any suggestions let me know.

Thanks,
Mike


Duane Hookom said:
Are we supposed to understand "all the information is filled in"? Perhaps if
you provided some sample records and told us which one should be included
and which ones should be excluded someone might have a clearer picture of
specifications.

--
Duane Hookom
MS Access MVP
--

Mike W said:
Hello,
I am trying to run a report that contains only the data for days where
all the information is filled in. I currently have a report that I run
that
gives me the daily info, even if it is not finished. I also have a query
&
report that gives me all the outstanding data. These run and work fine.
But
for the finished report, it can only have the data for days where all the
information for each record with that date is filled in. I tried making a
query that used the receiving query, and the outstanding query, then had
the
statement <>[outstanding]![date] in the field for the receiving date.
This
doesnt' seem to work though, it gives me record for almost every day's
data
that i have keyed in. Can anyone give me any suggestions.

Thanks,
Mike
Click to expand...
Click to expand...
Click to expand...
 
The data may have gotten messed up when I coppied and pasted it. I used
notepad to write up the message, and place the data in it. Using the
criteria you gave me in a query would work to exclude just that record, but
what I need to exclude is all records that would have the same date as the
one being excluded. In teh sample data, I would need to excluded the three
records for 9/7/2004, and print the records for 9/15/2004. Any suggestions
would be great.

Thanks,
Mike

Duane Hookom said:
Your sample data is a bit messed up. I don't know where one field name ends
and another begins. Have you considered using criteria in a query like
[CS Rec]<> 0 AND pcsrec <>0 and [Date Finished] is not null


--
Duane Hookom
MS Access MVP


Mike W said:
Here is some sample data into my database. The first set of date, for
9/7/2004, I would not want included in the report. The reason for this is
because the second line has a 0 in both the CS rec and the pcsrec fields, and
also the date finished field is blank. With the second set of data, for
9/15/2004, I would want it included in the report becuase all the fields for
this whole date is filled in.


Day Date Whse Door Carrier Vender PO Num Type Cs Weight Cs
Rec PcsRec Receiver Appt Time Arive In Out KeyRex Date Finished
Tue 9/7/2004 8051 3 JB HUNT QUAKER
OATS 35-2168 DISTRO 1200 44400 1200 9600 BOB 12:30 PM 1:00 PM 1:05 PM 3:05
PM 78368 9/7/2004
Tue 9/7/2004 8051 5 CDM TRK CDM 80-2979 DISTRO 2TRKS 20000 0 0 SHAWN
MARK 7:00 AM 7:40 AM 7:40 AM 8:05 AM 78358
Tue 9/7/2004 8051 1 WELLS KIMBERLY
CLAKD 45-3008 DISTRO 713 18197 739 10276 BOB SHAWN 7:00 AM 7:00 AM 7:00
AM 10:00 AM 78360 9/9/2004


Wed 9/15/2004 8051 2 FIRST CLASS DELUXE DIST.
35-2465 DISTRO 890 5000 890 10680 GARTH 7:00 AM 7:00 AM 7:00 AM 7:45
AM 78450 9/15/2004
Wed 9/15/2004 8051 5 CENTRAL VALUE
MERCH 80-9564 DISTRO 8PLTS 4550 182 6552 GARTH 12:30 PM 11:55AM 12:05PM 1:10
PM 78457 9/15/2004
Wed 9/15/2004 8051 1 BTT FOURSTAR 85-1770 HOLD 1CONT 11243 400 400 BOB
SHAWN 7:00 AM 2:00 PM 2:15 PM 9:10 AM 78459 9/16/2004

If anyone has any suggestions let me know.

Thanks,
Mike


Duane Hookom said:
Are we supposed to understand "all the information is filled in"? Perhaps if
you provided some sample records and told us which one should be included
and which ones should be excluded someone might have a clearer picture of
specifications.

--
Duane Hookom
MS Access MVP
--

Hello,
I am trying to run a report that contains only the data for days where
all the information is filled in. I currently have a report that I run
that
gives me the daily info, even if it is not finished. I also have a query
&
report that gives me all the outstanding data. These run and work fine.
But
for the finished report, it can only have the data for days where all the
information for each record with that date is filled in. I tried making a
query that used the receiving query, and the outstanding query, then had
the
statement <>[outstanding]![date] in the field for the receiving date.
This
doesnt' seem to work though, it gives me record for almost every day's
data
that i have keyed in. Can anyone give me any suggestions.

Thanks,
Mike
Click to expand...
Click to expand...
Click to expand...
 
Build a query that finds dates with incomplete data. Then add this to your
report's record source with a join that includes all records from your
previous query. Set a criteria under a field from the new query of "Is
Null".

--
Duane Hookom
MS Access MVP
--

Mike W said:
The data may have gotten messed up when I coppied and pasted it. I used
notepad to write up the message, and place the data in it. Using the
criteria you gave me in a query would work to exclude just that record,
but
what I need to exclude is all records that would have the same date as the
one being excluded. In teh sample data, I would need to excluded the
three
records for 9/7/2004, and print the records for 9/15/2004. Any
suggestions
would be great.

Thanks,
Mike

Duane Hookom said:
Your sample data is a bit messed up. I don't know where one field name
ends
and another begins. Have you considered using criteria in a query like
[CS Rec]<> 0 AND pcsrec <>0 and [Date Finished] is not null


--
Duane Hookom
MS Access MVP


Mike W said:
Here is some sample data into my database. The first set of date, for
9/7/2004, I would not want included in the report. The reason for this
is
because the second line has a 0 in both the CS rec and the pcsrec
fields, and
also the date finished field is blank. With the second set of data,
for
9/15/2004, I would want it included in the report becuase all the
fields for
this whole date is filled in.


Day Date Whse Door Carrier Vender PO Num Type Cs Weight Cs
Rec PcsRec Receiver Appt Time Arive In Out KeyRex Date Finished
Tue 9/7/2004 8051 3 JB HUNT QUAKER
OATS 35-2168 DISTRO 1200 44400 1200 9600 BOB 12:30 PM 1:00 PM 1:05 PM
3:05
PM 78368 9/7/2004
Tue 9/7/2004 8051 5 CDM TRK CDM 80-2979 DISTRO 2TRKS 20000 0 0 SHAWN
MARK 7:00 AM 7:40 AM 7:40 AM 8:05 AM 78358
Tue 9/7/2004 8051 1 WELLS KIMBERLY
CLAKD 45-3008 DISTRO 713 18197 739 10276 BOB SHAWN 7:00 AM 7:00 AM 7:00
AM 10:00 AM 78360 9/9/2004


Wed 9/15/2004 8051 2 FIRST CLASS DELUXE DIST.
35-2465 DISTRO 890 5000 890 10680 GARTH 7:00 AM 7:00 AM 7:00 AM 7:45
AM 78450 9/15/2004
Wed 9/15/2004 8051 5 CENTRAL VALUE
MERCH 80-9564 DISTRO 8PLTS 4550 182 6552 GARTH 12:30 PM 11:55AM 12:05PM 1:10
PM 78457 9/15/2004
Wed 9/15/2004 8051 1 BTT FOURSTAR 85-1770 HOLD 1CONT 11243 400 400 BOB
SHAWN 7:00 AM 2:00 PM 2:15 PM 9:10 AM 78459 9/16/2004

If anyone has any suggestions let me know.

Thanks,
Mike


:

Are we supposed to understand "all the information is filled in"? Perhaps if
you provided some sample records and told us which one should be included
and which ones should be excluded someone might have a clearer
picture of
specifications.

--
Duane Hookom
MS Access MVP
--

Hello,
I am trying to run a report that contains only the data for days where
all the information is filled in. I currently have a report that I run
that
gives me the daily info, even if it is not finished. I also have a query
&
report that gives me all the outstanding data. These run and work fine.
But
for the finished report, it can only have the data for days where
all the
information for each record with that date is filled in. I tried making a
query that used the receiving query, and the outstanding query,
then had
the
statement <>[outstanding]![date] in the field for the receiving
date.
This
doesnt' seem to work though, it gives me record for almost every
day's
data
that i have keyed in. Can anyone give me any suggestions.

Thanks,
Mike
Click to expand...
Click to expand...
Click to expand...
 
I have a query that gets all the outstanding date(the incomplete data), but
I'm not sure how to do a join. Could you please help me out here. I've
tried searching the help, but I just can't seem to get it.
Thanks,
Mike


Duane Hookom said:
Build a query that finds dates with incomplete data. Then add this to your
report's record source with a join that includes all records from your
previous query. Set a criteria under a field from the new query of "Is
Null".

--
Duane Hookom
MS Access MVP
--

Mike W said:
The data may have gotten messed up when I coppied and pasted it. I used
notepad to write up the message, and place the data in it. Using the
criteria you gave me in a query would work to exclude just that record,
but
what I need to exclude is all records that would have the same date as the
one being excluded. In teh sample data, I would need to excluded the
three
records for 9/7/2004, and print the records for 9/15/2004. Any
suggestions
would be great.

Thanks,
Mike

Duane Hookom said:
Your sample data is a bit messed up. I don't know where one field name
ends
and another begins. Have you considered using criteria in a query like
[CS Rec]<> 0 AND pcsrec <>0 and [Date Finished] is not null


--
Duane Hookom
MS Access MVP


Here is some sample data into my database. The first set of date, for
9/7/2004, I would not want included in the report. The reason for this
is
because the second line has a 0 in both the CS rec and the pcsrec
fields,
and
also the date finished field is blank. With the second set of data,
for
9/15/2004, I would want it included in the report becuase all the
fields
for
this whole date is filled in.


Day Date Whse Door Carrier Vender PO Num Type Cs Weight Cs
Rec PcsRec Receiver Appt Time Arive In Out KeyRex Date Finished
Tue 9/7/2004 8051 3 JB HUNT QUAKER
OATS 35-2168 DISTRO 1200 44400 1200 9600 BOB 12:30 PM 1:00 PM 1:05 PM
3:05
PM 78368 9/7/2004
Tue 9/7/2004 8051 5 CDM TRK CDM 80-2979 DISTRO 2TRKS 20000 0 0 SHAWN
MARK 7:00 AM 7:40 AM 7:40 AM 8:05 AM 78358
Tue 9/7/2004 8051 1 WELLS KIMBERLY
CLAKD 45-3008 DISTRO 713 18197 739 10276 BOB SHAWN 7:00 AM 7:00 AM 7:00
AM 10:00 AM 78360 9/9/2004


Wed 9/15/2004 8051 2 FIRST CLASS DELUXE DIST.
35-2465 DISTRO 890 5000 890 10680 GARTH 7:00 AM 7:00 AM 7:00 AM 7:45
AM 78450 9/15/2004
Wed 9/15/2004 8051 5 CENTRAL VALUE
MERCH 80-9564 DISTRO 8PLTS 4550 182 6552 GARTH 12:30 PM 11:55AM 12:05PM
1:10
PM 78457 9/15/2004
Wed 9/15/2004 8051 1 BTT FOURSTAR 85-1770 HOLD 1CONT 11243 400 400 BOB
SHAWN 7:00 AM 2:00 PM 2:15 PM 9:10 AM 78459 9/16/2004

If anyone has any suggestions let me know.

Thanks,
Mike


:

Are we supposed to understand "all the information is filled in"?
Perhaps if
you provided some sample records and told us which one should be
included
and which ones should be excluded someone might have a clearer
picture
of
specifications.

--
Duane Hookom
MS Access MVP
--

Hello,
I am trying to run a report that contains only the data for days
where
all the information is filled in. I currently have a report that I
run
that
gives me the daily info, even if it is not finished. I also have a
query
&
report that gives me all the outstanding data. These run and work
fine.
But
for the finished report, it can only have the data for days where
all
the
information for each record with that date is filled in. I tried
making a
query that used the receiving query, and the outstanding query,
then
had
the
statement <>[outstanding]![date] in the field for the receiving
date.
This
doesnt' seem to work though, it gives me record for almost every
day's
data
that i have keyed in. Can anyone give me any suggestions.

Thanks,
Mike
Click to expand...
Click to expand...
Click to expand...
 
You new query should have the dates in a field. Join this to your report's
record source date field. Double-click the join line and select to include
all the records from your original query/table. Then add a criteria of Is
Null under the date field from your new date field.

--
Duane Hookom
MS Access MVP


Mike W said:
I have a query that gets all the outstanding date(the incomplete data), but
I'm not sure how to do a join. Could you please help me out here. I've
tried searching the help, but I just can't seem to get it.
Thanks,
Mike


Duane Hookom said:
Build a query that finds dates with incomplete data. Then add this to your
report's record source with a join that includes all records from your
previous query. Set a criteria under a field from the new query of "Is
Null".

--
Duane Hookom
MS Access MVP
--

Mike W said:
The data may have gotten messed up when I coppied and pasted it. I used
notepad to write up the message, and place the data in it. Using the
criteria you gave me in a query would work to exclude just that record,
but
what I need to exclude is all records that would have the same date as the
one being excluded. In teh sample data, I would need to excluded the
three
records for 9/7/2004, and print the records for 9/15/2004. Any
suggestions
would be great.

Thanks,
Mike

:

Your sample data is a bit messed up. I don't know where one field name
ends
and another begins. Have you considered using criteria in a query like
[CS Rec]<> 0 AND pcsrec <>0 and [Date Finished] is not null


--
Duane Hookom
MS Access MVP


Here is some sample data into my database. The first set of date, for
9/7/2004, I would not want included in the report. The reason for this
is
because the second line has a 0 in both the CS rec and the pcsrec
fields,
and
also the date finished field is blank. With the second set of data,
for
9/15/2004, I would want it included in the report becuase all the
fields
for
this whole date is filled in.


Day Date Whse Door Carrier Vender PO Num Type Cs Weight Cs
Rec PcsRec Receiver Appt Time Arive In Out KeyRex Date Finished
Tue 9/7/2004 8051 3 JB HUNT QUAKER
OATS 35-2168 DISTRO 1200 44400 1200 9600 BOB 12:30 PM 1:00 PM 1:05 PM
3:05
PM 78368 9/7/2004
Tue 9/7/2004 8051 5 CDM TRK CDM 80-2979 DISTRO 2TRKS 20000 0 0 SHAWN
MARK 7:00 AM 7:40 AM 7:40 AM 8:05 AM 78358
Tue 9/7/2004 8051 1 WELLS KIMBERLY
CLAKD 45-3008 DISTRO 713 18197 739 10276 BOB SHAWN 7:00 AM 7:00 AM 7:00
AM 10:00 AM 78360 9/9/2004


Wed 9/15/2004 8051 2 FIRST CLASS DELUXE DIST.
35-2465 DISTRO 890 5000 890 10680 GARTH 7:00 AM 7:00 AM 7:00 AM 7:45
AM 78450 9/15/2004
Wed 9/15/2004 8051 5 CENTRAL VALUE
MERCH 80-9564 DISTRO 8PLTS 4550 182 6552 GARTH 12:30 PM 11:55AM 12:05PM
1:10
PM 78457 9/15/2004
Wed 9/15/2004 8051 1 BTT FOURSTAR 85-1770 HOLD 1CONT 11243 400 400 BOB
SHAWN 7:00 AM 2:00 PM 2:15 PM 9:10 AM 78459 9/16/2004

If anyone has any suggestions let me know.

Thanks,
Mike


:

Are we supposed to understand "all the information is filled in"?
Perhaps if
you provided some sample records and told us which one should be
included
and which ones should be excluded someone might have a clearer
picture
of
specifications.

--
Duane Hookom
MS Access MVP
--

Hello,
I am trying to run a report that contains only the data for days
where
all the information is filled in. I currently have a report that I
run
that
gives me the daily info, even if it is not finished. I also have a
query
&
report that gives me all the outstanding data. These run and work
fine.
But
for the finished report, it can only have the data for days where
all
the
information for each record with that date is filled in. I tried
making a
query that used the receiving query, and the outstanding query,
then
had
the
statement <>[outstanding]![date] in the field for the receiving
date.
This
doesnt' seem to work though, it gives me record for almost every
day's
data
that i have keyed in. Can anyone give me any suggestions.

Thanks,
Mike
Click to expand...
Click to expand...
Click to expand...
 
Thanks for all the help. I can't believe it was that easy to get the data.

Thanks again
Mike


Duane Hookom said:
You new query should have the dates in a field. Join this to your report's
record source date field. Double-click the join line and select to include
all the records from your original query/table. Then add a criteria of Is
Null under the date field from your new date field.

--
Duane Hookom
MS Access MVP


Mike W said:
I have a query that gets all the outstanding date(the incomplete data), but
I'm not sure how to do a join. Could you please help me out here. I've
tried searching the help, but I just can't seem to get it.
Thanks,
Mike


Duane Hookom said:
Build a query that finds dates with incomplete data. Then add this to your
report's record source with a join that includes all records from your
previous query. Set a criteria under a field from the new query of "Is
Null".

--
Duane Hookom
MS Access MVP
--


The data may have gotten messed up when I coppied and pasted it. I used
notepad to write up the message, and place the data in it. Using the
criteria you gave me in a query would work to exclude just that record,
but
what I need to exclude is all records that would have the same date as the
one being excluded. In teh sample data, I would need to excluded the
three
records for 9/7/2004, and print the records for 9/15/2004. Any
suggestions
would be great.

Thanks,
Mike

:

Your sample data is a bit messed up. I don't know where one field name
ends
and another begins. Have you considered using criteria in a query like
[CS Rec]<> 0 AND pcsrec <>0 and [Date Finished] is not null


--
Duane Hookom
MS Access MVP


Here is some sample data into my database. The first set of date, for
9/7/2004, I would not want included in the report. The reason for this
is
because the second line has a 0 in both the CS rec and the pcsrec
fields,
and
also the date finished field is blank. With the second set of data,
for
9/15/2004, I would want it included in the report becuase all the
fields
for
this whole date is filled in.


Day Date Whse Door Carrier Vender PO Num Type Cs Weight Cs
Rec PcsRec Receiver Appt Time Arive In Out KeyRex Date Finished
Tue 9/7/2004 8051 3 JB HUNT QUAKER
OATS 35-2168 DISTRO 1200 44400 1200 9600 BOB 12:30 PM 1:00 PM 1:05 PM
3:05
PM 78368 9/7/2004
Tue 9/7/2004 8051 5 CDM TRK CDM 80-2979 DISTRO 2TRKS 20000 0 0 SHAWN
MARK 7:00 AM 7:40 AM 7:40 AM 8:05 AM 78358
Tue 9/7/2004 8051 1 WELLS KIMBERLY
CLAKD 45-3008 DISTRO 713 18197 739 10276 BOB SHAWN 7:00 AM 7:00 AM 7:00
AM 10:00 AM 78360 9/9/2004


Wed 9/15/2004 8051 2 FIRST CLASS DELUXE DIST.
35-2465 DISTRO 890 5000 890 10680 GARTH 7:00 AM 7:00 AM 7:00 AM 7:45
AM 78450 9/15/2004
Wed 9/15/2004 8051 5 CENTRAL VALUE
MERCH 80-9564 DISTRO 8PLTS 4550 182 6552 GARTH 12:30 PM 11:55AM 12:05PM
1:10
PM 78457 9/15/2004
Wed 9/15/2004 8051 1 BTT FOURSTAR 85-1770 HOLD 1CONT 11243 400 400 BOB
SHAWN 7:00 AM 2:00 PM 2:15 PM 9:10 AM 78459 9/16/2004

If anyone has any suggestions let me know.

Thanks,
Mike


:

Are we supposed to understand "all the information is filled in"?
Perhaps if
you provided some sample records and told us which one should be
included
and which ones should be excluded someone might have a clearer
picture
of
specifications.

--
Duane Hookom
MS Access MVP
--

Hello,
I am trying to run a report that contains only the data for days
where
all the information is filled in. I currently have a report that I
run
that
gives me the daily info, even if it is not finished. I also have a
query
&
report that gives me all the outstanding data. These run and work
fine.
But
for the finished report, it can only have the data for days where
all
the
information for each record with that date is filled in. I tried
making a
query that used the receiving query, and the outstanding query,
then
had
the
statement <>[outstanding]![date] in the field for the receiving
date.
This
doesnt' seem to work though, it gives me record for almost every
day's
data
that i have keyed in. Can anyone give me any suggestions.

Thanks,
Mike
Click to expand...
Click to expand...
Click to expand...
 
Back
Top