質問する

Bryverine's profile - activity

2017-04-29 22:37:38 +0200 バッジを受け取った  有名な質問 (source)
2017-03-09 04:07:34 +0200 バッジを受け取った  熱心な人
2017-03-08 14:49:55 +0200 バッジを受け取った  学者 (source)
2017-03-08 14:49:34 +0200 コメント付き回答 Query all tables (some blank)

@Ratslinger ah, well I suppose the formatting was part of my goal of the report shown in my png attachment... so technically, no I guess I didn't specifically ask that. :/

Thank you for your help this is exactly what I needed. I appreciate all your help!

2017-03-08 06:26:27 +0200 コメント付き回答 Query all tables (some blank)

@Ratslinger OH MAN this was a great help! Next question (still part of the formatting report) is as follows: Can I display a cell dependent on the "RecordType". I.e. display "rate" instead of "cost" for "Labor". And final question: I made a cell that multiples qty and cost for each record type. How can i total all of these cells (per record) into one final cell in the RecordType Footer?

2017-03-06 04:03:35 +0200 コメント付き回答 Query all tables (some blank)

Great, I think that helps a lot! It's my first time using a database so I really appreciate the help.

The database will be for someone else with even less experience with databases so I was looking to make this a plug-and-chug kinda thing. I'll give it a try and see if this gets me what I needed. I'll be sure to mark as answered if it does!

2017-03-06 03:57:40 +0200 バッジを受け取った  サポーター (source)
2017-03-06 03:36:40 +0200 バッジを受け取った  卓越した質問 (source)
2017-03-05 15:26:13 +0200 質問に回答する Query all tables (some blank)

I'm so sorry, I think I figured it out! @EasyTrieve and @Ratslinger.

Here is the correct path for the .obd C:\fakepath\Example_Database_Invoice.odb

2017-03-05 13:57:30 +0200 バッジを受け取った  人気の質問 (source)
2017-03-05 07:56:11 +0200 質問に回答する Query all tables (some blank)

Thank you very much!

My current example database: C:\fakepath\Example_Database_Invoice.odb(/upfiles/1488696827520279.odb) Here's my vision: C:\fakepath\Example.png

2017-03-05 07:05:29 +0200 バッジを受け取った  生徒 (source)
2017-03-05 06:35:14 +0200 質問をする Query all tables (some blank)

Hello,

I'm making an invoice that has 5 different tables all related by an invoice_ID.

  1. Invoice
  2. Customer
  3. Labor
  4. Materials
  5. Rental Equipment

A typical report will have 1-3, but 4 and 5 can be optional. Ex.

  • A. My first invoice has 1-3 filled out and 2 items on 4 and 1 item on 5
  • B. My second invoice has only 1-3 filled out
  • C. My third invoice has 1-4 filled out.
  • D. My fourth invoice has 1-3 filled out and 4 items on 4 and 2 item on 5

I created a query that has all tables selected but only the rows with details accross all tables (A and D). How can I query all data from each table regardless of their contents?

My goal is to have (per invoice) all labor in a table, followed by all materials in a table, followed by all rental in a table.

Unfortunately, I can't attach any files so I can't give any example of what I'm looking for or what I have.