Single record report (1 Viewer)

Wawa254

New member
Local time
Today, 19:16
Joined
Jan 31, 2021
Messages
7
Hello.
I have a problem generating a single record report.
My tables containes many records and I want to generate a single record report,
How do I do it?.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 00:16
Joined
May 7, 2009
Messages
19,249
add a "WhereCondition" on DoCmd.OpenReport command.
you can also use a Query that "filter" the result to a single record.
 

Wawa254

New member
Local time
Today, 19:16
Joined
Jan 31, 2021
Messages
7
Thank you.
 

Wawa254

New member
Local time
Today, 19:16
Joined
Jan 31, 2021
Messages
7
I still have problem with a single report record.
add a "WhereCondition" on DoCmd.OpenReport command.
you can also use a Query that "filter" the result to a single record.
I still have problems with a single record report,
 

Minty

AWF VIP
Local time
Today, 17:16
Joined
Jul 26, 2013
Messages
10,382
Can you show us what you have tried - what code or macro you are using?
 

isladogs

MVP / VIP
Local time
Today, 17:16
Joined
Jan 14, 2017
Messages
18,293
As well as providing details of the code or query you are using, please also state what problems you are having
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 12:16
Joined
Feb 19, 2002
Messages
43,700
Where's my Karnak the Magnificent hat when I need it 😭

FYI, for the youngsters among us, this is a skit from the old Johnny Carson show. He put on a turban with a big feather. He gave the answer to a question and then he read a question from the audience.
 

Users who are viewing this thread

Top Bottom