By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 975 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

Query Assistance

P: 4
I am creating a query and need to be able to pull 3 different Invoice numbers up to populate a report. Does anyone know how to make this happen?
Dec 22 '06 #1
Share this Question
Share on Google+
5 Replies


sashi
Expert 100+
P: 1,754
I am creating a query and need to be able to pull 3 different Invoice numbers up to populate a report. Does anyone know how to make this happen?
Hi there,

You need to be more specific when delivering problem statement. Are these invoice number from same table? Are they stored in different field? Take care.
Dec 24 '06 #2

nico5038
Expert 2.5K+
P: 3,072
Normally there's a field indicating the rows that can be selected.
E.g. when selecting invoices, those having a shipped date being empty.

When you want multiple numbers in your query use the IN clause like:

select * form tblX where invoicenumber in ( 1, 33, 456);

Nic;o)
Dec 24 '06 #3

P: 4
Hi there,

You need to be more specific when delivering problem statement. Are these invoice number from same table? Are they stored in different field? Take care.
I am creating a report that would look like a truck manifest. I am pulling information from our order entry system. I would need this report to populate 3 different lines of information (using 3 different Sales Order numbers) yes the invoice number is in the same table, no they are not stored in different fields.

first box would be S/O then all information need for the report for that #
Second box would be New S/O # and all information needed for the report for that #
Third would be a New S/O # and all information needed for the report for that #

I hope this helps. Thanks for responding.

Jhona
Dec 26 '06 #4

nico5038
Expert 2.5K+
P: 3,072
I would create a "tblTruckManifest" tabel that records the manifests produced.
Using a form for the TruckManifests with a subform based on a new created tblTruckManifestSalesorder relation table with the tblTruckManifest ID and the SalesID's selected from the order system,.you can have the suer build the manifests from he orders. When one SO will only be used in one manifest you can exclude the already used SO's when the user creates a new manifest.

For the reporting you can use the SO's from the tblTruckManifestSalesorder relation table that have the TruckManifest ID.

Getting the idea ?

Nic;o)
Dec 26 '06 #5

P: 4
I would create a "tblTruckManifest" tabel that records the manifests produced.
Using a form for the TruckManifests with a subform based on a new created tblTruckManifestSalesorder relation table with the tblTruckManifest ID and the SalesID's selected from the order system,.you can have the suer build the manifests from he orders. When one SO will only be used in one manifest you can exclude the already used SO's when the user creates a new manifest.

For the reporting you can use the SO's from the tblTruckManifestSalesorder relation table that have the TruckManifest ID.

Getting the idea ?

Nic;o)
Yeah, thanks!
Dec 27 '06 #6

Post your reply

Sign in to post your reply or Sign up for a free account.