Re: Still need help...

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 07/12/04 

Date: Mon, 12 Jul 2004 12:29:04 -0500

I am not sure how anyone can help unless you provide answers to the
questions I posed. I have no idea what your fields and records look like
from what you have provided.

Also, please use upper and lower case characters. You will rarely see a post
from an MVP (or others who help here a lot) that doesn't make an effort to:
1) spell correctly
2) use paragraphs to break up larger posts
3) use both upper and lower case characters to make reading easier
4) use proper punctuation (excuse my forgetting question marks quite
frequently ;-) 

-- 
Duane Hookom
MS Access MVP
"Rob" <anonymous@discussions.microsoft.com> wrote in message
news:2b0c301c46826$77419850$a501280a@phx.gbl...
> i am willing to accept criticism and would LOVE some help,
> but if you look at the last mvp's post it did not offer me
> any suggestions and/or help.  he made a claim and had no
> information to back it up.  he suggested that i have poor
> table design, which if he explains to me why and offers a
> suggestion as to how to design better i would gladly
> listen.  i am sorry if i come off as rude, i had a
> deadline to meet and find that if people blatantly insult
> my work without offering suggestions or help, it is
> completely useless to all.
>
> For those of you who actually helped me, i thank you.
>
> -Rob
>
>
> >-----Original Message-----
> >Rob,
> >Apparently you don't want to take solid advice. Many of
> us don't usually
> >like to suggest solutions that aren't in the best
> interest of good practice
> >application development.
> >
> >After reviewing your posts, I don't have any idea what
> your field names
> >might be and what type of data they are storing. I can
> only assume they are
> >storing date values since you original post
> stated "Between  #07/01/04# And
> >#07/31/04#". You should take the time to:
> >1) enter some sample data with field names
> >2) describe what you want to query
> >3) enter the results you would expect to see from the
> query
> >4) accept constructive suggestions from experienced
> developers
> >
> >-- 
> >Duane Hookom
> >MS Access MVP
> >--
> >
> >"Rob" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:2a96101c4681e$4679ee00$a601280a@phx.gbl...
> >> again thank you for your reply, but this reply doesnt
> help
> >> me at all.  i thought that as an "MVP" it was your job
> to
> >> help people.  i appreciate the constructive criticism,
> but
> >> can you please offer a suggestion instead of insulting
> my
> >> design.
> >>
> >> thank you,
> >> Rob
> >>
> >>
> >> >-----Original Message-----
> >> >On Fri, 9 Jul 2004 12:38:06 -0700, "rob"
> >> ><anonymous@discussions.microsoft.com> wrote:
> >> >
> >> >>John,
> >> >>thanks for the response but be sure that i have
> multiple
> >> >>tables already.  i am doing a lawyer referral database
> >> >>which is all done and working fine with the exception
> of
> >> >>the receipts part which is what i asked for help on.
> i
> >> >>thank you for your suggestion to use two tables, but i
> >> am
> >> >>way past that. i am doing one simple table for
> receipts
> >> >>for money earned.  all i want to do is search the 12
> >> date
> >> >>fields for july dates so i can run monthly reports.
> >> >
> >> >I'm sorry, but YOU ARE MISTAKEN. If your database has
> 163
> >> tables it
> >> >needs 164. A table with twelve date fields is not in
> >> third normal
> >> >form, and will be the source of unending problems (not
> >> least when you
> >> >get 13 receipts...)
> >> >
> >> >
> >> >                  John W. Vinson[MVP]
> >> >    Come for live chats every Tuesday and Thursday
> >> >http://go.compuserve.com/msdevapps?loc=us&access=public
> >> >.
> >> >
> >
> >
> >.
> >

Relevant Pages

  • Re: is there a rule ...
    ... These need to be clearly distinguished from the user interface design. ... are part of their plan for buying CyclingNews anyhow. ... Suggestion: maybe change the shape of the Flash carousel. ...
    (rec.bicycles.racing)
  • Re: how can you use mshtml DOM object to grab rendered asp.net page?
    ... > (create DOS batch file with CACLS commands) that Microsoft ... The other suggestion was to add the username ... use interop to automate Office from a Windows app. ... It's a design nightmare and a bad decision on their part in my opinion. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Word 2004 Deleted/Replaced Phrases
    ... shop shelf, one in coding, one in design. ... The new display does not suit me, but then I am a Technical ... Writer who can have literally thousands of detail-level changes in a ... I think sending Microsoft a suggestion for a Mac product ...
    (microsoft.public.mac.office.word)
  • Re: Combo Box AfterUpdate Help
    ... you got a working answer (you didn't reply to my suggestion) ... > database design I would have asked for that instead. ... >> I speak from 25 years of experience with Relational Databases and nearly ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Using GROUP BY in query expression on MEMO fields it truncates data in MEMO fields to first 255
    ... MS Access MVP ... Comments will return me full value of MEMO field? ... > I must see how this looks like in Design. ... > |>> I have attached this database as example of bug. ...
    (microsoft.public.access.reports)