Search results

Thank CJ & Gasman. I got it working, on the individual queries it was sorting correctly but between the union and crosstab it was getting messed up, so I added an expression field to the original 3 queries with CJ's format e.g. yyyy-mm so that the crosstab query would have a field to sort off...

Thanks Gasman, I figured it was something simple I was missing. they are showing the month names now but as you pointed out they arent in order by months its Alphabetical LOL

Thanks CJ, I have tried that but keep getting errors or it becomes an input IE when I tried the code below it gives me a pop up to input mm and then one for yyyy, I was trying to get it to show "Nov 2024" instead of 11-2024 to make it cleaner and so that it can sort by oldest to newest but cant...

That worked great, thank you for all you help. On to making it into a report.

Hello, I hope someone can point me in the right direction. I have a DB that has a Table "Submittals" that has my data. I need to be able to create a report from a query that shows me the number of submittals, the number due back and the number of responses by month. I am able to create separate...

Hello, I hope someone can stir me in the right direction. I have a table that has a record that uses a Submittal date. I need to record a due date based on working days. So if I have a record that was created on 11/7/2024 and is due back 15 working days later ( 12/3/2024) so I need to create a...

Arnelgp, thank you so much for the help. This makes total since when I see how you broke it out. Big thumbs up...

Hello wonderful people. I am scratching my head trying to figure this one out. I have a form "Inventory" that is based on a table "Inventory" that stores Part Details (Part number, description, supplier, etc). I have a second table that stores transactions for a given part (IE addition, removal...

Ok, that got me closer. It works for the >100 and the >32 it shows those correctly now but the <32 is still showing the wrong image. Here is the code I used from arnelgp Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) [img36].Visible=False [img32].Visible=False...

Hi, Thanks for the replies I tried this and its showing all of the images. Is it because I dont have a False value? If Me.AvgOfTemp < 32 Then img40.Visible = True ElseIf Me.AvgOfTemp > 100 Then img36.Visible = True Else img32.Visible = True End If The...

Hi, I think im doing this wrong and Im hoping someone can help me. I have a report that I want to have an image show depending on the value of a field. ON the report I have a field called AvgOfTemp and what I need is if the temp is greater the 100 show img36 if the temp is between 32 and 100...