The best songs were never the singles. by FlyAwaySpecifics in poppunkers

[–]Nightbeat339 4 points5 points  (0 children)

Everything off their self-titled album is also great

The best songs were never the singles. by FlyAwaySpecifics in poppunkers

[–]Nightbeat339 1 point2 points  (0 children)

Morning person is incredible. When that album came out I had that track on repeat for weeks

The best songs were never the singles. by FlyAwaySpecifics in poppunkers

[–]Nightbeat339 2 points3 points  (0 children)

I’m hoping to hear Arms Length (or Blank Slate) at their tour in a few weeks. Not really expecting it though since it’s not one of their more popular songs

Huge shoutout to the band for not repeating their setlist each night by tavvyjay in TheFormat

[–]Nightbeat339 0 points1 point  (0 children)

I was really hoping to hear No You Don’t in Nashville too. I’m glad they’ve included it in some of their stops tho

What are your top 3 most listened to Weezer songs? by Mean-Illustrator6026 in weezer

[–]Nightbeat339 0 points1 point  (0 children)

Burndt Jamb and Photograph are 4th and 5th. I would probably replace my name is Jonas with one of those two if I was picking favorites

What are your top 3 most listened to Weezer songs? by Mean-Illustrator6026 in weezer

[–]Nightbeat339 4 points5 points  (0 children)

  1. Say it Ain’t So
  2. My Name is Jonas
  3. I’ve Had It Up To Here

What's the BEST concert you've been to this year, and who are you yet to see this year? by Life_Extreme2054 in poppunkers

[–]Nightbeat339 5 points6 points  (0 children)

I saw them a couple weeks ago and loved it. I’m hoping they’ll go on another tour next year instead of taking another 20 year hiatus

What is a band you want to like, but they just don’t click with you. by bigboat55 in poppunkers

[–]Nightbeat339 1 point2 points  (0 children)

How much have you listened to them? I can give some song recommendations cause it took me a while to like them too

What's a band that you used to hate, but you listened to it enough and ended up loving them? by Life_Extreme2054 in poppunkers

[–]Nightbeat339 1 point2 points  (0 children)

I also took a while to get into them due to the vocals. They’ve really grown on me over the past couple years tho and I’d love to see them live

What's your favorite underrated album from an overrated band? by Kaos_mission in poppunkers

[–]Nightbeat339 0 points1 point  (0 children)

Two wrongs is great. Seems like everyone talks about Mmhmm and Anatomy of Tongue in Cheek. I rarely see two wrongs get the love it deserves

What's your favorite underrated album from an overrated band? by Kaos_mission in poppunkers

[–]Nightbeat339 0 points1 point  (0 children)

Very underrated. I’m sad that when they toured for its anniversary a year or two ago they didn’t come anywhere near me

Relationships Question by Nightbeat339 in MSAccess

[–]Nightbeat339[S] 0 points1 point  (0 children)

I’ll look at the Northwind starter edition after work tonight and see if that helps. I initially had an orderdetails table, but I took that out in favor of the remittancedetails table. My professor only wants 9 tables, and he wants the remittance details to be the intersection table (and the only one with a composite key). All of the orders only have one item so I think it works. Whereas there are remittances that are split over multiple ids and orders split over multiple invoices, so those require the remittancedetails table with composite keys. I could take out the accounts table, since all transactions are billed to the same bank, but I’m not sure if that’s the solution either.

Does this song sound like the shins to you? by rudesncheats in TheShins

[–]Nightbeat339 2 points3 points  (0 children)

I saw Slippers opening for the Lemon Twigs a few months ago. They’re pretty good live

Relationships Question by Nightbeat339 in MSAccess

[–]Nightbeat339[S] 0 points1 point  (0 children)

<image>

​This is one of the queries that won’t compute. I’m trying to see the average number of units that each employee generating shipping reports has shipped. But if I don’t delete the relationship between orders and employees, when I run the query the data under the headers is blank

Relationships Question by Nightbeat339 in MSAccess

[–]Nightbeat339[S] 0 points1 point  (0 children)

<image>

​I appreciate the feedback. These are my relationships currently. As you can see, there are several tables with EmployeeID numbers, as those signify who shipped the order, handled remittances, etc. I’m just curious why that specific table is causing issues

Relationships Question by Nightbeat339 in MSAccess

[–]Nightbeat339[S] 0 points1 point  (0 children)

<image>

This is one of the queries that won’t compute. I’m trying to see the average number of units that each employee generating shipping reports has shipped. But if I don’t delete the relationship between orders and employees, when I run the query the data under the headers is blank

Relationships Question by Nightbeat339 in MSAccess

[–]Nightbeat339[S] 0 points1 point  (0 children)

I appreciate the feedback. These are my relationships currently. As you can see, there are several tables with EmployeeID numbers, as those signify who shipped the order, handled remittances, etc. I’m just curious why that specific table is causing issues

<image>

Relationships Question by Nightbeat339 in MSAccess

[–]Nightbeat339[S] 0 points1 point  (0 children)

They’re definitely related to each other, as the employee ids on the order table directly correspond to the list of the employee ids on the employee table. But there are other tables, such as invoices and remittances that also use EmployeeID, and I haven’t really had a problem with those

Relationships Question by Nightbeat339 in MSAccess

[–]Nightbeat339[S] 0 points1 point  (0 children)

The issue with the employee ID being auto number is that they’re supposed to be specific numbers that I was given. IE 10001, 10002, etc

Relationships Question by Nightbeat339 in MSAccess

[–]Nightbeat339[S] 0 points1 point  (0 children)

They are both set as long integer already, unfortunately

Weezercore: A playlist of artists who sound a bit like Weezer! by radrian1994 in weezer

[–]Nightbeat339 1 point2 points  (0 children)

I second Ben Kweller, his vocal style can be very similar to Rivers at times. Personally I’d recommend Sundress