Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
CJ_London's latest activity
C
CJ_London
replied to the thread
Delete a record after inform user
.
So little information provided so air code if dcount(“*”, “sometable”, “price=0 and invnum=“ & invnum) then If msgbox (“there are zero...
Apr 17, 2024
C
CJ_London
replied to the thread
Round Up
.
Try ((( [Cost]*1.16/0.75)\50)+1)*50
Apr 17, 2024
C
CJ_London
replied to the thread
basic ticketing system design - suggestions welcome
.
Yes - but no need to store status - if a record exists it is sold, if it doesn’t exist it is available
Apr 16, 2024
C
CJ_London
replied to the thread
Solved
Error with Input Mask
.
Understand perfectly, just asking why do it that way? Your way what is to stop the user entering 2924/1950? So you need validation to...
Apr 13, 2024
C
CJ_London
replied to the thread
Solved
How much computer memory is required to run SQL Server Cloud
.
Suggest provide a link to the article this came from as I suspect it is to do with the machine the server is mounted on, not the...
Apr 13, 2024
C
CJ_London
replied to the thread
Solved
Error with Input Mask
.
If the season is always a year why bother with the second year? You can just have a calculated value in a second control =[season] + 1
Apr 13, 2024
C
CJ_London
replied to the thread
Filter
.
They both share the same IP with @I am alive
Apr 12, 2024
C
CJ_London
replied to the thread
Solved
the expression you entered is too complex
.
that error usually implies a problem with your data - typically a null value. As written, your nested iif function will fail if you...
Apr 11, 2024
C
CJ_London
replied to the thread
How to filter a crosstab query?.
.
not sure how much easier it could be - in the query window on the ribbon Here there are two parameters specified - the first provides...
Apr 10, 2024
C
CJ_London
replied to the thread
Query Data
.
no problems, I'll not assist you in the future in case it offends
Apr 9, 2024
C
CJ_London
replied to the thread
Query Data
.
after over 700 posts you still don't know the basics? left([cust], instr([cust]," ")-1)
Apr 9, 2024
C
CJ_London
replied to the thread
Query Data
.
Don’t you mean inside a left function?
Apr 9, 2024
C
CJ_London
replied to the thread
How to filter a crosstab query?.
.
@ebs17 - think you may be missing the point,. With a crosstab, you must declare the parameter and its data type in a parameter section...
Apr 8, 2024
C
CJ_London
replied to the thread
How to filter a crosstab query?.
.
So where in that sql have you assigned the parameter - see post #5 I would have expected to see something like PARAMETERS [Enter Date]...
Apr 8, 2024
C
CJ_London
replied to the thread
How to filter a crosstab query?.
.
that's for your crosstab - need to see the sql to your qry_Payment query
Apr 8, 2024
Home
Members
Top
Bottom