Re: If criteria is null return all
- From: "Krizhek" <Krizhek@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 23 Feb 2006 08:18:28 -0800
Here is the structure of my data.
maintracker:
[AssociateID] = the user id (this is tracked by there sign in name which is
a 6 digit user id)
[date] = the date they took the call
[UserID] = ID of the person contacting the associate
[ProfitCenter] = Where the user is located > selection is linked to table
[Policy Number] = ID of the customer's policy
[Call Type] = Subject type of call > selection is linked to table
[Action Taken on Call] = Basic action our associate did > selection is
linked to table
[Reason for Disconnect] = In certain cases they will fill this out if they
were required to remove a particualr option > selection is linked to table
[Problem Description] = A list of major problems encountered by custmer's >
selection is linked to table
[Comments] = Allows our user to put in comments for later follow ups or
questions.
I hope this helps with the below also. I attempted to use the below but
both options did not work for what I needed.
First option doesn't work since it doesn't allow for me to filter out
unwanted data. (e.g. if I put in a user and a date it will show me all the
users for the date instead of just one)
Second option doesn't work since it filters out null data.
Please look over the above and let me know if the above is a flawed structure.
"Rick B" wrote:
Just enter your criteria Like [forms]![search]![name] & "*" under each.
field you want to check. Put each piece of criteria on a separate row in
the query grid to create an "OR" condition, or on the same line to create an
"AND" condition.
What ten fields are you searching? Are they all name fields? If so, you
have a flawed data structure and you will run into lots of headaches unless
you fix the data structure. If the name may appear in one of several
fields, then you have a one-to-many relationship that should be handled with
a separate related table.
Post back with some details if you need help with the structure of your
table.
--
Rick B
"Krizhek" <Krizhek@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9B339B86-1408-4C27-88BB-BB24608E5CB1@xxxxxxxxxxxxxxxx
If criteria is null return all
That all I want to do but after trying several ways I can't get any to
work.
Here is what I have tried so far for the criteria
Like [forms]![search]![name] & "*"
<>Which doesn't work since I have 10 fields I want to search and using
this causes null values in some fields to filter out.
Like "*" & [forms]![search]![name] & "*"
<>Same as above
[forms]![search]![name] and ([forms]![Search]![name] is null)
<> this causes the query to response with insufficient memory error
Below is the SQL of my query so you can see how many fields I am dealing
with.
SELECT UpdatedTable.[Who are you?], UpdatedTable.Date, UpdatedTable.[User
ID], UpdatedTable.[Profit Center], UpdatedTable.[Policy Number],
UpdatedTable.[Call Type], UpdatedTable.[Action Taken on Call],
UpdatedTable.[Reason for Disconnect], UpdatedTable.[Problem Description]
FROM UpdatedTable;
- References:
- Re: If criteria is null return all
- From: Rick B
- Re: If criteria is null return all
- Prev by Date: My query is broken and I cant fix it :<(
- Next by Date: Re: Delete query is not working
- Previous by thread: Re: If criteria is null return all
- Next by thread: Re: Output Access Query to Excel Spreadsheeet
- Index(es):
Relevant Pages
|
