Re: Prompt in query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks Rick. I will take your advise and make the corrections. In the
meantime, I tried =[Enter Billing #] & "*" in the first criteria row in the
billing # field and it didn't work. What am I doing wrong?? thanks

"Rick B" wrote:

> First, you should not store two pieces of data in one file. You should have
> a client field and a matter field. You can DISPLAY them as you indicate on
> forms, reports, and queries, but you should not be storing them that way.
>
> If you do want to keep your current design, use the following.
>
> =[Enter Billing #] & "*"
>
> --
> Rick B
>
>
>
> "Cissy" <Cissy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:7DD75F91-0573-4175-953C-FCC728376870@xxxxxxxxxxxxxxxx
> > Hi! Thanks for your help. I'm using Access XP.
> >
> > I've created a query that needs to pull all client/matter numbers. The
> > numbers appear like this: 444444-444, client number being the first 6
> > digits, matter being the last 3. They are separated by a dash. I need to
> > query on the first six digits and then pull all numbers regardless of the
> > last three digits. So far I have:
> >
> > [Enter Billing #]+"*"
> >
> > When I enter "112261" I need to see "112261-888", "112261-983",
> "112261-341"
> > etc. in the results window. But it doesn 't work, I've tried it every
> which
> > way.
> >
> > How do I write this piece of criteria? Thanks much.
>
>
>
.

Relevant Pages

  • Re: Is Access the right product for my need?
    ... "Rick B" wrote: ... fore you run the append query. ... Or a query to pull unresolved issues with suggestions, ... All info needs to be accesible to all members involved ...
    (microsoft.public.access.gettingstarted)
  • Re: Using Previous Record For Data Entry
    ... > WEll, a query could be run to pull up the last record entered, but you ... > of visual basic code in a control before update event. ... >>> Rick B ...
    (microsoft.public.access.forms)
  • Re: Using Previous Record For Data Entry
    ... Is it impossible to pull a default value from a query? ... "Rick B" wrote: ... >> Should taht work? ...
    (microsoft.public.access.forms)
  • Re: Using Previous Record For Data Entry
    ... WEll, a query could be run to pull up the last record entered, but you still ... of visual basic code in a control before update event. ... >> Rick B ...
    (microsoft.public.access.forms)
  • Re: Is Access the right product for my need?
    ... "Rick B" wrote: ... fore you run the append query. ... query to pull only resolved issues. ... All info needs to be accesible to all members ...
    (microsoft.public.access.gettingstarted)