473,327 Members | 2,074 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

one question about report

Hello,

I created a report containing weight and height for 50 individuals. The
field "ID" is included in the report. Is there any way I can report the
data for a specific person (say, ID=A13) ?

Thanks for your help.

Yang

Nov 13 '05 #1
4 1109
On Mon, 29 Nov 2004 20:18:18 -0500, "R. Yang" <jy*****@gmail.com>
wrote:

DoCmd.OpenReport takes several arguments. One of them is a WHERE
clause. Specify "ID='A13'" (note how I wrapped the textual ID value in
single quotes) and try again.

-Tom.

Hello,

I created a report containing weight and height for 50 individuals. The
field "ID" is included in the report. Is there any way I can report the
data for a specific person (say, ID=A13) ?

Thanks for your help.

Yang


Nov 13 '05 #2
Thanks! I'll try. Meanwhile, I just remembered seeing someone re-defined
the data source in the Properties of ID (in the design view of report).
Then, a pop-up window appeared prompting for the ID to be reported everytime
she previewed the report. Anyone has any clue what the re-defining could
possibly be?

Thanks.
Yang

Tom van Stiphout" <no*************@cox.net> wrote in message
news:ik********************************@4ax.com...
On Mon, 29 Nov 2004 20:18:18 -0500, "R. Yang" <jy*****@gmail.com>
wrote:

DoCmd.OpenReport takes several arguments. One of them is a WHERE
clause. Specify "ID='A13'" (note how I wrapped the textual ID value in
single quotes) and try again.

-Tom.

Hello,

I created a report containing weight and height for 50 individuals. The
field "ID" is included in the report. Is there any way I can report the
data for a specific person (say, ID=A13) ?

Thanks for your help.

Yang

Nov 13 '05 #3
On Tue, 30 Nov 2004 07:29:34 -0500, "R. Yang" <jy*****@gmail.com>
wrote:

You could modify the query underlying the report. Something like:
select * from MyTable
where ID='[Give ID:]'

-Tom.
Thanks! I'll try. Meanwhile, I just remembered seeing someone re-defined
the data source in the Properties of ID (in the design view of report).
Then, a pop-up window appeared prompting for the ID to be reported everytime
she previewed the report. Anyone has any clue what the re-defining could
possibly be?

Thanks.
Yang

Tom van Stiphout" <no*************@cox.net> wrote in message
news:ik********************************@4ax.com.. .
On Mon, 29 Nov 2004 20:18:18 -0500, "R. Yang" <jy*****@gmail.com>
wrote:

DoCmd.OpenReport takes several arguments. One of them is a WHERE
clause. Specify "ID='A13'" (note how I wrapped the textual ID value in
single quotes) and try again.

-Tom.

Hello,

I created a report containing weight and height for 50 individuals. The
field "ID" is included in the report. Is there any way I can report the
data for a specific person (say, ID=A13) ?

Thanks for your help.

Yang


Nov 13 '05 #4
Thanks! Will try.

Yang

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:uh********************************@4ax.com...
On Tue, 30 Nov 2004 07:29:34 -0500, "R. Yang" <jy*****@gmail.com>
wrote:

You could modify the query underlying the report. Something like:
select * from MyTable
where ID='[Give ID:]'

-Tom.
Thanks! I'll try. Meanwhile, I just remembered seeing someone re-defined
the data source in the Properties of ID (in the design view of report).
Then, a pop-up window appeared prompting for the ID to be reported
everytime
she previewed the report. Anyone has any clue what the re-defining could
possibly be?

Thanks.
Yang

Tom van Stiphout" <no*************@cox.net> wrote in message
news:ik********************************@4ax.com. ..
On Mon, 29 Nov 2004 20:18:18 -0500, "R. Yang" <jy*****@gmail.com>
wrote:

DoCmd.OpenReport takes several arguments. One of them is a WHERE
clause. Specify "ID='A13'" (note how I wrapped the textual ID value in
single quotes) and try again.

-Tom.
Hello,

I created a report containing weight and height for 50 individuals. The
field "ID" is included in the report. Is there any way I can report the
data for a specific person (say, ID=A13) ?

Thanks for your help.

Yang

Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: tc | last post by:
hi all, I would like to know how to export a cyrstal report to pdf by using the crystal report viewer without prompt up a dialog for user to enter the file name, i.e. I want to place the file...
3
by: Andrej Hristoliubov | last post by:
I am the best c++ programmer in the whole wide world. Trust ME! My reference is Victor Bazarov,Valentin Samko,Alf P.Steinbach( Me and Alf actually intern together at Microsoft), and Bjarne...
16
by: DFS | last post by:
If you're listening, I want the middle of the calendar (showing 1 month) to open below the cursor position. It currently opens just to the right and below the cursor position. I hunted through...
0
by: tc | last post by:
hi all, I would like to know how to export a cyrstal report to pdf by using the crystal report viewer without prompt up a dialog for user to enter the file name, i.e. I want to place the file...
2
by: Diana Estrada | last post by:
Hi, I have a ASP .Net, and in this I load a report or Crystal, with this instruction: crReportDocument.Load(Server.MapPath("") & "reporte.rpt"); It's good, but when I try to load a remote...
0
by: Ray | last post by:
Dear all, I have some questions about the Crystal Report and vb.net 2003. 1. I have installed the crystal report 10 and vs.net 2003. Should I update the crystal report within the vb.net so as to...
6
by: Ray | last post by:
Hi all, While I use the ReportDocument of vb.net to set filter to the data to the Crystal Report, it is successful for the first time while running the program. However, for the second time while...
0
by: Ray | last post by:
Dear Bernie, Yes, if the same pfieldname is used. The same data will be filtered. But I only use the code shown you before. I have not used any dataset or datatable. How to fix the problem?...
1
by: David | last post by:
Folks, I have four subreports in a report in the detail section. I suppose I could move them to the footer of the report. Anyway, if any of them have data, I want the main report to force a...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.