Search results

  1. F

    Hide report control if date eq

    Is it possible to hide a report control based on a date? On this report, I have two text controls in the report detail: txtTransactionDate and txtGainLoss I only want to show the txtGainLoss control if txtTransactionDate (report date) is the last day of the month. I'm not sure its possible...
  2. F

    Append only new records to table

    I'm running an APPEND query and trying to only insert records that do not yet exist. This query appends records from two different tables as follows: tblAirlineTransactions TransactionDate, AirlineCompany, IssueType, GallonsReceived tblGainLoss TransactionDate, AirlineCompany, IssueType...
  3. F

    Lookup table confusion

    I've heard and read over and over lookups are bad on tables. I'm still confused on the appropriate usage. I've attached a sample db here of my current db with 4 tables. tblAirlineTransactions - contains lookups for the three tables below. tblAirlines tblFuelProviders tblIssueTypes I've also...
  4. F

    Need current and previous data for final report

    First off, apologies as this is my 3rd attempt at getting this report right. Please allow me to start fresh here: I now have the following queries: qryRMonthlySum2_DailyBal - uses data from qryRMonthlySum3_Compare to obtain daily transaction balance (DailyBal) for each airline. The DailyBal is...
  5. F

    Reset calculated value to 0 after each month

    I am using qryRMonthlyGainSum4GainLoss (below) to obtain the Actual Balance as follows: ActualBal: Nz(([Total]+[AirGainLossNZ]),0) Another value for gain/loss, called AirGainLossNZ, is calculated in a separate query as shown below in qryRGainLoss15Report. Somehow I need to reset the value for...
  6. F

    Obtain previous value from query

    I have the following query which will run on any given date. How could I obtain the previous value for ActualBal? i.e., if the report date is run for 5/1/21, would could I get the ActualBal for 4/30/21? SELECT qryRMonthlySumTrans2.TransactionID, qryRMonthlySumTrans2.TransactionDate...
  7. F

    Need previous month's value rolled into new month

    I have a report which shows a summary of current month's inventory and transactions.I need to roll the previous ACTUAL BALANCE into the next month's report which will become the new month's BEGIN BALANCE. These numbers do not appear to be updating.. Hoping someone can point me in the right...
  8. F

    Solved If Then Combobox based on value

    I have a combobox on a form which is used to build report criteria. The user selects a customer from the combobox, enters a begin/end date then a report is opened based on those values. The report is based off a query and shows only the customer selected in the combobox. I've recently been asked...
  9. F

    Crosstab report error

    Im trying to build a cross-tab report with dynamic column headings. I've download various examples and am trying to import the code from a report in an example database into my own report. I've named the textbox controls for all column headings and detail rows to match that of the example. The...
  10. F

    Solved Nz from subquery

    This should be an easy one but my query is either showing a blank or producing an error when i try to use it for my report. I'm trying to pull two values from an existing query, then replace any null value for AirGainLoss with a 0. SELECT qryRGainLoss15Report.AirlineCompanyLookup...
  11. F

    Solved Get date of first day of month from another control

    I have two unbound text box controls on a form; txtStartDate and txtEndDate. I would like the user to only enter a value for txtEndDate. How would I get the date for the first day of the month (based on the date in txtEndDate) and populate it in txtStartDate? I believe the below gets me the...
  12. F

    Solved Query between two dates on different forms

    I have a report based off 15 small queries. Some of those queries accepts a start and end date entered on a form to find transactions between a given time. I would like to re-use those same queries for a new report without having to make all 15 of queries again. The problem is, those queries...
  13. F

    Advice on progress meter

    I have a report that is executed from a button on a form. The report is not necessarily slow; it takes 10sec to complete. There are 15 queries that run to get the data necessary for this report. From what I've read, it doesn't seem possible to add a true progress bar. For this case, are there...
  14. F

    Sum column for last date of transaction within specified period

    I have an existing query of transactions where fuel has been received by any particular airline for any given date. An airline can receive multiple fuel transactions per day. I need to find the SUM of fuel received for each airline; only for the very last day they received it, within the given...
  15. F

    Solved DSum Query does not start at 0

    For troubleshooting purposes, I have made two queries looking at the same table. One query 'RunGalIss' accurately uses DSum to total gallons issued for a particular group within a specified timeframe. However 'RunGalRcv' is setup the exact same way but starts with a negative value instead of 0...
  16. F

    Solved Join queries-reference group by date

    I have two queries which are used to get the SUM of previous record groups and the group prior to that using TOP 3 and TOP 2. (I need the 3 most current groups of records). Now I need to reference those SUMs (for each group/airline) for additional calculations; I'm guessing through another...
  17. F

    Running sum on Query

    I was wondering if anyone could point me in the right direction: I've added two new queries (based off one original query) in order to get different totals. The last step is to get a running total from certain fields. Surely I'm doing this the hard way but the general hierarchy is...
  18. F

    Solved Requery main report to update referenced control

    I have a main report with multiple sub reports. The main report references bound textbox controls on the various subreports with the Running Sum option set to Overall. (There is nothing in common between the various subreports). Problem The controls on the main report display the first/top...
  19. F

    Solved Open main and subreport to date on form

    I've been using Allen Browne's Method 2: Form for entering the dates on my reports. This works fine. I have a new report with multiple subreports. Is it somehow possible to link them all to the same date entered on the one (single) form? This is the form code to accept the date and open the...
  20. F

    Solved Help w/ query on previous value

    I have a similar code working for a different query but i cant get this one to match up. I'm trying to obtain the previous value for fields "GallonsReceived" and "GallonsIssued" but the code is literally giving me the value of the "...PriorValue" fields instead of the original, non-calculated...
Top Bottom