By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,493 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Doing Reports in MS Access

P: 3
Greetings!

I'm a beginner in using MS Access and making reports on it.I used different linked tables as source of my query.With the help of Between[Starting Date]And[Ending Date] my report will execute.The report should display records of processes by station and by status.The problem is it only display those devices that were currently being processes by station.What I need is to see the devices display by all the station with their current status.Those devices must be in process step by step by the station so if I have five station, the particular device should be display in that five station in my report depending on the parameter that I will set by the Between[Stating Date]And[Ending Date] function.Do I need to convert my database from MySQL to MS Access?or should I only used expressions to distiguish all records to be display.Any help is much appreciated.Thank you and Godbless!
Nov 28 '06 #1
Share this Question
Share on Google+
4 Replies


100+
P: 1,646
Greetings!

I'm a beginner in using MS Access and making reports on it.I used different linked tables as source of my query.With the help of Between[Starting Date]And[Ending Date] my report will execute.The report should display records of processes by station and by status.The problem is it only display those devices that were currently being processes by station.What I need is to see the devices display by all the station with their current status.Those devices must be in process step by step by the station so if I have five station, the particular device should be display in that five station in my report depending on the parameter that I will set by the Between[Stating Date]And[Ending Date] function.Do I need to convert my database from MySQL to MS Access?or should I only used expressions to distiguish all records to be display.Any help is much appreciated.Thank you and Godbless!
Hi. Would you please post your query and any other relevant data so that I can better help you.
Thanks
Nov 28 '06 #2

P: 3
Hi. Would you please post your query and any other relevant data so that I can better help you.
Thanks
[IMG]rptDoc1.doc[/IMG].Thanks for the time...the problem in my report is that it doesn't show the devices by each station for example I have Five station,so one entry or device show be display and included in each station of the report but what's happening is that it can only be shown in 1 or 2 station only but I need it in those five station...how can I post my query?I just only used the Between start and end date function to retrieve information from my query that uses link tables.It do display the data by station but it is not in all station.If I have data1 in station1,data1 should also be in station2 and so forth.Thank you once again.Godbless!
Nov 29 '06 #3

P: 3
Thanks for the time...the problem in my report is that it doesn't show the devices by each station for example I have Five station,so one entry or device show be display and included in each station of the report but what's happening is that it can only be shown in 1 or 2 station only but I need it in those five station...how can I post my query?I just only used the Between start and end date function to retrieve information from my query that uses link tables.It do display the data by station but it is not in all station.If I have data1 in station1,data1 should also be in station2 and so forth.Thank you once again.Godbless!
Nov 29 '06 #4

NeoPa
Expert Mod 15k+
P: 31,661
Edit your report in Design view.
Make sure properties are showing.
Select Record Source property.
If it is SQL code then copy it from there.
If it is a query then click on elipsis (...) button. This will show the query in Query Design view.
- Select SQL view from the View menu.
- Copy the SQL code from here.
If it is a table then type in the names and types of all the fields.
Paste any copied SQL into a new post in this thread.
Nov 29 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.