Strange symbols for a column

  • Thread starter Thread starter LMB
  • Start date Start date
L

LMB

Access 2000. I made a crosstab query without a wizard for the first time (isn't that great?!). It all looks fine but there is one column where the column name is <> and there is no data in the column. Here is my sql just in case it helps you. I use the query grid to make my querys not the sql view though.

TRANSFORM Max(TBLTestsAndCerts.TestsAndCertsTypeExpDate) AS MaxOfTestsAndCertsTypeExpDate
SELECT qryNameAndSeniority.Name
FROM TBLTestsAndCertsTypes RIGHT JOIN (qryNameAndSeniority LEFT JOIN TBLTestsAndCerts ON qryNameAndSeniority.strEmployeeID = TBLTestsAndCerts.EmployeeID) ON TBLTestsAndCertsTypes.TestsAndCertsTypesID = TBLTestsAndCerts.TestsAndCertsTypeID
GROUP BY qryNameAndSeniority.strLastName, qryNameAndSeniority.Name
ORDER BY qryNameAndSeniority.strLastName
PIVOT TBLTestsAndCertsTypes.TestAndCertsType;


Anybody know what's wrong?

Thanks,
Linda
 
You apparently have some records in TBLTestsAndCertsTypes where there is no
value for TestAndCertsType. You could set a criteria under this column like
Is Not Null

--
Duane Hookom
MS Access MVP
--

Access 2000. I made a crosstab query without a wizard for the first time
(isn't that great?!). It all looks fine but there is one column where the
column name is <> and there is no data in the column. Here is my sql just
in case it helps you. I use the query grid to make my querys not the sql
view though.

TRANSFORM Max(TBLTestsAndCerts.TestsAndCertsTypeExpDate) AS
MaxOfTestsAndCertsTypeExpDate
SELECT qryNameAndSeniority.Name
FROM TBLTestsAndCertsTypes RIGHT JOIN (qryNameAndSeniority LEFT JOIN
TBLTestsAndCerts ON qryNameAndSeniority.strEmployeeID =
TBLTestsAndCerts.EmployeeID) ON TBLTestsAndCertsTypes.TestsAndCertsTypesID =
TBLTestsAndCerts.TestsAndCertsTypeID
GROUP BY qryNameAndSeniority.strLastName, qryNameAndSeniority.Name
ORDER BY qryNameAndSeniority.strLastName
PIVOT TBLTestsAndCertsTypes.TestAndCertsType;


Anybody know what's wrong?

Thanks,
Linda
 
OK. I did put some records in there but they are related to another table and I haven't entered the records into there yet. That was my practice database. On the "real" one I didn't add the records until I had recorded the data in both tables and I don't have the <> column in there.

Thanks,
Linda
You apparently have some records in TBLTestsAndCertsTypes where there is no
value for TestAndCertsType. You could set a criteria under this column like
Is Not Null

--
Duane Hookom
MS Access MVP
--

Access 2000. I made a crosstab query without a wizard for the first time
(isn't that great?!). It all looks fine but there is one column where the
column name is <> and there is no data in the column. Here is my sql just
in case it helps you. I use the query grid to make my querys not the sql
view though.

TRANSFORM Max(TBLTestsAndCerts.TestsAndCertsTypeExpDate) AS
MaxOfTestsAndCertsTypeExpDate
SELECT qryNameAndSeniority.Name
FROM TBLTestsAndCertsTypes RIGHT JOIN (qryNameAndSeniority LEFT JOIN
TBLTestsAndCerts ON qryNameAndSeniority.strEmployeeID =
TBLTestsAndCerts.EmployeeID) ON TBLTestsAndCertsTypes.TestsAndCertsTypesID =
TBLTestsAndCerts.TestsAndCertsTypeID
GROUP BY qryNameAndSeniority.strLastName, qryNameAndSeniority.Name
ORDER BY qryNameAndSeniority.strLastName
PIVOT TBLTestsAndCertsTypes.TestAndCertsType;


Anybody know what's wrong?

Thanks,
Linda
 
Does this mean your question has been answered?

--
Duane Hookom
MS Access MVP
--

OK. I did put some records in there but they are related to another table
and I haven't entered the records into there yet. That was my practice
database. On the "real" one I didn't add the records until I had recorded
the data in both tables and I don't have the <> column in there.

Thanks,
Linda
You apparently have some records in TBLTestsAndCertsTypes where there is no
value for TestAndCertsType. You could set a criteria under this column like
Is Not Null

--
Duane Hookom
MS Access MVP
--

Access 2000. I made a crosstab query without a wizard for the first time
(isn't that great?!). It all looks fine but there is one column where the
column name is <> and there is no data in the column. Here is my sql just
in case it helps you. I use the query grid to make my querys not the sql
view though.

TRANSFORM Max(TBLTestsAndCerts.TestsAndCertsTypeExpDate) AS
MaxOfTestsAndCertsTypeExpDate
SELECT qryNameAndSeniority.Name
FROM TBLTestsAndCertsTypes RIGHT JOIN (qryNameAndSeniority LEFT JOIN
TBLTestsAndCerts ON qryNameAndSeniority.strEmployeeID =
TBLTestsAndCerts.EmployeeID) ON TBLTestsAndCertsTypes.TestsAndCertsTypesID =
TBLTestsAndCerts.TestsAndCertsTypeID
GROUP BY qryNameAndSeniority.strLastName, qryNameAndSeniority.Name
ORDER BY qryNameAndSeniority.strLastName
PIVOT TBLTestsAndCertsTypes.TestAndCertsType;


Anybody know what's wrong?

Thanks,
Linda
 
Probably, at least what I can understand at this point. I'm still confused about a couple of things but can't really verbalize properly yet what they are so I'll keep working and ask when I am more clear on what and how I need to ask. Everyone has been really great in all of the groups. Your answer did help me to not make the mistake again so I thank you for that. I am assuming I shouldn't enter records into a table that is related to another to avoid this scenario. Is there a time this could happen that it would be ok to set the criteria "is not null" in that column or is it poor design that causes this?

Thanks,
Linda


Does this mean your question has been answered?

--
Duane Hookom
MS Access MVP
--

OK. I did put some records in there but they are related to another table
and I haven't entered the records into there yet. That was my practice
database. On the "real" one I didn't add the records until I had recorded
the data in both tables and I don't have the <> column in there.

Thanks,
Linda
You apparently have some records in TBLTestsAndCertsTypes where there is no
value for TestAndCertsType. You could set a criteria under this column like
Is Not Null

--
Duane Hookom
MS Access MVP
--

Access 2000. I made a crosstab query without a wizard for the first time
(isn't that great?!). It all looks fine but there is one column where the
column name is <> and there is no data in the column. Here is my sql just
in case it helps you. I use the query grid to make my querys not the sql
view though.

TRANSFORM Max(TBLTestsAndCerts.TestsAndCertsTypeExpDate) AS
MaxOfTestsAndCertsTypeExpDate
SELECT qryNameAndSeniority.Name
FROM TBLTestsAndCertsTypes RIGHT JOIN (qryNameAndSeniority LEFT JOIN
TBLTestsAndCerts ON qryNameAndSeniority.strEmployeeID =
TBLTestsAndCerts.EmployeeID) ON TBLTestsAndCertsTypes.TestsAndCertsTypesID =
TBLTestsAndCerts.TestsAndCertsTypeID
GROUP BY qryNameAndSeniority.strLastName, qryNameAndSeniority.Name
ORDER BY qryNameAndSeniority.strLastName
PIVOT TBLTestsAndCertsTypes.TestAndCertsType;


Anybody know what's wrong?

Thanks,
Linda
 
I'm not at all sure what you are asking. I think your question doesn't
relate to your "strange symbols" in MS Queries.

If you have a question about table structures and/or data integrity,
consider posting a question in the tablesdbdesign news group.

--
Duane Hookom
MS Access MVP
--

Probably, at least what I can understand at this point. I'm still confused
about a couple of things but can't really verbalize properly yet what they
are so I'll keep working and ask when I am more clear on what and how I need
to ask. Everyone has been really great in all of the groups. Your answer
did help me to not make the mistake again so I thank you for that. I am
assuming I shouldn't enter records into a table that is related to another
to avoid this scenario. Is there a time this could happen that it would be
ok to set the criteria "is not null" in that column or is it poor design
that causes this?

Thanks,
Linda


Does this mean your question has been answered?

--
Duane Hookom
MS Access MVP
--

OK. I did put some records in there but they are related to another table
and I haven't entered the records into there yet. That was my practice
database. On the "real" one I didn't add the records until I had recorded
the data in both tables and I don't have the <> column in there.

Thanks,
Linda
You apparently have some records in TBLTestsAndCertsTypes where there is no
value for TestAndCertsType. You could set a criteria under this column like
Is Not Null

--
Duane Hookom
MS Access MVP
--

Access 2000. I made a crosstab query without a wizard for the first time
(isn't that great?!). It all looks fine but there is one column where the
column name is <> and there is no data in the column. Here is my sql just
in case it helps you. I use the query grid to make my querys not the sql
view though.

TRANSFORM Max(TBLTestsAndCerts.TestsAndCertsTypeExpDate) AS
MaxOfTestsAndCertsTypeExpDate
SELECT qryNameAndSeniority.Name
FROM TBLTestsAndCertsTypes RIGHT JOIN (qryNameAndSeniority LEFT JOIN
TBLTestsAndCerts ON qryNameAndSeniority.strEmployeeID =
TBLTestsAndCerts.EmployeeID) ON TBLTestsAndCertsTypes.TestsAndCertsTypesID =
TBLTestsAndCerts.TestsAndCertsTypeID
GROUP BY qryNameAndSeniority.strLastName, qryNameAndSeniority.Name
ORDER BY qryNameAndSeniority.strLastName
PIVOT TBLTestsAndCertsTypes.TestAndCertsType;


Anybody know what's wrong?

Thanks,
Linda
 
See, I knew I was too confused to ask yet. Now I have you confused <G>
I'm not at all sure what you are asking. I think your question doesn't
relate to your "strange symbols" in MS Queries.

If you have a question about table structures and/or data integrity,
consider posting a question in the tablesdbdesign news group.
 
Back
Top