query does not use data from appended table

R

Rana

Hi,

I'm having a problem with my query. I've created a query that displayed all
'Volunteers information' which ran fine. However I then imported data from
Excel into a new table 'sheet1' and appended it to table 'Primary_info' that
I used in the query. The way I did this was by right-clicking 'sheet1' and
clicking on copy, then right-clicking and pasting into the database window
which then asked me if i want to copy it ' into a new table', 'bla bla' or
'append data into existing table', which I did. Now the table "Primary_info'
has been updated fine but when I try to run the query it only displays the
records that were there before I "appended" the data. I don't understand why,
I thought that once you update info. in a table everything else gets updated
with it when you re-run/requery/refresh.

I know that the data has been updated fine because when I created a new
query to filter similar fields I got all the records up. How do I get the
first query to pull up all the info.? What do I do?! Please help!

Thank you! any help or ideas are GREATLY appreciated.

Rana
 
S

stumac

Hi Rana, what is your query doing?

is it filtering out records, if so do the new records meet the criteria?
Does it have a join that is perhaps causing the records to be left out as
they don't have corresponding data in another table?

can you post the SQL for your query, this might help give us a better idea

In query design goto, view and select SQL.

Stu
 
R

Rana

Hey Stu,

Thanx for ur quick response. My query is just collecting all the data from
different tables into one. All the tables used are linked using the field
ROTAID and all the tables that are being called up have corresponding
'ROTAID' values however not all the fields are filled out. Here is the SQL
for the query.

*******************************************************
SELECT Personal_info_Primary.ROTAID, Personal_info_Primary.Title,
Personal_info_Primary.First_name, Personal_info_Primary.Last_name,
DateDiff("yyyy",[Birthdate],Now())+Int(Format(Now(),"mmdd")<Format([Birthdate],"mmdd"))
AS Age, Personal_info_Primary.Gender, Personal_info_Secondary.[Type of ROTA
Volunteer], Contact_details.Email, Contact_details.[Mobile no],
Decleration.[Photo release consent], Decleration.[Date joined]
FROM ((Personal_info_Primary INNER JOIN Contact_details ON
Personal_info_Primary.ROTAID = Contact_details.ROTAID) INNER JOIN Decleration
ON Personal_info_Primary.ROTAID = Decleration.ROTAID) INNER JOIN
Personal_info_Secondary ON Personal_info_Primary.ROTAID =
Personal_info_Secondary.ROTAID
ORDER BY Personal_info_Primary.ROTAID;

********************************************************
I even tried an older version of my database and added a record to the table
directly and tried to run a query and still nothing.

I'm ssooo confused.

Thanx again for ur help.

Rana

---------------------------------------------------------------------------------------------------
 
S

stumac

Rana, are you sure that the "ROTAID" for the records you have added into
"Personal_info_Primary" also have corresponding records in both
"Personal_info_Secondary" and "Personal_info_Secondary" ?

If they do not they willnot appear in the query results as it is only
showing records that appear in the 3 tables.

Stu



Rana said:
Hey Stu,

Thanx for ur quick response. My query is just collecting all the data from
different tables into one. All the tables used are linked using the field
ROTAID and all the tables that are being called up have corresponding
'ROTAID' values however not all the fields are filled out. Here is the SQL
for the query.

*******************************************************
SELECT Personal_info_Primary.ROTAID, Personal_info_Primary.Title,
Personal_info_Primary.First_name, Personal_info_Primary.Last_name,
DateDiff("yyyy",[Birthdate],Now())+Int(Format(Now(),"mmdd")<Format([Birthdate],"mmdd"))
AS Age, Personal_info_Primary.Gender, Personal_info_Secondary.[Type of ROTA
Volunteer], Contact_details.Email, Contact_details.[Mobile no],
Decleration.[Photo release consent], Decleration.[Date joined]
FROM ((Personal_info_Primary INNER JOIN Contact_details ON
Personal_info_Primary.ROTAID = Contact_details.ROTAID) INNER JOIN Decleration
ON Personal_info_Primary.ROTAID = Decleration.ROTAID) INNER JOIN
Personal_info_Secondary ON Personal_info_Primary.ROTAID =
Personal_info_Secondary.ROTAID
ORDER BY Personal_info_Primary.ROTAID;

********************************************************
I even tried an older version of my database and added a record to the table
directly and tried to run a query and still nothing.

I'm ssooo confused.

Thanx again for ur help.

Rana

---------------------------------------------------------------------------------------------------
stumac said:
Hi Rana, what is your query doing?

is it filtering out records, if so do the new records meet the criteria?
Does it have a join that is perhaps causing the records to be left out as
they don't have corresponding data in another table?

can you post the SQL for your query, this might help give us a better idea

In query design goto, view and select SQL.

Stu
Click to expand...
Click to expand...
 
S

stumac

Sorry should of said :
are you sure that the "ROTAID" for the records you have added into
"Personal_info_Primary" also have corresponding records in both
"Personal_info_Secondary" , "Decleration" and "Contact_details" tables.

stumac said:
Rana, are you sure that the "ROTAID" for the records you have added into
"Personal_info_Primary" also have corresponding records in both
"Personal_info_Secondary" and "Personal_info_Secondary" ?

If they do not they willnot appear in the query results as it is only
showing records that appear in the 3 tables.

Stu



Rana said:
Hey Stu,

Thanx for ur quick response. My query is just collecting all the data from
different tables into one. All the tables used are linked using the field
ROTAID and all the tables that are being called up have corresponding
'ROTAID' values however not all the fields are filled out. Here is the SQL
for the query.

*******************************************************
SELECT Personal_info_Primary.ROTAID, Personal_info_Primary.Title,
Personal_info_Primary.First_name, Personal_info_Primary.Last_name,
DateDiff("yyyy",[Birthdate],Now())+Int(Format(Now(),"mmdd")<Format([Birthdate],"mmdd"))
AS Age, Personal_info_Primary.Gender, Personal_info_Secondary.[Type of ROTA
Volunteer], Contact_details.Email, Contact_details.[Mobile no],
Decleration.[Photo release consent], Decleration.[Date joined]
FROM ((Personal_info_Primary INNER JOIN Contact_details ON
Personal_info_Primary.ROTAID = Contact_details.ROTAID) INNER JOIN Decleration
ON Personal_info_Primary.ROTAID = Decleration.ROTAID) INNER JOIN
Personal_info_Secondary ON Personal_info_Primary.ROTAID =
Personal_info_Secondary.ROTAID
ORDER BY Personal_info_Primary.ROTAID;

********************************************************
I even tried an older version of my database and added a record to the table
directly and tried to run a query and still nothing.

I'm ssooo confused.

Thanx again for ur help.

Rana

---------------------------------------------------------------------------------------------------
stumac said:
Hi Rana, what is your query doing?

is it filtering out records, if so do the new records meet the criteria?
Does it have a join that is perhaps causing the records to be left out as
they don't have corresponding data in another table?

can you post the SQL for your query, this might help give us a better idea

In query design goto, view and select SQL.

Stu

:

Hi,

I'm having a problem with my query. I've created a query that displayed all
'Volunteers information' which ran fine. However I then imported data from
Excel into a new table 'sheet1' and appended it to table 'Primary_info' that
I used in the query. The way I did this was by right-clicking 'sheet1' and
clicking on copy, then right-clicking and pasting into the database window
which then asked me if i want to copy it ' into a new table', 'bla bla' or
'append data into existing table', which I did. Now the table "Primary_info'
has been updated fine but when I try to run the query it only displays the
records that were there before I "appended" the data. I don't understand why,
I thought that once you update info. in a table everything else gets updated
with it when you re-run/requery/refresh.

I know that the data has been updated fine because when I created a new
query to filter similar fields I got all the records up. How do I get the
first query to pull up all the info.? What do I do?! Please help!

Thank you! any help or ideas are GREATLY appreciated.

Rana
Click to expand...
Click to expand...
Click to expand...
 
R

Rana

I am positive. I've just rechecked.


stumac said:
Sorry should of said :
are you sure that the "ROTAID" for the records you have added into
"Personal_info_Primary" also have corresponding records in both
"Personal_info_Secondary" , "Decleration" and "Contact_details" tables.

stumac said:
Rana, are you sure that the "ROTAID" for the records you have added into
"Personal_info_Primary" also have corresponding records in both
"Personal_info_Secondary" and "Personal_info_Secondary" ?

If they do not they willnot appear in the query results as it is only
showing records that appear in the 3 tables.

Stu



Rana said:
Hey Stu,

Thanx for ur quick response. My query is just collecting all the data from
different tables into one. All the tables used are linked using the field
ROTAID and all the tables that are being called up have corresponding
'ROTAID' values however not all the fields are filled out. Here is the SQL
for the query.

*******************************************************
SELECT Personal_info_Primary.ROTAID, Personal_info_Primary.Title,
Personal_info_Primary.First_name, Personal_info_Primary.Last_name,
DateDiff("yyyy",[Birthdate],Now())+Int(Format(Now(),"mmdd")<Format([Birthdate],"mmdd"))
AS Age, Personal_info_Primary.Gender, Personal_info_Secondary.[Type of ROTA
Volunteer], Contact_details.Email, Contact_details.[Mobile no],
Decleration.[Photo release consent], Decleration.[Date joined]
FROM ((Personal_info_Primary INNER JOIN Contact_details ON
Personal_info_Primary.ROTAID = Contact_details.ROTAID) INNER JOIN Decleration
ON Personal_info_Primary.ROTAID = Decleration.ROTAID) INNER JOIN
Personal_info_Secondary ON Personal_info_Primary.ROTAID =
Personal_info_Secondary.ROTAID
ORDER BY Personal_info_Primary.ROTAID;

********************************************************
I even tried an older version of my database and added a record to the table
directly and tried to run a query and still nothing.

I'm ssooo confused.

Thanx again for ur help.

Rana

---------------------------------------------------------------------------------------------------
:

Hi Rana, what is your query doing?

is it filtering out records, if so do the new records meet the criteria?
Does it have a join that is perhaps causing the records to be left out as
they don't have corresponding data in another table?

can you post the SQL for your query, this might help give us a better idea

In query design goto, view and select SQL.

Stu

:

Hi,

I'm having a problem with my query. I've created a query that displayed all
'Volunteers information' which ran fine. However I then imported data from
Excel into a new table 'sheet1' and appended it to table 'Primary_info' that
I used in the query. The way I did this was by right-clicking 'sheet1' and
clicking on copy, then right-clicking and pasting into the database window
which then asked me if i want to copy it ' into a new table', 'bla bla' or
'append data into existing table', which I did. Now the table "Primary_info'
has been updated fine but when I try to run the query it only displays the
records that were there before I "appended" the data. I don't understand why,
I thought that once you update info. in a table everything else gets updated
with it when you re-run/requery/refresh.

I know that the data has been updated fine because when I created a new
query to filter similar fields I got all the records up. How do I get the
first query to pull up all the info.? What do I do?! Please help!

Thank you! any help or ideas are GREATLY appreciated.

Rana
Click to expand...
Click to expand...
Click to expand...
 
S

stumac

can you try a new query with the following:

*****************************************************
SELECT Personal_info_Primary.ROTAID, Personal_info_Primary.Title,
Personal_info_Primary.First_name, Personal_info_Primary.Last_name,
DateDiff("yyyy",[Birthdate],Now())+Int(Format(Now(),"mmdd")<Format([Birthdate],"mmdd"))
AS Age, Personal_info_Primary.Gender, Personal_info_Secondary.[Type of ROTA
Volunteer], Contact_details.Email, Contact_details.[Mobile no],
Decleration.[Photo release consent], Decleration.[Date joined]
FROM ((Personal_info_Primary LEFT JOIN Contact_details ON
Personal_info_Primary.ROTAID = Contact_details.ROTAID) LEFT JOIN Decleration
ON Personal_info_Primary.ROTAID = Decleration.ROTAID) LEFT JOIN
Personal_info_Secondary ON Personal_info_Primary.ROTAID =
Personal_info_Secondary.ROTAID
ORDER BY Personal_info_Primary.ROTAID;

***********************************************

Does this give you what you were expecting?
Rana said:
I am positive. I've just rechecked.


stumac said:
Sorry should of said :
are you sure that the "ROTAID" for the records you have added into
"Personal_info_Primary" also have corresponding records in both
"Personal_info_Secondary" , "Decleration" and "Contact_details" tables.

stumac said:
Rana, are you sure that the "ROTAID" for the records you have added into
"Personal_info_Primary" also have corresponding records in both
"Personal_info_Secondary" and "Personal_info_Secondary" ?

If they do not they willnot appear in the query results as it is only
showing records that appear in the 3 tables.

Stu



:

Hey Stu,

Thanx for ur quick response. My query is just collecting all the data from
different tables into one. All the tables used are linked using the field
ROTAID and all the tables that are being called up have corresponding
'ROTAID' values however not all the fields are filled out. Here is the SQL
for the query.

*******************************************************
SELECT Personal_info_Primary.ROTAID, Personal_info_Primary.Title,
Personal_info_Primary.First_name, Personal_info_Primary.Last_name,
DateDiff("yyyy",[Birthdate],Now())+Int(Format(Now(),"mmdd")<Format([Birthdate],"mmdd"))
AS Age, Personal_info_Primary.Gender, Personal_info_Secondary.[Type of ROTA
Volunteer], Contact_details.Email, Contact_details.[Mobile no],
Decleration.[Photo release consent], Decleration.[Date joined]
FROM ((Personal_info_Primary INNER JOIN Contact_details ON
Personal_info_Primary.ROTAID = Contact_details.ROTAID) INNER JOIN Decleration
ON Personal_info_Primary.ROTAID = Decleration.ROTAID) INNER JOIN
Personal_info_Secondary ON Personal_info_Primary.ROTAID =
Personal_info_Secondary.ROTAID
ORDER BY Personal_info_Primary.ROTAID;

********************************************************
I even tried an older version of my database and added a record to the table
directly and tried to run a query and still nothing.

I'm ssooo confused.

Thanx again for ur help.

Rana

---------------------------------------------------------------------------------------------------
:

Hi Rana, what is your query doing?

is it filtering out records, if so do the new records meet the criteria?
Does it have a join that is perhaps causing the records to be left out as
they don't have corresponding data in another table?

can you post the SQL for your query, this might help give us a better idea

In query design goto, view and select SQL.

Stu

:

Hi,

I'm having a problem with my query. I've created a query that displayed all
'Volunteers information' which ran fine. However I then imported data from
Excel into a new table 'sheet1' and appended it to table 'Primary_info' that
I used in the query. The way I did this was by right-clicking 'sheet1' and
clicking on copy, then right-clicking and pasting into the database window
which then asked me if i want to copy it ' into a new table', 'bla bla' or
'append data into existing table', which I did. Now the table "Primary_info'
has been updated fine but when I try to run the query it only displays the
records that were there before I "appended" the data. I don't understand why,
I thought that once you update info. in a table everything else gets updated
with it when you re-run/requery/refresh.

I know that the data has been updated fine because when I created a new
query to filter similar fields I got all the records up. How do I get the
first query to pull up all the info.? What do I do?! Please help!

Thank you! any help or ideas are GREATLY appreciated.

Rana
Click to expand...
Click to expand...
Click to expand...
 
R

Rana

YES IT DOES!!! Thanx a million! Do I just have to change inner join to left
join? and whats the difference anyways?

Rana

stumac said:
can you try a new query with the following:

*****************************************************
SELECT Personal_info_Primary.ROTAID, Personal_info_Primary.Title,
Personal_info_Primary.First_name, Personal_info_Primary.Last_name,
DateDiff("yyyy",[Birthdate],Now())+Int(Format(Now(),"mmdd")<Format([Birthdate],"mmdd"))
AS Age, Personal_info_Primary.Gender, Personal_info_Secondary.[Type of ROTA
Volunteer], Contact_details.Email, Contact_details.[Mobile no],
Decleration.[Photo release consent], Decleration.[Date joined]
FROM ((Personal_info_Primary LEFT JOIN Contact_details ON
Personal_info_Primary.ROTAID = Contact_details.ROTAID) LEFT JOIN Decleration
ON Personal_info_Primary.ROTAID = Decleration.ROTAID) LEFT JOIN
Personal_info_Secondary ON Personal_info_Primary.ROTAID =
Personal_info_Secondary.ROTAID
ORDER BY Personal_info_Primary.ROTAID;

***********************************************

Does this give you what you were expecting?
Rana said:
I am positive. I've just rechecked.


stumac said:
Sorry should of said :
are you sure that the "ROTAID" for the records you have added into
"Personal_info_Primary" also have corresponding records in both
"Personal_info_Secondary" , "Decleration" and "Contact_details" tables.

:

Rana, are you sure that the "ROTAID" for the records you have added into
"Personal_info_Primary" also have corresponding records in both
"Personal_info_Secondary" and "Personal_info_Secondary" ?

If they do not they willnot appear in the query results as it is only
showing records that appear in the 3 tables.

Stu



:

Hey Stu,

Thanx for ur quick response. My query is just collecting all the data from
different tables into one. All the tables used are linked using the field
ROTAID and all the tables that are being called up have corresponding
'ROTAID' values however not all the fields are filled out. Here is the SQL
for the query.

*******************************************************
SELECT Personal_info_Primary.ROTAID, Personal_info_Primary.Title,
Personal_info_Primary.First_name, Personal_info_Primary.Last_name,
DateDiff("yyyy",[Birthdate],Now())+Int(Format(Now(),"mmdd")<Format([Birthdate],"mmdd"))
AS Age, Personal_info_Primary.Gender, Personal_info_Secondary.[Type of ROTA
Volunteer], Contact_details.Email, Contact_details.[Mobile no],
Decleration.[Photo release consent], Decleration.[Date joined]
FROM ((Personal_info_Primary INNER JOIN Contact_details ON
Personal_info_Primary.ROTAID = Contact_details.ROTAID) INNER JOIN Decleration
ON Personal_info_Primary.ROTAID = Decleration.ROTAID) INNER JOIN
Personal_info_Secondary ON Personal_info_Primary.ROTAID =
Personal_info_Secondary.ROTAID
ORDER BY Personal_info_Primary.ROTAID;

********************************************************
I even tried an older version of my database and added a record to the table
directly and tried to run a query and still nothing.

I'm ssooo confused.

Thanx again for ur help.

Rana

---------------------------------------------------------------------------------------------------
:

Hi Rana, what is your query doing?

is it filtering out records, if so do the new records meet the criteria?
Does it have a join that is perhaps causing the records to be left out as
they don't have corresponding data in another table?

can you post the SQL for your query, this might help give us a better idea

In query design goto, view and select SQL.

Stu

:

Hi,

I'm having a problem with my query. I've created a query that displayed all
'Volunteers information' which ran fine. However I then imported data from
Excel into a new table 'sheet1' and appended it to table 'Primary_info' that
I used in the query. The way I did this was by right-clicking 'sheet1' and
clicking on copy, then right-clicking and pasting into the database window
which then asked me if i want to copy it ' into a new table', 'bla bla' or
'append data into existing table', which I did. Now the table "Primary_info'
has been updated fine but when I try to run the query it only displays the
records that were there before I "appended" the data. I don't understand why,
I thought that once you update info. in a table everything else gets updated
with it when you re-run/requery/refresh.

I know that the data has been updated fine because when I created a new
query to filter similar fields I got all the records up. How do I get the
first query to pull up all the info.? What do I do?! Please help!

Thank you! any help or ideas are GREATLY appreciated.

Rana
Click to expand...
Click to expand...
Click to expand...
 
S

stumac

Rana, yes all I have done is change the joins to left join, which will give
you all records from the primary table and any corresponding data from the
joined tables.

If there are definatley corresponding records in *ALL* of the joined tables
for the appended records, they should of been returned with the inner joins.

I would check that the ROTAID's are the same in the tables (if there is a
space before or after it in the field it wont match).

Stu



Rana said:
YES IT DOES!!! Thanx a million! Do I just have to change inner join to left
join? and whats the difference anyways?

Rana

stumac said:
can you try a new query with the following:

*****************************************************
SELECT Personal_info_Primary.ROTAID, Personal_info_Primary.Title,
Personal_info_Primary.First_name, Personal_info_Primary.Last_name,
DateDiff("yyyy",[Birthdate],Now())+Int(Format(Now(),"mmdd")<Format([Birthdate],"mmdd"))
AS Age, Personal_info_Primary.Gender, Personal_info_Secondary.[Type of ROTA
Volunteer], Contact_details.Email, Contact_details.[Mobile no],
Decleration.[Photo release consent], Decleration.[Date joined]
FROM ((Personal_info_Primary LEFT JOIN Contact_details ON
Personal_info_Primary.ROTAID = Contact_details.ROTAID) LEFT JOIN Decleration
ON Personal_info_Primary.ROTAID = Decleration.ROTAID) LEFT JOIN
Personal_info_Secondary ON Personal_info_Primary.ROTAID =
Personal_info_Secondary.ROTAID
ORDER BY Personal_info_Primary.ROTAID;

***********************************************

Does this give you what you were expecting?
Rana said:
I am positive. I've just rechecked.


:

Sorry should of said :
are you sure that the "ROTAID" for the records you have added into
"Personal_info_Primary" also have corresponding records in both
"Personal_info_Secondary" , "Decleration" and "Contact_details" tables.

:

Rana, are you sure that the "ROTAID" for the records you have added into
"Personal_info_Primary" also have corresponding records in both
"Personal_info_Secondary" and "Personal_info_Secondary" ?

If they do not they willnot appear in the query results as it is only
showing records that appear in the 3 tables.

Stu



:

Hey Stu,

Thanx for ur quick response. My query is just collecting all the data from
different tables into one. All the tables used are linked using the field
ROTAID and all the tables that are being called up have corresponding
'ROTAID' values however not all the fields are filled out. Here is the SQL
for the query.

*******************************************************
SELECT Personal_info_Primary.ROTAID, Personal_info_Primary.Title,
Personal_info_Primary.First_name, Personal_info_Primary.Last_name,
DateDiff("yyyy",[Birthdate],Now())+Int(Format(Now(),"mmdd")<Format([Birthdate],"mmdd"))
AS Age, Personal_info_Primary.Gender, Personal_info_Secondary.[Type of ROTA
Volunteer], Contact_details.Email, Contact_details.[Mobile no],
Decleration.[Photo release consent], Decleration.[Date joined]
FROM ((Personal_info_Primary INNER JOIN Contact_details ON
Personal_info_Primary.ROTAID = Contact_details.ROTAID) INNER JOIN Decleration
ON Personal_info_Primary.ROTAID = Decleration.ROTAID) INNER JOIN
Personal_info_Secondary ON Personal_info_Primary.ROTAID =
Personal_info_Secondary.ROTAID
ORDER BY Personal_info_Primary.ROTAID;

********************************************************
I even tried an older version of my database and added a record to the table
directly and tried to run a query and still nothing.

I'm ssooo confused.

Thanx again for ur help.

Rana

---------------------------------------------------------------------------------------------------
:

Hi Rana, what is your query doing?

is it filtering out records, if so do the new records meet the criteria?
Does it have a join that is perhaps causing the records to be left out as
they don't have corresponding data in another table?

can you post the SQL for your query, this might help give us a better idea

In query design goto, view and select SQL.

Stu

:

Hi,

I'm having a problem with my query. I've created a query that displayed all
'Volunteers information' which ran fine. However I then imported data from
Excel into a new table 'sheet1' and appended it to table 'Primary_info' that
I used in the query. The way I did this was by right-clicking 'sheet1' and
clicking on copy, then right-clicking and pasting into the database window
which then asked me if i want to copy it ' into a new table', 'bla bla' or
'append data into existing table', which I did. Now the table "Primary_info'
has been updated fine but when I try to run the query it only displays the
records that were there before I "appended" the data. I don't understand why,
I thought that once you update info. in a table everything else gets updated
with it when you re-run/requery/refresh.

I know that the data has been updated fine because when I created a new
query to filter similar fields I got all the records up. How do I get the
first query to pull up all the info.? What do I do?! Please help!

Thank you! any help or ideas are GREATLY appreciated.

Rana
Click to expand...
Click to expand...
Click to expand...
 
R

Rana

Thanx again stu...ill recheck the ROTAID's. uve been a great help.

Rana

stumac said:
Rana, yes all I have done is change the joins to left join, which will give
you all records from the primary table and any corresponding data from the
joined tables.

If there are definatley corresponding records in *ALL* of the joined tables
for the appended records, they should of been returned with the inner joins.

I would check that the ROTAID's are the same in the tables (if there is a
space before or after it in the field it wont match).

Stu



Rana said:
YES IT DOES!!! Thanx a million! Do I just have to change inner join to left
join? and whats the difference anyways?

Rana

stumac said:
can you try a new query with the following:

*****************************************************
SELECT Personal_info_Primary.ROTAID, Personal_info_Primary.Title,
Personal_info_Primary.First_name, Personal_info_Primary.Last_name,
DateDiff("yyyy",[Birthdate],Now())+Int(Format(Now(),"mmdd")<Format([Birthdate],"mmdd"))
AS Age, Personal_info_Primary.Gender, Personal_info_Secondary.[Type of ROTA
Volunteer], Contact_details.Email, Contact_details.[Mobile no],
Decleration.[Photo release consent], Decleration.[Date joined]
FROM ((Personal_info_Primary LEFT JOIN Contact_details ON
Personal_info_Primary.ROTAID = Contact_details.ROTAID) LEFT JOIN Decleration
ON Personal_info_Primary.ROTAID = Decleration.ROTAID) LEFT JOIN
Personal_info_Secondary ON Personal_info_Primary.ROTAID =
Personal_info_Secondary.ROTAID
ORDER BY Personal_info_Primary.ROTAID;

***********************************************

Does this give you what you were expecting?
:

I am positive. I've just rechecked.


:

Sorry should of said :
are you sure that the "ROTAID" for the records you have added into
"Personal_info_Primary" also have corresponding records in both
"Personal_info_Secondary" , "Decleration" and "Contact_details" tables.

:

Rana, are you sure that the "ROTAID" for the records you have added into
"Personal_info_Primary" also have corresponding records in both
"Personal_info_Secondary" and "Personal_info_Secondary" ?

If they do not they willnot appear in the query results as it is only
showing records that appear in the 3 tables.

Stu



:

Hey Stu,

Thanx for ur quick response. My query is just collecting all the data from
different tables into one. All the tables used are linked using the field
ROTAID and all the tables that are being called up have corresponding
'ROTAID' values however not all the fields are filled out. Here is the SQL
for the query.

*******************************************************
SELECT Personal_info_Primary.ROTAID, Personal_info_Primary.Title,
Personal_info_Primary.First_name, Personal_info_Primary.Last_name,
DateDiff("yyyy",[Birthdate],Now())+Int(Format(Now(),"mmdd")<Format([Birthdate],"mmdd"))
AS Age, Personal_info_Primary.Gender, Personal_info_Secondary.[Type of ROTA
Volunteer], Contact_details.Email, Contact_details.[Mobile no],
Decleration.[Photo release consent], Decleration.[Date joined]
FROM ((Personal_info_Primary INNER JOIN Contact_details ON
Personal_info_Primary.ROTAID = Contact_details.ROTAID) INNER JOIN Decleration
ON Personal_info_Primary.ROTAID = Decleration.ROTAID) INNER JOIN
Personal_info_Secondary ON Personal_info_Primary.ROTAID =
Personal_info_Secondary.ROTAID
ORDER BY Personal_info_Primary.ROTAID;

********************************************************
I even tried an older version of my database and added a record to the table
directly and tried to run a query and still nothing.

I'm ssooo confused.

Thanx again for ur help.

Rana

---------------------------------------------------------------------------------------------------
:

Hi Rana, what is your query doing?

is it filtering out records, if so do the new records meet the criteria?
Does it have a join that is perhaps causing the records to be left out as
they don't have corresponding data in another table?

can you post the SQL for your query, this might help give us a better idea

In query design goto, view and select SQL.

Stu

:

Hi,

I'm having a problem with my query. I've created a query that displayed all
'Volunteers information' which ran fine. However I then imported data from
Excel into a new table 'sheet1' and appended it to table 'Primary_info' that
I used in the query. The way I did this was by right-clicking 'sheet1' and
clicking on copy, then right-clicking and pasting into the database window
which then asked me if i want to copy it ' into a new table', 'bla bla' or
'append data into existing table', which I did. Now the table "Primary_info'
has been updated fine but when I try to run the query it only displays the
records that were there before I "appended" the data. I don't understand why,
I thought that once you update info. in a table everything else gets updated
with it when you re-run/requery/refresh.

I know that the data has been updated fine because when I created a new
query to filter similar fields I got all the records up. How do I get the
first query to pull up all the info.? What do I do?! Please help!

Thank you! any help or ideas are GREATLY appreciated.

Rana
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Appended data not being recognized 4
Append Query 1
append query errors 4
Appending null data and moving! 4
Append Query isn't working 2
append query question in Access97 1
VBA - retrieve data on last create named range from previous inserted named range 0
Appending Only New Data to a current Table 6

Top