Narender Sagar
Last Activity: Jan 1 '24, 04:56 AM
Joined: Jul 19 '11
Location: India
-
I think, your question is not clear enough. You need to explain it more to resolve your issue. -
So, what is the problem you are facing?Leave a comment:
-
I think, your question is not properly explained. Why are you dividing [date] with 365.25? Can you please explain your objective of dividing this?Leave a comment:
-
Narender Sagar replied to Need query to show status on first day of month but data has dates throughout month.in AccessI would do it in two queries.In first query, I'll extract the Month from the given date.
(where Test is the name of your table. Similar way, You may also need to extract Year from the date, if required)Code:SELECT Test.RecordNum, Test.RDate, Test.EmpNum, Test.Status, Month([RDate]) AS RMonth FROM Test;
Then choose above query and make another query :
...Code:SELECT TestQry2.RMonth, Count(TestQry2.EmpNum) AS CountOfEmpNum,
Leave a comment:
-
If you already have numbers (1, 2, 3..) in a column, then a simple solution can be.. just create a separate table wherein you can maintain two fields such as 'Number' and 'Ordinal Text' (numbers and their ordinal form-like 1st, 2nd etc.). Simply join these two tables in a query and you can get the desired result wherever you want.Leave a comment:
-
You can try with Access 2016 Run-Time.Leave a comment:
-
Narender Sagar replied to How to add the data into the table or forms that had been created in Access?in AccessData is always stored in tables, either directly adding in tables or through forms or queries. You need to give more details to the group like what kind of error you are getting while adding data.Leave a comment:
-
Hi, I think your question is not clear enough. What do you mean by "the output needs to read as "X"."..?Leave a comment:
-
There must be some error message or something to know the problem.Leave a comment:
-
Dear all,
How to initialize the value in this code, because whenever I open this query, the values are getting multiplied exponentially.Leave a comment:
-
Oh! I removed one calculated column from the query and result was perfect. Thanks, matter resolved.Leave a comment:
-
Hi, I was trying to use this code in my query, but I'm also getting duplicate running sum. I'm not able to understand, which groupings I need to remove! Can you please help to fix this.
ThanksLeave a comment:
-
It happens when, after running a query, if you do some 'sorting' of data, access will ask for Parameters two times, every time you re-run it. (Remember, I'm not talking about sorting in design view of the query).
Fix of this is, just carry out sorting in design view and save your query. It will not ask for the parameters twice.Leave a comment:
-
HI
Your question is not clear enough to give any input
Please elaborate..Leave a comment:
-
Dear Siyal,
Pivot table for running total does not make sense.
Please elaborate your actual requirement.Leave a comment:
-
I think you are asking too many questions in a single statement.
e.g. you want some report to create and also want to know about how to maintain the data in the form
I'd suggest, first of all, list down your requirements.
Also list down the master data tables you'd require to create.
e.g. If you want Holidays columns to appear as red color, then you need to create a Holiday Table in which you'll maintain the Holidays....Leave a comment:
-
Hi Mark,
Create new fileds in query with if statement.
Something like :
and similarly for StartDate...StartDtCode:EndDt: iif([EndDate] is null,0,[EndDate])
then subtract these fields.. and checkCode:StartDt: iif([StartDate] is null,0,[StartDate])
Leave a comment:
-
Hi BM
I am ok with Hindi, however, this group is for the benefit of all having similar problem. So person from other part of world may not be able to understand. So I'd request you to use English language only.
I still does not understand what do you mean by ""cod" फिल्ड में अंकित उस item के पिछले...Leave a comment:
-
I think, Multi value field is created only if one student/person can have multiple disabilities. If yes, then multi value field should be created. Otherwise, the table structure itself is wrong. You can create a simple lookup field, which can be linked with another table maintained for different types of disabilities.Leave a comment:
-
Dear BM Lal
I think your question is not clearly described.
I presume what you are trying to accomplish is, in your purchase order form, if you add Item ring, then its respective COD value should get auto-populated. Is this the case?Leave a comment:
No activity results to display
Leave a comment: