Search results

Correct, thats exactly what I need to do and every friday will reset to the current week as same, Start Saturday and End Friday of the current week.

I did that PS. "today" was the variable I used to test it out. Replace it with your date field's name or use Date(). I replaced it with the Field name and even with Date() and still gave me date type mismatch in criteria expression error I did these...

SELECT Count(*) AS TotalParts, [IAAIMS DATA ENTRY TABLE].Part, [IAAIMS DATA ENTRY TABLE].PassFail FROM [IAAIMS DATA ENTRY TABLE] WHERE ((([IAAIMS DATA ENTRY TABLE].[Date Started])=DateAdd("d",1-Weekday(DateAdd("d",1-Weekday("today",6)+1,"today")),DateAdd("d",1-Weekday("today",6),"today"))))...

Maybe I'm stupid or some but it gave me a date type mismatch in criteria expression. I'm sorry I'm soo new to this. :(

lets say, if Im unable to create the report today or on the weekend, will this criteria still create the report based from last [starting] Saturday and [ending] Friday? The criteria I have I can do that but with the only problem that I need to wait until tomorrow to create the report based on...

Hello World, I need to include in my reports all records been done from Starting day [Saturday] Ending day [Friday] = (today for example) I have it as this Between Date()-(6+Weekday(Date(),7)) And Date()-Weekday(Date(),7) The problem I have is that for example today, I make the report and...

I been reading about looping, can I loop those records to show on the email as total, count for that record? What will be the easiest approach to make this happen? Thanks in advance for the very needed help

Can someone here in this great forum please help me? 🙏

Yeah lets hope someone can really help me with this. :( Thanks sooo much for your time and tips Gasman

Can you please give an example using my code in first post? :( Im just sooo new trying to lean this stuff because I had this made for me a year ago. Now that the guy is no where to be found Im trying to learn the code to maintain the database myself.

Sorry, didnt shared the code because is the first code shared in first post. as for the values they come from 2 queries Query for IAAIMS SELECT Count(*) AS TotalParts, [IAAIMS DATA ENTRY TABLE].Part, [IAAIMS DATA ENTRY TABLE].PassFail FROM [IAAIMS DATA ENTRY TABLE] WHERE ((([IAAIMS DATA ENTRY...

is in the first code above

From the dashboard Form with all the graphs and reports.

Hello Gasman, I tried that but I get a syntax error on every line I edited. I'm sorry but I'm very new to VBA and Access. I looked your attachment and it gave me brainfarts. :eek:

***This is the IAAIMS module I'm trying to get that data to populate IAAIMS Report above Option Compare Database Private Sub Form_Load() GetData End Sub Private Sub Mech_LEF_Total_Parts_BeforeUpdate(Cancel As Integer) 'SELECT Count(*) AS [Total Parts], [IAAIMS DATA ENTRY TABLE].Part 'FROM...

Hello everyone, So after couple of hrs of reading similar problems to mine in this forum I still haven't been able to find something close enough I can try. (Sorry I'm new to Access) What I'm trying to do is get some values from another Module to fill the Email Body using values from 2 other...

Hello world, New to MS Access and maybe have a question or 2 if cant find the answers on my search results. Just happy to find this Forums :)