Search results

Please help optimize my query. I'm creating a report that shows usage and sales of inventory over the past 90 days. In addition, I need to report to list the Last Activity Date for each product. I have a query to give me all activity - CSP IPs. This takes about 5 seconds to run. To filter...

I ended up managing in Excel. I created a column that has each business day in it. Then did a vlookup to the query results that gave me the total sales if there was a sale that day. I added an iferror(vlookup(),) so that days without sales returned a 0.

Eventually in my analysis I need to show the average 3-day sales amount when I shoot it into Excel. So if there is $300 on 8/1, $0 on 8/2, and $100 on 8/3, I want to be show the 3-day average as (($300 + 0 + $100)/3). Right now, it would skip over 8/2 then include 8/4.

I'm trying to build a query that adds up the total sales for a given product per date. The problem I'm running into is some products have $0 sales on a given day and don't appear in the table I'm querying. How would I get the query to add a record for that day for the given product with 0 in the...

So I figured out that my Iif was missing a Like in the beginning. I'm now able to see the Ready Only records when the checkbox is clicked. Now my problem is the query doesn't show all records (including not ready) if the checkbox is unchecked. It's not picking up the "*" when ReadyOnly <> 0 Any...

I'm working on a report called Open Orders and when the database loads, it takes you to a Navigation Form. You make some selections mostly from combo boxes, then click run report which runs a query then launches the report. I want the user to be able to click a check box called "Ready Only". If...

I have Access 2010 and am trying to create a cross tab query that will display the percentage of the subtotal as the values. For instance: Current Late Default A 8 1 1 B 15 3 2 C 40 8 2 Current Late...

I think the error stemmed from a Yes/No field I had where I had no default value and a Dlookup set a boolean as the value of the field. I changed all the defaults on the Yes/No's to False so hopefully that takes care of that. I think the error through me off because I never saw it before...

I created a db mostly through VBA and have spent a few weeks testing and have never seen this error. I finally split the db, and distributed the front end. Sometimes things work fine, but eventually the user gets the following error when clicking a command button or doing some other event...

I just had the following idea: Dim strOpenFilter as String If IsNull(CustomerNumber) = False Then OpenFilter = OpenFilter + " [CustomerNumber] = 'CustomerNumber'" End If etc Then OpenForm(frm_Results,,,strOpenFilter) Would this work or should I not waste my time?

I have a search form that allows users in input up to 5 fields to search for previous quotes: Customer Number Part Number Revision Number Quote Number Request For Quote Number The results are displayed in a List Box. If the user double clicks one the results, the record opens up by passing...

There would be problems though if the location of the file was ever changed correct?

Our IT staff would prefer to go in a different direction. Would what I propose work? If the size limit ever got breached, we would convert the database to SQL, but would like to delay that as long as possible.

I designed a database that stores information about a part, then on a seperate form, allows the user to create a quote of that part. We now see the need to attach files at the part information level. There will be three separate fields to attach the files. These files will almost always be...

I have set up a database and thus far only set variables at each form, however, now I see the need to set these variables up at the database level. I am having issues though. For example, I have a Search Form. When the user searches and finds right customer, they can double click it and open it...

I am trying to use the Dlookup function but am running into some issues when I try to use multiple criteria. I have a table that has the a price for a given range of thicknesses. I want the Dlookup to pull the price from the correct range. The ranges are defined by two fields, LowThickness...

I have a multiple item form that displays multiple items and allows the user to edit these items from one form. There is a combo box which includes the value "Other". When this is selected, I would like a text box/label to appear for the user to specify what the Other is. However, when I...

I guess my goal is to display both customer number and customer name at the top after the user makes a selection. What would be the best way to do this then? Here is what I'm thinking but I'm not sure exactly how to do this: 1. Create a query that shows Customer Number and Customer Name...

I have a combo box for CustomerNumber that is a lookup from another field. When the user clicks on the down arrow, it shows CustomerNumber (the primary key) and in the next column CustomerName. However, when the user selects one, it only shows the Customer Number in the combo box display. Is...

This is what I'm trying right now: Dim SelectedPartNumber As String Dim SelectedRevisionNumber As String Dim SelectedCustomerNumber As Integer SelectedCustomerNumber = Me.SearchResults.Column(0) SelectedPartNumber = Me.SearchResults.Column(1) SelectedRevisionNumber =...