Go Back   Access World Forums > Search Forums

 
Showing results 1 to 17 of 17
Search took 0.01 seconds.
Search: Posts Made By: Harper
Forum: Tables 01-22-2018, 09:44 PM
Replies: 21
Views: 1,067
Posted By Harper
Re: Table Design Advice

I need the database to tell me things like: how often a foreman and manager worked together. I just need the database to store these attributes for each team.

How would I pull the notes without...
Forum: Tables 01-21-2018, 08:24 PM
Replies: 21
Views: 1,067
Posted By Harper
Re: Table Design Advice

Hi all! I completed the relationship tool. I made the database as a self-learning tool. How'd I describe it...it's used to help a home construction company to track the attributes of its different...
Forum: Tables 01-17-2018, 09:34 PM
Replies: 21
Views: 1,067
Posted By Harper
Re: Table Design Advice

I used auto-number primary keys in each table and changed foreign keys in tables. Does it look OK?

I made one table for numerated fields "bonus" and "notes," but wouldn't I still need numerated...
Forum: Tables 01-15-2018, 09:38 PM
Replies: 21
Views: 1,067
Posted By Harper
Re: Table Design Advice

Hi all!

I followed plog's advice #1 in making 1 table for manager and foreman. I'm a little confused on how to establish a relationship with the Master table?
Forum: Tables 01-09-2018, 10:37 PM
Replies: 21
Views: 1,067
Posted By Harper
Table Design Advice - Yes/No & Notes!

I created this basic database for self-learning and have stumbled on whether "Yes/No" and "Notes" fields should be individual fields in the "Master" table, or reside in their own tables as yes/no...
Forum: Queries 12-17-2017, 07:07 AM
Replies: 8
Views: 493
Posted By Harper
Re: Crosstab Query - Concatenate Rows & Columns

Hi Pat! I have 2 questions:

1. Is the purpose of the Nz function to return Table1.Flavor if Table2.FlavorGroup is null?

2. If there's a flavor, like Sherbet, that hasn't had any sales, then it...
Forum: Queries 12-10-2017, 09:18 PM
Replies: 8
Views: 493
Posted By Harper
Re: Crosstab Query - Concatenate Rows & Columns

Hi Galaxiom/Pat,

I got the query to work the way I want it to work. The way I'm doing it, left or right join yields the same result.

I think I understand what Pat is saying about using the...
Forum: Queries 12-05-2017, 08:59 PM
Replies: 8
Views: 493
Posted By Harper
Re: Crosstab Query - Concatenate Rows & Columns

Thanks Galaxiom! Sorry, I'm not sure what you mean by "derive a field." I added screenshots of crosstab query and desired results.
Forum: Introduce Yourself 12-05-2017, 08:56 PM
Replies: 5
Views: 220
Posted By Harper
Re: Helloooo!

Thanks for the tip and warm welcome!
Forum: Introduce Yourself 12-05-2017, 08:05 PM
Replies: 5
Views: 220
Posted By Harper
Re: Helloooo!

Yeah, I'm trying to post a link. I apologize if that's against etiquette.
Forum: Gaming 12-05-2017, 07:59 PM
Replies: 94
Views: 57,268
Posted By Harper
Re: What's the best/worst video game of all time?

best: super mario bros (NES)
worst: Turok (N64)
Forum: Gadgets 12-05-2017, 07:57 PM
Replies: 11
Views: 7,148
Posted By Harper
Re: Which tablet do you recommed?

another +1 for Surface Pro. Pricey, but super versatile.
Forum: Politics & Current Events 12-05-2017, 07:55 PM
Replies: 34
Views: 3,550
Posted By Harper
Re: North Korea - Fact or Propaganda

Their singular agenda of becoming a super power isn't going to happen with the majority of their population in hunger. That's a fact.
Forum: Sports, Health & Fitness 12-05-2017, 07:52 PM
Replies: 7
Views: 674
Posted By Harper
Re: Best help for depression

The question is: is it primary or secondary depression. Treatments are contingent on that.
Forum: Gadgets 12-05-2017, 07:50 PM
Replies: 48
Views: 28,246
Posted By Harper
Re: iPhone, is it worthit?

It's nice. But is it 1K nice? For 1K, I'd expect a shatterproof phone.
Forum: Introduce Yourself 12-05-2017, 07:46 PM
Replies: 5
Views: 220
Posted By Harper
Helloooo!

Greetings from the Midwest!

I hear that this is the best Access forum. That's why I'm here, so I can take my Access dabbling to the next level. :)
Forum: Queries 12-05-2017, 07:42 PM
Replies: 8
Views: 493
Posted By Harper
Crosstab Query - Concatenate Rows & Columns

I have one table (Table1) in a crosstab query. I'd like to combine the values of rows "Strawberry" and "Blueberry" into 1-row called "Berries." And I'd like to combine the values of date columns...
Showing results 1 to 17 of 17

 
Forum Jump



All times are GMT -8. The time now is 04:13 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World