Search results

I searched up cascading combo boxes and it did exactly what I needed. It took a bit to make them work right, but in the end, perfect. Thanks theDBGuy!

Ok Thanks

I have form that has a Customer field which is a combo box. Further down the form, I have Combo box named Coding String. This form is used to fill a table, Trip Tickets. The Customer field is pulled from a list created by the Vendor List table. The Row Source coding is SELECT [Vendor...

Ok, made a minor change in my query and report and it works great now!!! Thank you for all of your help. I really appreciate it.

Do I bring that in via the query?

I actually stumbled onto the solution by tying the PA and the Month together. That ended up giving me a result just like above, which I manually created in EXCEL. Now my next question. When I create a report, I group my month, but the report shows all the months in alphabetical order and I...

It should look something like this. Monthly Totals Monthly Totals PA CountOfLog In CountOfLog Out SumOfActual Dollar Amt Month Log out Year AL 12 26 $676,336.79 JUNE 2021 AL 8 8 $132,365.33 JULY 2021 AL 2 5 $343,690.75 AUGUST 2021 EC 10 52 $2,216,192.66 JUNE 2021 EC 38 24...

Yes, there would be different PAs each month.

I have a total of 8 purchasing agents and I need their total log ins, log outs, and total dollars per month. When I create my report it will be grouped by Month and I will have to add a conditional to the query to ask for the month of the report to be run.

qryFinalCount qryFinalCount TotalLogin TotalLogOut TotalAmt LogMonth 81 3 $365,247.25 April 12 25 $882,363.75 August 73 47 $3,478,317.85 July 29 161 $32,805,803.83 June 59 3 $389,878.00 March 13 7 $164,716.92 May This is the result of the qryFinalCount and it looks great. Now I...

I changed the names of the queries and now it works. Now can we add the PA to the queries?

Still getting the syntax error in the From clause

Ok, I had to put brackets around the table name, but it counted just fine. Did the same with Login Out and it worked, but when I create the total query, I get: Syntax error in FROM clause. Here is the coding. SELECT [qrylog in.TotalLogin], [qrylog out.TotalLogOut], [qrylog out.TotalAmt]...

Here is my query and the error I am getting. SELECT FROM [2022 Tracker] SELECT Format(Log In, "mmmm") AS LogMonth, Count(*) AS TotalLogin FROM 2022 Tracker GROUP BY Format(Log In, "mmmm"); Error Message: The SELECT statement includes a reserved word or an argument name that is misspelled or...

The sum is based upon the log out month.

Log In PA Log Out Actual Dollar Amt 4/19/2021 AL 6/24/2021 $45,790.12 4/21/2021 AL 6/15/2021 $15,000.00 4/21/2021 AL 6/15/2021 $30,284.48 4/23/2021 AL 6/16/2021 $20,606.00 4/23/2021 AL 6/24/2021 $257,686.43 4/27/2021 AL 6/15/2021 $7,500.00 4/30/2021 AL 6/15/2021 $8,702.68...

I am looking for help with an Access database. I have a table With multiple fields, but I only need a few to create a report. The fields I have to use are Log In Date, Log Out Date Actual Dollar Amount, and Agent. Through two queries, I have created a Log In Monthly Count query which has...

I work for a state agency and have been tagged the Access builder, but I still need help and hope to get some here.