Search results for query: *

If I understand correctly, you're saying to... 1. download 180 days, append to tblMR_Ex180 2. frmMR_Ex filtered to last 24 hours (>= 07:00Z yesterday) 3. sfmMR_ExHist all 180 days, linked to main by Tail and ATA 4. apdMR_ExHist appends PK of frmMR_Ex and PK of selected records on sfmMR_ExHist...

Since both forms are basically using the same data (both tblMR_Ex and tblMR_Ex180 are built from the same downloaded .txt file), is this the best to set up my tables? 1) tblExDwn linked to txt file containing 180 days history 2) Append from tblExDwn the new events for last 24 hours to...

I've reviewed hundreds of threads looking for some ideas on this. So far all I've seen is using a checkbox as the criteria for the records to be appended. Is this the best method? If so, what would be the best way to clear those boxes after the append? If the user goes to next record (and it...

[purple]I've got a bunch of stars I'd love to give to somebody![/b] For anybody looking for info on appending only selected records from a subform, I've also posted that question in the Forms forum. Mike

I've posted this question as part of a bigger issue on the Other Topics forum thread 181-1341594. I haven't had any response there so I thought I'd post this sub-question here... If I have... tblMR_Ex: - MR_ExID PK - Tail - Date - ATA tblMR_Ex180: - MR_Ex180ID PK - Tail - Date - ATA...

Too much info? I'll try to break it down into smaller chunks. If I have... tblMR_Ex: - MR_ExID PK - Tail - Date - ATA tblMR_Ex180: - MR_Ex180ID PK - Tail - Date - ATA tblMR_ExHist: - MR_ExID FK - MR_Ex180ID FK frmMR_Ex – recordsource is tblMR_Ex sfmMR_Ex180 – recordsource is tblMR_Ex180...

I’ve spent months trying to figure out how to accomplish what seemed like the easiest of objectives, but every time I think I’ve got it figured out I seem to hit another major stumbling block. So, before I throw it all away and forever deem myself as a failure, I’m hoping someone here can take a...

ZmrAbdulla, Great site, thanks!

PHV, I'd like to get it as hours... For example 100:45 would be 100.75 I tried CDbl(Val(UTILDWN!FltHrs) but no luck. Thanks for the help! Mike

Thanks to both of you but I still need to add the minutes. The Val() is only returning the Hours. Mike

This is close to what you're looking for SELECT DateSerial(Year([COLOR=qry]![date]),Month([COLOR=qry]![date]),1) AS MonthDate, [COLOR=qry].color, Sum(Nz([COLOR=qry]!qty)) AS SumOfQty, FROM [COLOR=qry] GROUP BY DateSerial(Year([COLOR=qry]![date]),Month([COLOR=qry]![date]),1), [COLOR=qry].color...

I have alot of fields that capture time - flight hours, engine on-wing hours, time since overhaul, etc. They are formatted like hh:mm but the hour part is often 3-5 digits. I.e, 23756:21 I need to use this data to perform many types of calculations - utilization rates, sums, etc. The data is...