Recent content by foshizzle

  1. F

    Hide report control if date eq

    ok - ive found a work around. thanks anyway!
  2. F

    Hide report control if date eq

    I've tried both of these in the detail section of the report with no luck. I don't get an error or anything. I've tried placing a message box to pop up as well to verify something is happening using "MsgBox Me.txtTransactionDate.Value" but nothing happens.
  3. 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...
  4. F

    Append only new records to table

    Hi Doc, these two tables obviously have two different PKs. In this case, the PK in tableA would never be in tableC. I was confused of why I should bother with the PK fields. At any rate, I got it working with your advice using this: INSERT INTO tblAirlineTransactions ( TransactionID...
  5. 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...
  6. F

    Lookup table confusion

    i think so? Should I then be making the forms based on the tables, better than queries?
  7. F

    Lookup table confusion

    Thanks dbguy - the form does indeed still work. From what I can tell, you only changed the Display Control on the Lookup tab from Combobox to Text Box. Is this correct?
  8. 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...
  9. F

    Need current and previous data for final report

    Ah, sorry; I get it now.. I think I've gotten the two queries to work for the one report but I wont know until Tuesday when I go back in. Thanks so much for your help!
  10. F

    Need current and previous data for final report

    Hi Arnel: so you got the previous ActualBal to show on the Begin Bal column, but I need the remainder of the columns to remain as-is. i.e., If you run the report for 5/1/21, the Begin Bal column should show the ActualBal for 4/30/21; the remaining columns need to be for 5/1/21. See markup below.
  11. F

    Need current and previous data for final report

    Hi - I didnt provide the report in the original sample because its the same data in the query. However, I've attached the report to this new sample DB for your reference here. I see your confusion because Its the same problem I had when trying to figure this out.. In summary, this is a...
  12. F

    Need current and previous data for final report

    Here is a sample: The top query was run for 4/30/21. The bottom query was run for 5/1/21. (We don't yet have 5/31 data since its still May). If I were to run a query for 5/1 (or 5/31), the DailyBal should be the end of the previous month's (4/30/21) ActualBal. Note, this new value has nothing...
  13. F

    Need current and previous data for final report

    Thank you for your response. I just cant figure out how to get both previous values for two different dates in the same query. Attached is a sample, following the instructions in your post. I've been using dates 4/30/21 and 5/1/21 for testing. Thank you
  14. 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...
  15. F

    Reset calculated value to 0 after each month

    Two questions: If I include a WHERE, wouldn't that still keep the gain/loss value for that point in time? In reference to your proper joins statement; are you referring to the qryRGainLoss15Report? I figured this one out on my own and as you can probably tell, I'm not a DB guy; it took me 15...
Top Bottom