Bring Table value in Query Criteria

[raj08536]

I want to bring 1* in the criteria on my query

It's not working. It ask me

what I need to change here to bring 1* automatically?

Thanks

 

[raj08536]

Or what i need to make change on this line

WHERE (((SFRGLTotals_202201_01.SCODE)=[Prop#].[Prop]));

 

[Joe4]

Have you actually added the "Prop#" table to your query?

 

[raj08536]

Have you actually added the "Prop#" table to your query?

No I didn't

 

[Joe4]

You need to do that.

If there is only one record in your "Prop#" table, then you do not need to worry about doing a join between the table, as the Cartesian product of records will just result in the number of records in the other table (before the filter is applied).

 

[raj08536]

It worked without joining.

Thanks a lot.

How can I only get records start with 1 only (right now I use 1* and it gives me any records which has 1?

 

[raj08536]

It worked without joining.
View attachment 75928

Thanks a lot.

How can I only get records start with 1 only (right now I use 1* and it gives me any records which has 1?

Found it. I added :*" in front on my criteria. Alll good.

 

[raj08536]

One more question: I am running Append query to different Table based on starting number e.g. 1* data will be appended to Prop1 and 2* will be appended to Prop2. I will have 10 tables. Can I somehow have an option to choose which table data will be added on the run of query?

 

[Joe4]

One more question: I am running Append query to different Table based on starting number e.g. 1* data will be appended to Prop1 and 2* will be appended to Prop2. I will have 10 tables. Can I somehow have an option to choose which table data will be added on the run of query?

Possibly, if you do it all by VBA instead.
But that would be a new/different question.

 

[raj08536]

Ok. Thanks for your help.