Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-19-2019, 05:22 AM   #1
jnvcdfhj
Newly Registered User
 
Join Date: Aug 2019
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
jnvcdfhj is on a distinguished road
Query not displaying all data

Hi all,

I am running a query to collect information regarding equipment which is stored on a continuous form. When i run the query it only display the first entry not all?

Any help is appreciated.

jnvcdfhj is offline   Reply With Quote
Old 09-19-2019, 05:37 AM   #2
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,569
Thanks: 68
Thanked 2,745 Times in 2,630 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Query not displaying all data

what is the criteria of your query. it will only return 1 record if it is based on the form, unless you run a function to retrieved all that is displayed on the form.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 09-19-2019, 05:54 AM   #3
jnvcdfhj
Newly Registered User
 
Join Date: Aug 2019
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
jnvcdfhj is on a distinguished road
Re: Query not displaying all data

I select the table everything is stored in but only displays the first record. On the form itself it displays everything i need but not when i do the query.

jnvcdfhj is offline   Reply With Quote
Old 09-19-2019, 06:07 AM   #4
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,569
Thanks: 68
Thanked 2,745 Times in 2,630 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Query not displaying all data

what is the SQL of the query?
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 09-19-2019, 06:16 AM   #5
jnvcdfhj
Newly Registered User
 
Join Date: Aug 2019
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
jnvcdfhj is on a distinguished road
Re: Query not displaying all data

SELECT Equipment.Quantity, Equipment.Make, Equipment.Model, Equipment.[Full Description], Contacts.CompanyName
FROM Contacts INNER JOIN Equipment ON Contacts.[ContactID] = Equipment.[EquipmentID];
jnvcdfhj is offline   Reply With Quote
Old 09-19-2019, 07:02 AM   #6
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,569
Thanks: 68
Thanked 2,745 Times in 2,630 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Query not displaying all data

don't you think there is wrong in your criteria:

Contacts.[ContactID] = Equipment.[EquipmentID]

whethere they are both autonumber, still does not make sense.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 09-19-2019, 07:37 AM   #7
jnvcdfhj
Newly Registered User
 
Join Date: Aug 2019
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
jnvcdfhj is on a distinguished road
Re: Query not displaying all data

Even if i dont attempt to pull information from the contacts table just equipment it still only displays the first record.

jnvcdfhj is offline   Reply With Quote
Old 09-19-2019, 03:00 PM   #8
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,271
Thanks: 15
Thanked 1,595 Times in 1,515 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Query not displaying all data

We can't see what change you made to the SQL so we can't even guess whether or not you made the suggested change.

to be clear, an inner join will only return rows where there is a match in BOTH tables so if you didn't remove the inner join, you still have a problem. We can't guess what your schema is so we can't guess what the join should look like or even if it is possible to join those two tables. If they don't have a common field, then you can't join them.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] SQL query on displaying distinct data hunoob Queries 7 06-22-2016 06:32 AM
Query Help - displaying data Arvin Queries 3 01-20-2009 09:56 AM
Displaying query data in a text box SBO Forms 4 10-08-2007 07:37 PM
Query not displaying all data Chimp8471 General 7 04-15-2003 02:09 AM
Displaying Query Data on Unbound Forms??? mvpejp Forms 1 12-04-2002 05:33 PM




All times are GMT -8. The time now is 02:41 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World