Choosing which 2 items from over 9000
- Thread starter pwicr
- Start date
In high-level terms, your report should be based upon a query that returns only the two vehicles that you want in the report.
Since you will have multiple criteria (2 vehicles), you'll have to design a form that will accept whatever you're using to specifically identify the vehicles and then pass those values to the query.
If this is a one-off sort of thing, it might be easier just to code the query to return the two vehicles you want and then run the report from that.
Since you will have multiple criteria (2 vehicles), you'll have to design a form that will accept whatever you're using to specifically identify the vehicles and then pass those values to the query.
If this is a one-off sort of thing, it might be easier just to code the query to return the two vehicles you want and then run the report from that.
I have a query and so far it's working ok. I'm having some troubles with information showing up in the report and can't for the life of me figure out why but I'm working with it.
My Trim$ isn't working. Works in my single unit report but not in my double unit report...
Help??
My Trim$ isn't working. Works in my single unit report but not in my double unit report...
Help??
sorry for not being clear.
my report IS generating with all the information I want. What isn't trimming is my model & series (Excel being the model and TS being the series should trim to Excel-TS...it works in my report that only has one unit in it but doesn't work with the report that has two units. I've tried Trim$([tblMODELS]![MODEL]&"-"&[tblMODELS]![SERIES]) for one box and
Trim$([tblMODELS_1]![MODEL]&"-"&[tblMODELS_1]![SERIES]) for the second but to no avail...
does that make sense???
Trim$
I understand what you're saying but am not clear about what you're trying to do with two tables. Not sure why there is a tblModels and tblModels_1.
Does your original one record report run from a table or a query? It might be working because your record source in that report is a table(s) but the new one's record source is a query.
I'm thinking that your trim should be referencing the report's record source, which is the query.
Does your original one record report run from a table or a query? It might be working because your record source in that report is a table(s) but the new one's record source is a query.
I'm thinking that your trim should be referencing the report's record source, which is the query.
They both run from different queries.
The two unit report (generated from a query) is pulling two different records from the same table. My understanding is that I need two tables so it can pull the information for Unit #1 from the original table and Unit #2 from the duplicate table....
not sure how to explain it...
I've tried having the query name in front of the each item in the trim but it errors on me.
The two unit report (generated from a query) is pulling two different records from the same table. My understanding is that I need two tables so it can pull the information for Unit #1 from the original table and Unit #2 from the duplicate table....
not sure how to explain it...
I've tried having the query name in front of the each item in the trim but it errors on me.
There is something fundamentally wrong in your design. If the two records you want in the report are in the same table, then the query for the report should draw the data from one table.
