Recent content by JAKnudson

I have attached a sample.

My problem comes from using the aggregate totals for each day. It summarizes the days for me but it would let me use the result i another calculation. Every time I do, it hangs up the query until it finally times out and fails. I'm afraid that i will need to write my own aggregate function to...

Hello, I have a problem and from what I find on the internet I'm wondering if I want to do something that cant be done in Access. I am pulling data into a table from our AS 400 (curently monthly). This table has fields for date, department, Part number, Decription, quantity, and a code...

Hello, I have a table that is imported from our AS400. I delivers a transaction date as text in the format YYYYMMDD. I can't work with this and I need to convert it to a date value and then format it MM/DD/YYYY. I'm planing on this import happening automatically 1-3 times per day (TBD). I...

I got it. This just shows me how much I have to learn yet. I need to understand when to use Me! vs Me..

I moved the OpenArgs from the On Open event to the On Load event and it still won't write the value. If i manually type in the number, the relationship works as expected but for some reason I can't seem to make the OpenArgs work as I expect. There must be something I'm over looking. I don't...

I new to all of this and I tried to find what I need on other posts/forums but I can't seem to find anything i can use. What I'm doing is opening a second form from a main form. When the form opens I want to write the value of the main form PK to the control on the second form. I have...