Search results

Also, who cares? Why must your numbers start with a particular value? Autonumbers should only be unique. If you have that they will serve their purpose. If you are using them for another purpose other than uniqueness, you shouldn't. So, what exactly is the issue if they don't start with a...

Disregarding the issues pointed out before, here's all the issues I see with your date logic: Case 48 'All Dates [CkDate] The above will actually work but not for the reasons you think. It's going to resolve to "...WHERE 5/27/2025..." and whenever you don't have an actual comparsion...

Totally agree with jdraw. Here's the 2 codes that set those 2 boxes on your form: ... txtSI_FIFO = Nz(DLookup("[SoldQty]", "[TblFifoSummary]", " [ItemCode] =" & [Forms]![Form1]![Combo1] & " "), 0) ... txtSI_Qry = Nz(DLookup("[SumOfxQty]", "[Query2]", " [InvType] =2 "), 0) ... They are...

Agree with jdraw and also recommend working on populating your tblPropertyTypeAttributes table so we can see your attributes. Some attributes may not need to go into there if they are attributes that all Properties have. For example if you wanted to know the number of bedrooms you wouldn't...

Quit throwing files at us we just want you to explain your data. Here's the last of the help I am giving: What you want for Number Of Repetitions is called a "Running Count" search this for that term and you will find the method to achieve that. What you want for Sum Of Count, is just...

1. AA03 was not the selected partnum I wanted to examine, AA02 was. We are paying attention to you and your issue, please pay attention to our posts. 2. Does that mean you posted incorrect data initially? Row=4, PartNum=AA01, Number of Repetitions =1, Sum of Count=1. Shouldn't they both be...

Boy that was not helpful. You simply removed selected data from your initial screenshot which I have access to. You need to hold my hand verbally and explicitly describe how each value is arrived at. Revisit my question and explain in detail how each value for the specific record I selected...

Walk me through one specific calculation: For Row=5, PartNum=AA02, NOTE=Ready; explain why number of repetitions=2 and Sum of Count=3.

My guess is you put every field in the GROUP BY. You only need to put things in the GROUP BY that you want to....group by: SELECT IDTicket, COUNT(IDTicket) AS Total FROM YourTableNameHere WHERE Status=1 GROUP BY IDTicket If neither June nor I are correct, you need to post what data you...

No, not if you are using a MAKE TABLE query to create a temporary table and just passing a field named 'ID' through to it.

Why is this an aggregate query without any aggregate functions? GROUP BY is most often used for totals (SUM, COUNT, MAX, etc.) but you use none of those functions in the SELECT. The other reason is to use GROUP BY is to eliminate duplicates. Are there duplicates when you don't GROUP BY? If...

Yes very pedantic. I was talking about the extraneous '0' in your post. It doesn't detract from your post or point (in fact, I bet very few even conciously saw it until this sentence explicitly pointed it out), but on this site people can't stop themselves from pointing it out to no real...

The worst, especially on technical sites like this, is when someone feels the pedantic need to point out inconsequential errors that neither correct nor clarify anything and add nothing to the conversation other than showing that the poster geniusly spotted something out of place.

Just initialize FilterSTR to an always true comparison and then whenever you want to add a criterion to it always start it with " AND" FilterSTR = "(1=1)" iif (Isnull(Something)=False) then FilterSTR = FilterSTR & " AND ([Something]='" & Something & "')" iif (Isnull(SomethingElse)=False)...

I suggest you go to Pat Hartman's original numerated response (Post #2) and address what she brought up number by number. Either tell her that you agree with each and every point, or explain why you disagree. Go point by point to each of her numbers in that post. Then we can move on to forms...

That explains the datatype but not what the data represents. What does that date/time represent in the context of each table that field appears in?Why is it necessary? Lasty, and most importantly, you're just throwing things at us. Posted a schema, thoughtful notes were giving, you briefly...

That's one of those questions that if you have to ask it, the answer isn't one you will like. 1. Freelancing is all about personal connections. You need to know someone. And that someone must have a need, must believe you can meet it and have and the ability to get you hired. 2. Big...

I wouldn't call it an addition to Access, closer to a replacement, but not really. Helpful huh? Part of Access is a database, BI is not. BI makes it easy to connect to various data sources--SQL Server, Oracle, Excel, even Access databases. Part of Access is making reports and forms, that is...

There are no records in Responses with a value of "no" in the Responded field. There are a few that have " No", but you are working with a machine and "no" and " No" are entirely different things to it. Look very closely at the characters I put in quote marks above. Don't just stop at the...

How married to your comma separator are you? Would "SS DT" be fine? Or do you need the comma between them when both true? The easy way is no comma, you just string your Iif's together: Trim(IIf([SpecialSS]=True,"SS ") & IIf([SpecialDT]=True,"DT ") & IIf([SpecialSGT]=True,"SGT")) But if you...