Show all in Report?

[Penny Miller]

I have several tables in my Equipment Inventory DB. What I need to provide
is a report that includes all PCs in the database whether they have a
backup schedule entry of not (table equipment, table backup)

My problem is this... I created a Query that pulls in the correct fields
that I need to show in my report however, it doesn't list all the PC's it
only shows the equipment that has backup schedule.

 

[Al Campagna]

Penny,
Without seeing the SQL statement, there's no telling what might be causing that. Post
your SQL...

Sounds like you've got some criteria in the query that excludes records with "Null"
BackupSchedule.

What don't you start out with just something simple like the (ex. fields) PCSerialNo,
PCLocation, and BackupSchedule fields, and see if you get all records. Then add another
field, run the query, and see if there are any changes. You should experiment with a
Select query first... no Totals queries.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Penny Miller]

Here is my SQL statement.

SELECT [Equipment Inventory].Department, [Equipment Inventory].Name,
Backup.BPath
FROM [Equipment Inventory] INNER JOIN Backup ON [Equipment
Inventory].EquipmentNumber = Backup.EquipmentNumber;

I try and start out w/a few fields before I posted this and still got the
same results. Good idea though.

 

[Al Campagna]

Penny,
By using an Inner Join, you're asking to only include records where the joined field
from both tables is equal. Any PCs that have no EquipNo in table Backup will be excluded.
Use a Left Outer Join... which means... "Show all equipment records from my equipment
table, and (using the join field) only those records from Backup where there is a match...
That forces all PCs to list whether thay have backup data or not.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

Here is my SQL statement.

SELECT [Equipment Inventory].Department, [Equipment Inventory].Name, Backup.BPath
FROM [Equipment Inventory] LEFT JOIN Backup ON [Equipment Inventory].EquipmentNumber =
Backup.EquipmentNumber;

I try and start out w/a few fields before I posted this and still got the same results.
Good idea though.

Penny,
Without seeing the SQL statement, there's no telling what might be causing that.
Post your SQL...

Sounds like you've got some criteria in the query that excludes records with "Null"
BackupSchedule.

What don't you start out with just something simple like the (ex. fields) PCSerialNo,
PCLocation, and BackupSchedule fields, and see if you get all records. Then add
another field, run the query, and see if there are any changes. You should experiment
with a Select query first... no Totals queries.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."