Access Database Reports

%3CLINGO-SUB%20id%3D%22lingo-sub-1982033%22%20slang%3D%22en-US%22%3EAccess%20Database%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1982033%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20some%20help%20with%20a%20report%20that%20I%20have%20created%20in%20Access%20Database%20which%20I%20built.%3C%2FP%3E%3CP%3EI%20have%20some%20unique%20values%20in%20the%20column%20of%20the%20report%20that%20came%20from%20a%20table%20of%20data%20for%20the%20%22Number%20of%20Children%22.%26nbsp%3B%20The%20unique%20values%20are%20as%20follows%3A%3C%2FP%3E%3COL%3E%3CLI%3E%26nbsp%3BIf%20there%20are%204%20boys%20and%202%20girls%2C%20I%20entered%20the%20data%20as%204B%2C%202G%3C%2FLI%3E%3CLI%3ENow%20my%20boss%20wants%20to%20know%20how%20many%20boys%20and%20how%20many%20girls%20which%20equal%20the%20number%20of%20children%20each%20military%20vet%20has%3F%3C%2FLI%3E%3CLI%3EI%20have%20tried%20everything%20based%20on%20my%20knowledge%20and%20with%20Microsoft%20Office%20Support%20not%20supporting%20Access%20Databases%2C%20it%20has%20become%20very%20frustrating%20to%20figure%20stuff%20like%20this%20out.%3C%2FLI%3E%3C%2FOL%3E%3CP%3ECan%20anyone%20help%20me%20with%20figuring%20this%20out%20in%20my%20report%20or%20even%20in%20the%20query%3F%26nbsp%3B%20There%20are%20over%20thousand%20records%20and%20it%20is%20too%20late%20to%20change%20the%20data%20at%20this%20point.%26nbsp%3B%20I%20am%20attaching%20the%20query%20exported%20to%20Excel%20and%20the%20report%20exported%20to%20a%20*.pdf%20file.%26nbsp%3B%20Thank%20you%20so%20much.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1982033%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EReport%20Summing%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I need some help with a report that I have created in Access Database which I built.

I have some unique values in the column of the report that came from a table of data for the "Number of Children".  The unique values are as follows:

  1.  If there are 4 boys and 2 girls, I entered the data as 4B, 2G
  2. Now my boss wants to know how many boys and how many girls which equal the number of children each military vet has?
  3. I have tried everything based on my knowledge and with Microsoft Office Support not supporting Access Databases, it has become very frustrating to figure stuff like this out.

Can anyone help me with figuring this out in my report or even in the query?  There are over thousand records and it is too late to change the data at this point.  I am attaching the query exported to Excel and the report exported to a *.pdf file.  Thank you so much.

0 Replies