Help With Filtering Results

Mar 6, 2007

I've created a database to keep track of all our Microsoft licences for the company.
Just to make sure we're fully licenced, to allocate where needed, and to help reallocate when we replace a pc.

I have 2 tables, 1 hardware (listing PC ID,location etc.) and 1 software (listing software type, software licences, and to which PC ID allocated).

What i'm trying to do is filter the pc's missing either an Office licence or a Windows licence or both, so i can base a report on the results.

I've tried but can't quite get it to work.

Any help would be greatly appreciated.

View Replies

Filtering Within Search Results

May 26, 2006

Whats the best way to filter search results?

I'll do my best to explain my problem:

I made a form that lets users search for records in a database and displays them in another form. In that form I've made 3 buttons to let users narrow down the results to show only certain items within the search results.

Now, 2 of the buttons show specific items and the third one toggles the form to display all the records. So lets say I'm filtering records by whether or not they contain the words "car" and "truck." If a record has "car" but not truck and I click the button to sort by "truck" then the search result goes blank, which is ok. But if I click "car" or "show all" to display everything again then the search result stays blank.

This doesn't happen with records that contain both "car" and "truck."

For every button I have something like this: DoCmd.OpenForm "AdminSearchResults", , "SOW", "VendName = '" & VendName & "'", , , "'VendName'"

I know my explanation may suck, but if anyone can help me, that would be great, lol

View 3 Replies View Related

Modules & VBA :: Filtering Results In List Box

Apr 21, 2014

I am using a form in which i am filtering the results in the list box based on the textbox value. I am dynamically switching 3 row sources for the list box.

My Need is that the results produced in the listbox should get filtered again when typing in the second text box i.e based o the country name.

View 1 Replies View Related

General :: Filtering Results Outside Of Standard Deviation

Oct 16, 2014

I am trying to create a query that filters results only outside of 1 standard deviation of the mean. Is there an option for this in the criteria spot? I'm fairly new to Access and I'm not sure if I can reference a particular cell in the criteria.

View 1 Replies View Related

Modules & VBA :: Goto Record Without Filtering Results

Dec 5, 2013

Is there a way to search for a term within a form and goto a record that matches that term assuming there was only one matching result (Unique ID, for example).

But NOT filter the results so that user can still navigate as usual after the search has been carried out.

View 1 Replies View Related

Filtering Crosstab Query And Display Results

Dec 19, 2014

I have a crosstab query. There is a field for row headings that specifies QUARTER (Q1,Q2, Q3,Q4) and another field for row headings that specifies YEAR(2015,2016,...etc)

I want to be able to have the user input the criteria in to a box and filter the crosstab query to then display the filtered results.

Right now on my column headings I have MONTH.

When I try to reference the form in the criteria, I always get the error

"The Microsoft Database Engine does not recognize ..... as a valid field name or expression"

Does this mean that you can not filter crosstab queries?

View 5 Replies View Related

Forms :: Combo Boxes Filtering Results Into A Subform

May 30, 2013

I have these 3 combo boxes filtering results into a subform.

Code:
Private Sub Combo5_AfterUpdate()
If Len(Nz(Combo5, "")) > 0 Then
FindRFQsubform.Form.Filter = "[RFQ Title] = '" & Combo5 & "'"
FindRFQsubform.Form.FilterOn = True

[code]...

View 1 Replies View Related

Queries :: Filtering Data - Results Need To Be In Specific Order

May 21, 2013

I'm taking my first database class and I'm working on a hospital project in which I need to determine which pair (one doctor and one nurse) has a decremental performance as weeks go on.

I have an "r" and "s" queries.

These are the fields:

r: [DOCID,NURSEID, WEEK, RESULT]
s: [WEEK, RESULT]

I would like to find what pair had a "Good" result in week 1, "Average" in week 2, and "Bad" in week 3. My problem is that the results need to be in this specific order.

The professor told us to use a formula and I got the solution after building 6 queries that involved union, difference, and cartesian.

View 4 Replies View Related

Return Weekend Results On Monday, Yesterday's Results Otherwise

Nov 14, 2007

I am trying to filter a form to show the entire weekend's activity on Monday but only yesterday's activity Tuesday through Friday. Using this code I can return Friday's results on Monday and yesterday's for the rest. How do I get the range Friday to Sunday?

IIf(DatePart("w",Now())=2,Date()-3,Date()-1)

Using >Date()-3 doesn't work.

Thanks

Bruce

View 5 Replies View Related

Reports :: Search Results Report Shows All Database Records / Not Just Search Results

Apr 29, 2014

I have built a custom search form in a MS Access 2010 database so that users can find specific records to edit. After entering the search criteria and hitting a Search button, another form opens up that shows the search results. This second form includes a command button for generating a report of the search results.

Right now, the custom search form and the search results form are both working properly, but the search results report is showing every record in the database instead of just the search results. This is true whether I access the report via the command button in the form or the navigation pane. I'm not sure if I need to correct my VBA code or the report's properties.

View 4 Replies View Related

Filtering

Jun 14, 2005

I have a text box (txtInput), is there a way that I can filter results on a form based on txtInput.text?

View 1 Replies View Related

Filtering

Jun 2, 2007

Hey guys im a bit stuck and would really appreciate any suggestions...

I have 3 tables:

Table 1: Products
Product_Name

Table 2: Suppliers
Supplier_Name

Table 3: Prices
Product_Name
Supplier_Name
Supplier_Price

Table 1 & 2 have a relationship to table 3, with a many to many relationship. i.e. many products can have many suppliers.

This part works well and i have a form that shows each product with a subtable that shows that products suppliers.

However, i want to be able to filter to prices table to show each individual supplier and what products they supply.

I appreciate they time anyone took to read this and hope i made it clear, and if any one can help like i siad i would be very gratefully :)

View 1 Replies View Related

Filtering

May 19, 2006

When using the MS Works database the "Find" command makes a new table of all records that include the chosen words.
The "Find" command on Access 2002 does not do this, nor does any filter command. Is there an easy way to do this in Access?

Thanks

View 3 Replies View Related

Help With Filtering

Aug 10, 2005

I want to filter the information displayed on a form using the values I select in text or combo boxes.

I want to filter the form using one or more of the following options.
Call Ref - text box
Location No - Combo box
Area - combo box
Status - combo box

The combo boxes are taking their values from other tables within the database.

Can anyone help me develop the code needed to filter the form.

Thanks

View 4 Replies View Related

Filtering!!

Jun 26, 2006

hello

i have a data sheet form which I need some help with!!
I have a lot of data that I need filtering.

The first filter is for day and the second is for time of day.
I.e. i want to be able to click on a date (using the calender from MS datepicker) and have the datasheet return the records for that selected day.

But I would also like another field that can filter it down to a specific time of day. e.g. 27/06, 13:00 returning all the records for this specific time slot.

At the moment there is a filter for date AND time but I would like date AND/OR time.

Also I would like to have it setup so it automatically gets rid of data over 2 months old, is there a way to do that, if not automatically maybe with a macro/command button??

Thanks for you help

View 1 Replies View Related

Filtering

Jan 14, 2008

i have a form bounded to a table called street.
this form has 2 bounded text boxes:
country: lookup field to the country table
city: luukup field to the city table

i want to do the following: when GetFocus on the city text box, i want to filter in thi stext box for all the cities that belong to this country (value in country text box)
how?

View 5 Replies View Related

Form Filtering?

Nov 1, 2005

Hey all I am having a problem with my form filter. I was wondering if you can just direct a filter from form 1 to form 3 without referencing form 2. I am thinking not cause I am having a problem getting the filter to work. Here is the code I have in my load form.

framfiltval = "CONSTR_LOCATION = " + "'" + Form_PID.ADDRESS3.Value + "'"
Form.Filter = framfiltval
Form.FilterOn = True

Thank for the help in advance

View 2 Replies View Related

Question On Filtering??

Jun 20, 2007

Hi

I have this database that list companies and what type of loan they have. I am having a hard time thinking of the right type of filter to use. I am looking to select multiply types of loans and have it filter out the companies that have that service. I was thinking of a list box or options but I am having trouble with the table. My question is how would you go about it? Thanks

View 1 Replies View Related

Filtering, I Guess That's It

Jul 23, 2007

hi
hope someone can help.
I'm making a form to select country/state/city for members
i made a table with 3 columns country,state,city

i wrote down the states for 2 countries (the ones i'm gonna use)
the city is left blank (since i don't want to write down all the cities just yet)

i'm looking to do:

When i try to display the Country as a drop down using a query that selects the column for country, i get a list of the same country the amount of times it is in the table for each state.
I only want to see each country once. even though in the table it is written several times.

View 2 Replies View Related

Filtering Nightmare

Feb 1, 2008

Is there any way that I can import a text file and split the data into three columns without having to go through 65000 lines of text.

It is basically a print off of a directory structure. I have a very large text file that lists the files in folders for each of hundreds of users. I need to divide the information up into three columns so that the below data:

BOBSongs

2003-07-15 12:10 PM 1,474,564 blue.mp3
2003-07-15 12:09 PM 858,204 orange.mp3
2003-07-15 12:10 PM 1,665,028 yellow.mp3

BOBsongshappy

2005-08-23 03:01 PM 917,504 jolly.mp3
2003-07-15 12:09 PM 331,005 joker.mp3

BOBfiles

2005-08-23 03:01 PM 917,504 writing.doc

ends up looking like this:

BOBsongs1,474,564 blue.mp3
BOBsongs858,204 orange.mp3
BOBsongs1,665,028 yellow.mp3
BOBsongshappy 917,504 jolly.mp3
BOBsongshappy 331,005 joker.mp3
BOBfiles917,504 writing.doc

I easily imported the file into Excel, but it is still all in a column. Any advice would be appreciated.

View 5 Replies View Related

Filtering A Form

Feb 19, 2008

Hi all,

I'm creating a database for agents to use at work. Because they will all be using it at the same time, I need to create a combo box on the form that will filter the contents to only show those with their name in them. Is this possible?

Thanks!

View 6 Replies View Related

Filtering In Table

Mar 25, 2008

Hello All,

I am new here and was wondering if anyone has ever had the following happen:

When you 'Filter by Selection' in a table for NULL values the number of records shown are less than the actual number of records with NULL values.
For example, I tried this with a particular tables looking for NULLL records in a particular field and while I could clearly see that the number of NULL values was x, the number returned upon filtering on NULL in that field was less than x.

Any idea? Your help is very much appreciated.
Thanks!

View 6 Replies View Related

Drop Box Filtering

Jan 6, 2006

Hello Everyone. I'm not all that new to access however my problem does exceed my experience and I'm hopeing someone out there maybe able to help me.

A while back I began to build a database to keep track of post production activites such as what items were being produced on a perticular production line. Its my job to book all these items in according to date, line, item, order and qty.

This was all good and simple until it was decided that I had to assign a category to each item. Their are multiple models to one perticular category and to make things even more difficult the same item could be produced on more than one production line.

I work within a Pool company where their are 7 production lines, each with their own purpose and facilites of making certain products until you come to other products that could be produced on any of 3 or more lines.

So, I made a table 'Category' which lists the different types/acronyms for products and the lines in which it could be produced on.
I than created a new column within my Post Production table called 'category' and chose to use a drop box so I may select which category to assign the item. The drop box shows both columns 'Catefory','Line'.

The problem I have is that theres 40+ rows within the Category drop box and because the same name of the category may appear more than once simply beginning to type in the category name isn't good enough.

Is there a way to filter out which categories is listed within the drop box according to which line it maybe coming off once I've already selected which line within the same row?

I've tried selecting a relationship and createing a query both failed.

WarrenG.

View 5 Replies View Related

Filtering A Query...

Jan 4, 2006

i have about 14 fields that relate to subjects, basically i want to be able to run a query that searches for all the people who have choosen the module and report bak who they are..

now i know i can do this 14 times over but is there a way that the user can choose the subject first and the query will then run hence meaning only one query/report.. i thought of using a list/combo box but have absolutely no idea...

im very much a novice but any help would be most apreciated!

cheers

si

View 2 Replies View Related

Filtering Problemo!!!

Jul 5, 2006

So I have a lot of data that sometimes needs filtering by Date, or Date and Time. Is it possible to have a drop down box to display everything for a specific date, and then another combo box to filter even further for specific time slots.

If so how??

Cheers!! :o)

View 1 Replies View Related

Query Filtering

Feb 27, 2007

I have a query filtering question. Please note attach pic for further details. I am trying to put together a search in a form to seach for a certain color or color series from a Qery from two two different sources (from a Combo Box and from a Text Box). I am not sure how to set this up in the query.

Can someone please point me in the right direction?

Thanks,

Kilch

View 2 Replies View Related