weilerdo67's latest activity

  • W
    weilerdo67 replied to the thread Combined Queries.
    Thank CJ & Gasman. I got it working, on the individual queries it was sorting correctly but between the union and crosstab it was...
    • 1752188011102.png
  • W
    weilerdo67 replied to the thread Combined Queries.
    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...
  • W
    weilerdo67 reacted to Gasman's post in the thread Combined Queries with Like Like.
    The format needs to be enclosed with "" Format(date1,"mm yyyy") Nov 2024 will sort after Dec 2024 if you do that, and Dec 2024 before...
  • W
    weilerdo67 replied to the thread Combined Queries.
    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...
  • W
    weilerdo67 replied to the thread Combined Queries.
    That worked great, thank you for all you help. On to making it into a report.
  • W
    weilerdo67 reacted to plog's post in the thread Combined Queries with Like Like.
    I would do a UNION that feeds a cross tab: 1. Make a simple query for each status. Be sure that all 3 queries have the same SELECT...
  • W
    weilerdo67 posted the thread Combined Queries in Queries.
    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...
    • 1752169776084.png
Back
Top Bottom