Topics Search

Report based on query shows no data

Report based on query shows no data
Views: 12
I have created a query and designed a report based on the query in Access 2003, and it was working fine. Fortunately, I exported the results that I needed for today into an rtf file, so I don't have an emergency.

I'm not sure what I changed, but the next time I opened the report, no data appeared - it just shows a few labels that were part of the report format.

I can still see all the data when I view the query in datasheet format.

I tried changing the data source under report properties to use a different query, and then the report works fine. But when go back to using the query that I want to use as a data source, I get no data in the report.

The query I am using is based on external data in Excel files located on another computer on the network.

Before I started having problems, I got a message saying the report had been set up for a different printer, The laptop I am using for Access is not currently set up with a working printer driver. Could that be relevant?
Sponsored Links:

Similar posts...

 

Report Based on Query showing ID's not Data

Report Based on Query showing ID's not Data Icon
I created several tables with Look-Up fields, I have followed the direction for changing the Look-Ups to Text Boxes but that does fix the report.

The Query still shows the data and not the ID's but the report still shows the ID's.
 

Problem with Report based on Query

Problem with Report based on Query Icon
I created a query to extract data from a linked table. The query does not have any sorting. Then I created a Report based on the query. The report does not have any grouping or sorting.

The issue is: When I run the report I get the same data that I get from the query, but it comes out sorted. I cannot even find by which field the data is being sorted.

I have double checked the query and the report and they do not have any sorting or grouping of any kind.
By the way I am using Access 2007.
 

Problem with Report Based on a Query

Problem with Report Based on a Query Icon
I created a query to extract data from a linked table. The query does not have any sorting. Then I created a Report based on the query. The report does not have any grouping or sorting.

The issue is: When I run the report I get the same data that I get from the query, but it comes in a different order.

I have double checked the query and the report and they do not have any sorting or grouping of any kind.
By the way I am using Access 2007.
 

Changin report's fileds with VBA

Changin report's fileds with VBA Icon
I have a report, that is based on a query. I want all the fields in the query to appear on the report. The query uses 3 tables for its data, and one of tables in constantly being deleted/recreated from vba and primary key is being assigned to one of the fields.

Each time the table is recreated, 2 of the fields that are in the query, have their names and data changed. My problem is that when that happens, the query works fine since its SQL is being changed in VBA to reflect the new changes, but the report shows an error in the fields that have beenchanged in the table.

Is there any way for me to dynamically change the report's fields, to the once used in the query.
 

Reporting Issue: Combine query

Reporting Issue: Combine query Icon
I have a report that combines 3 queries based on three tables which have one primary key in common (NCR Num). The only issue is that when I combine them together and run the report, I am getting ALL the entries from the tables, instead of just the entries that are associated with that one common primarykey value (NCR Num).

Relationships: Shows the three tables and how they relate

Report Layout: Shows how I have done up the report in design layout

Report Results: Shows the extra values that I do not want. Ex. This is the report for NCR 19 but I am getting information for NCR 20 and 21 in the Problem Section and NCR Employee Section

Data Entry Form: Just shows the data entry for that feeds entries into all three tables.
 

Duplication in a report

Duplication in a report Icon
I am creating name tags for a convention. I have a query that finds all names that have not been printed. I created a report to print the name tags in two columns on a 4x3 in cards. (81/2 x11) they look good.

The problem:
The query has the correct number of names and other info. The report is based on the query. When I Print preview the report it appears to have every name in the report duplicated over 6 times. However in the query it only shows up once as they should.

The name tag report should be 12 pages and now I am up to 6000+ pages. It looks like every time I run the report that it is adding to the previous report. Can this happen?
 

How to show entered criteria from a query on a report?

How to show entered criteria from a query on a report? Icon
I have a query that generates a report based on two manually entered dates (Start Date and Stop Date). The report then shows the data that is relevant between the two entered dates.

I would like to be able to display the two entered dates at the top of the report, just as a visual aid to the user.
 

Merging 3 queries into one report

Merging 3 queries into one report Icon
I am sure this is possible but I keep getting error messages or blank data showing up.

What I am wanting to do is pull information from the data table based on academic year. I have the queries set up to pick data between certain dates which works fine in the query. When Iwant to use the queries to produce a report - ie combining 3 years worth of data for a member of staff against their staff code - no data is showing up.

I have set the field properties in the report to select from the right query and based the form on the table (not a query) but it won't bring the data up for me.
 

Issue in copying the report.

Issue in copying the report. Icon
I created a report based on a query and it works fine. Then I need another report based on another query. I copied first report and changed the record source. Both queries are same just differing by one criteria.

When I open the second report, it ask to enter date. Why? I can create a new report but want to learn from where it is affecting.
 

Missing Data in a Report Field

Missing Data in a Report Field Icon
Displaying a report several of the records are missing data in one of the fields. Other records display the data o/k and the field displays correctly in the table,form and query. I have deleted the data and re-entered it redone the query and the report, all to no avail.The report is based on a query and the query returns all the required fields when run.
Interestingly, when I export the query result to MS Excel, all the values are displayed correctly and no data is missing. Have also checked the data types in the table and all seems find there.