I have a table with numerous customers and their transactions entered as transactions per row.
I wrote a query that I use to select a customer so I can see just their transactions. That is making their customer number the criterion for the query. What I want to do is be able to input the customer number once I start the query so I don’t have to write many queries for each customer.
Hi, can you attach a example_file for understand better the problem ?
You can use a parameter query to do this.
In the criteria enter :enterID
That is a colon followed by any text WITHOUT SPACES.
The SQL will look like SELECT “Table1”.*, “Table1”.“ID” FROM “Table1” WHERE “ID” = :enterID
When you run this query it will bring up a prompt with enterID and a box to enter the required customer ID.
Ok can I use this in a report? That is what I really need to do. At them moment I have created queries for each customer number and then use that query to create the report. I have over a hundred customers and this is real cumbersome. What I am trying to do is print a report for each days transactions in a table and the report will be just for the customer I want the report for. Each transaction in the table has the customers number associated with who the transaction was for.
I want to run the report and input which customer and which date the transactions I want reported are for. Using the current days date is fine so that could be auto and does not have to be a input.