Re: Please help... KRISH
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Dear Krish:
You will probably need to supply all possible dates to the query, so it can
report them. A one-column table of dates would be best. You can write a
module to append them, too, rather than typing every one. You can make your
query starting from these dates. Just how, I don't know. Not enough detail
from your post.
Tom Ellison
"KRISH" <KRISH@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:35093833-E76E-4E0E-99C2-07323EDD92E6@xxxxxxxxxxxxxxxx
Hi! everybody,
I am working on Guest House computerization. Kindly help for the following
how to do i get monthly report. I want my report should show if no entry
on a
particular day then it should show all beds available (i..e., total beds
in
guesthouse). Problem is that say there is only one entry i.e. from 5th Jan
to
9th jan. My query is only showing status of 5th and 9th and ignoring all
other days. But actually status for other days should be total beds
available. Its also ignoring 6th,7th,8th jan, which is incorrect. Please
help.
Thanks
Krish
.
Relevant Pages
- Re: Populating a list -- table structure?
... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
(microsoft.public.access.forms) - Re: Fields in Label dont give correct information
... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
(microsoft.public.access.reports) - Re: Tips on domain aggregate replacements
... This already is a split db, but the users are 400 miles away from the server hosting the data:) They are all running the same copy of the FE locally on a single terminal server via TS/RDP sessions. ... It doesn't seem to have much impact on performance; the report takes just about as long to run if they are all logged in as it does when I am logged on testing it at night. ... I would do DSums from the controls on the report on the data returned by the query. ... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months (the DSum in VBA was a sideline to this issue) and present these as items on each line of output. ...
(microsoft.public.access.modulesdaovba) - Re: using a form with combo box to input criteria
... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
(microsoft.public.access.forms) - Re: using a form with combo box to input criteria
... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
(microsoft.public.access.forms) |
|
