why there's no record showing?

[JoyJoy329]

I'm a self learn access user. Currently I created 2 tables. one with all the
data related to a job and the second one is the files i have for the job (all
in ole formate). before i added my new table (the second one with ole only),
everything works fine... ( all i need is to enter the job no and the
corresponding record will pull up.).. but now... nothing will come up at
all... i created a one to many relationship between my job number in both
tables.. and in the queries, i pull pretty much everything from the 2
tables.. ( my intention was to create some ole links for my form created base
on this query). but now... no records can be pull out... can anyone help?

 

[Michel Walsh]

Your join between the two tables, in the query, probably find no match.

You can remove the join, from the query. Then, the query will return much
much more records that you need. But instead of making a join, do some
experimentations by adding criteria: under a field of one of the table, at
the criteria line, add something like:

= [Second Table].[SomeFieldOfTheSecondTable]

Sure, if that condition is NEVER satisfied, no record will be returned, in
the result, but then, you should be able to investigate why (and it is
probably because of the DATA)..


Vanderghast, Access MVP

 

[JoyJoy329]

Hi, does "join between the two tables" means creating a one to many
relationship between the two tables? if so, i did removed the relationships
between the 2 tables, but still no records return... can you be more specific
about what can be the data problem?? thx alot

Your join between the two tables, in the query, probably find no match.

You can remove the join, from the query. Then, the query will return much
much more records that you need. But instead of making a join, do some
experimentations by adding criteria: under a field of one of the table, at
the criteria line, add something like:

= [Second Table].[SomeFieldOfTheSecondTable]

Sure, if that condition is NEVER satisfied, no record will be returned, in
the result, but then, you should be able to investigate why (and it is
probably because of the DATA)..


Vanderghast, Access MVP

I'm a self learn access user. Currently I created 2 tables. one with all
the
data related to a job and the second one is the files i have for the job
(all
in ole formate). before i added my new table (the second one with ole
only),
everything works fine... ( all i need is to enter the job no and the
corresponding record will pull up.).. but now... nothing will come up at
all... i created a one to many relationship between my job number in both
tables.. and in the queries, i pull pretty much everything from the 2
tables.. ( my intention was to create some ole links for my form created
base
on this query). but now... no records can be pull out... can anyone help?

 

[Michel Walsh]

No, a join is represented by a line between tables, in the upper half part
of the query design. Remove it. It has no real tie to the relationship (in
the relationship window) between the tables, neither a relationship defined
in the relationship window is necessary to be implied in a query.

A problem with data can occur if you use string (an extra space in one of
the two strings make them different even if they look alike, on display)

? "Hello" = "Hello "
0


Can also be the case if you compare floating point values: two such numbers
can differ by a digit far away to the right of the decimal point, as
example, while they can be formatted the same, for display.


Vanderghast, Access MVP

Hi, does "join between the two tables" means creating a one to many
relationship between the two tables? if so, i did removed the
relationships
between the 2 tables, but still no records return... can you be more
specific
about what can be the data problem?? thx alot

Your join between the two tables, in the query, probably find no match.

You can remove the join, from the query. Then, the query will return much
much more records that you need. But instead of making a join, do some
experimentations by adding criteria: under a field of one of the table,
at
the criteria line, add something like:

= [Second Table].[SomeFieldOfTheSecondTable]

Sure, if that condition is NEVER satisfied, no record will be returned,
in
the result, but then, you should be able to investigate why (and it is
probably because of the DATA)..


Vanderghast, Access MVP

I'm a self learn access user. Currently I created 2 tables. one with
all
the
data related to a job and the second one is the files i have for the
job
(all
in ole formate). before i added my new table (the second one with ole
only),
everything works fine... ( all i need is to enter the job no and the
corresponding record will pull up.).. but now... nothing will come up
at
all... i created a one to many relationship between my job number in
both
tables.. and in the queries, i pull pretty much everything from the 2
tables.. ( my intention was to create some ole links for my form
created
base
on this query). but now... no records can be pull out... can anyone
help?