Solved

access query and  report

Posted on 2011-02-24
23
211 Views
Last Modified: 2012-05-11
i attch dbe.
go to chaps data query report
This report shows fields that have some entries and fires where there are no entries.
Is it posssible to produce a report based on a query like this:
If there are no entries in that field DO NOT include that field in the report.

Also could then any empty space be removed in the report to save space/paper (which is the real object)




practice-completionDatabase.mdb
0
Comment
Question by:topUKlawyer
  • 13
  • 10
23 Comments
 

Author Comment

by:topUKlawyer
Comment Utility
show read "fields where there are no entries"
not fire!
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
see if this helps

set the can grow and can shrink property of the textboxes
add code in the detail format event to hide textboxes that don't have values

you may try using sub reports.
practice-completionDatabase.mdb
0
 

Author Comment

by:topUKlawyer
Comment Utility
forgive me, have you modified the database/ i thought that you had by attching it but I cant see what you might have done?
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
are you reading the posted comments?
0
 

Author Comment

by:topUKlawyer
Comment Utility
yes
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
Comment Utility
did you see the change?

here is the file again, open the report


practice-completionDatabase.mdb
0
 

Author Comment

by:topUKlawyer
Comment Utility
must be a Slow Brain Day....i cant see the difference...i seem to be getting all the same fields, empty or not.

unless you can say otherwise
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
which report are you looking at?

i revised the report "chaps data Query rpt"
0
 

Author Comment

by:topUKlawyer
Comment Utility

looking at same report but cant see the difference, with huge respect to your goodself.

can still see many empty fields.
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
are you opening the report from the file that i uploaded? here is the report


post your comment about the image
0
 

Author Comment

by:topUKlawyer
Comment Utility
looks great but nothing like the one I opened from the one you sent me

ie the jpg looks fine but doesnt look like the report at my end...

are sure you didnt make a fresh copy at your end which hasnt been sent yet....

0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
download the file i uploaded at http:#a34971143

and save it AWAY from your files.
0
 

Author Comment

by:topUKlawyer
Comment Utility
saved it to desk top and several other locs on my computer-still same

very strange...
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
how are you opening the report?
0
 

Author Comment

by:topUKlawyer
Comment Utility
click on the bar in the "menu"
0
 

Author Comment

by:topUKlawyer
Comment Utility
can see the code behind it you have added


for each etc
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
what "menu"?

just do a double click on the report
0
 

Author Comment

by:topUKlawyer
Comment Utility
am doing that i really am,  how i usually open reports...

sorry got a train to jump on

will catch up later

thanks as usual
0
 

Author Comment

by:topUKlawyer
Comment Utility
tis weird
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
test on another computer...
0
 

Author Comment

by:topUKlawyer
Comment Utility
tested on another computer on the network and works fine.

must be a macro enabled situation??

any ideas?

0
 

Author Comment

by:topUKlawyer
Comment Utility
have awardede points but any ideas as to why tmy computer is blocking the code would be welcome.

I enabled macros on the dialogue box
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
without seeing your computer, i can't really tell.
check virus protection softwares (norton ???)  that you have in your pc and compare it with the pc where you were able to run the report successfully.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now