Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 500
Search took 6.76 seconds.
Search: Posts Made By: plog
Forum: Queries Today, 10:21 AM
Replies: 2
Views: 57
Posted By plog
Re: Structure of query for multifield search form

How's the returned data to be used? What's the purpose?

I would make a report based on Table1, use VBA to build a filter string based on the inputs and then use that filter string in a...
Forum: General 06-16-2019, 07:41 PM
Replies: 10
Views: 144
Posted By plog
Re: Date() as year only

The term solution implies a problem or an issue. What's the issue or problem you are trying to solve with an archive table?

I think the term "method" is probably more apt. And galaxiom's method...
Forum: Queries 06-16-2019, 09:56 AM
Replies: 9
Views: 158
Posted By plog
Re: Hep with Crosstab field names

In the cross-tab, replace the RejectReason field with this:

Reason: Iif([RejectReason] Like "*exists for the current Transaction", "Record Exists For Current Transaction", [RejectReason])

Forum: Queries 06-13-2019, 05:43 AM
Replies: 5
Views: 77
Posted By plog
Re: Pulling two queries back into one

I bet you can do this with just 2 queries, but for simplicity sake, I suggest 3:

Q1--this exactly the Query 1 you have now.

Q2--this would be based on Table1 and predict...
Forum: Queries 06-12-2019, 01:45 PM
Replies: 10
Views: 165
Posted By plog
Re: Queries to transform this data

Last() will never be part of a solution--any solution. It and First() are horrible functions that don't behave like sane people expect them to. Never use them.

A cross-tab is most likely the...
Forum: Queries 06-11-2019, 01:02 PM
Replies: 4
Views: 88
Posted By plog
Re: Force a zero if it does not exist in crosstab query

I think you are fundamentally approaching this wrong. Unfortunately, I don't know what "this" is.

Crosstabs aren't an intermediate step, they are the finished results. Your crosstabs are...
Forum: Forms 06-06-2019, 09:04 AM
Replies: 5
[SOLVED] Iif and + or
Views: 78
Posted By plog
Re: Iif and + or

In English, that's ambiguous. You need to express that mathematically to be clear. Do you mean:

A: (txt_1>5 OR txt_1<-5) AND txt_2>5000
B: txt_1>5 OR (txt_1<-5 AND txt_2>5000)

When you...
Forum: Queries 06-04-2019, 06:03 PM
Replies: 7
Views: 154
Posted By plog
Re: Union query error

UNION query pro-tip:

Only use SELECT, FROM and UNION clauses in a UNION query. No WHERE, no JOIN, No GROUP BY. Etc.

Use those other clauses (WHERE, JOIN, GROUP BY, etc) before and after the...
Forum: Tables 06-04-2019, 05:54 PM
Replies: 9
Views: 193
Posted By plog
Re: Many to many relationship but with exceptions

Ugh. When you want to discuss technical issues, especially with people not familiar with your technical details you can't casually reference items.

Your Initial post referenced "SystemVersions"...
Forum: Tables 06-03-2019, 10:49 AM
Replies: 9
Views: 193
Posted By plog
Re: Many to many relationship but with exceptions

That doesn't make sense. Normally ( and in this case) junction tables aren't real things, unlike other tables that represent real life entities, junction tables exist to sort out data between other...
Forum: Forms 05-21-2019, 07:59 AM
Replies: 8
Views: 211
Posted By plog
Re: Charts

Is [Scores] actually a numeric field? You can't just go by what your eyes see--you need to dig into the data type that the computer is given for that field.
Forum: Theory and practice of database design 05-21-2019, 07:57 AM
Replies: 8
Views: 203
Posted By plog
Re: Starting Over Database Tables and Relationships

What did you post? Is that your existing database or your attempt at normalization?

I suggest you read up on normalization and work througha few tutorials...
Forum: General 05-21-2019, 07:05 AM
Replies: 2
Views: 163
Posted By plog
Re: Percentages

What you want to accomplish is an integral skill in databases. Therefore, I recommend you really learn this subject, not just get the specific answer to this situation.

What you want is an...
Forum: Forms 05-11-2019, 08:59 AM
Replies: 3
[SOLVED] #Error
Views: 89
Posted By plog
Re: #Error

Programming 101: Divide and conquer.

Put every expression/element of that monstrosity into its own form input to find the culprit.

Set an input to =IsNewRecord()
Set an input to...
Forum: Queries 05-08-2019, 12:08 PM
Replies: 5
Views: 115
Posted By plog
Re: Hide Query Results

Why? This sounds like you've set up your database incorrectly. You don't store calculated values in a table, instead you calculate them in a query and reference the query when you need that value....
Forum: Reports 05-05-2019, 10:20 AM
Replies: 13
Views: 264
Posted By plog
Re: Query

Please demonstrate your issue with data. We will need 2 sets:

A. Starting data from your table. Include table and field names and enough data to cover all cases.

B. Expected results of A. ...
Forum: Queries 04-26-2019, 09:14 AM
Replies: 5
Views: 145
Posted By plog
Re: Can't figure out how to show unique programs in query

Ugh. Data. Data. I need data. Specific data. Data in the results that tie back to the data in the starting data you provide.

With that said, here is a query that will produce exactly the...
Forum: Queries 04-26-2019, 07:53 AM
Replies: 5
Views: 145
Posted By plog
Re: Can't figure out how to show unique programs in query

Lost me. Please demonstrate your issue with data, perhaps a mockup of the form/report.

Include 2 sets of data:

A. Starting data from your table(s). Include table and field names and enough...
Forum: Queries 04-26-2019, 06:08 AM
Replies: 5
Views: 145
Posted By plog
Re: Can't figure out how to show unique programs in query

Can you demonstrate what you want with data? Your explanation seems contradictory:

I mean if a program has 4 different Drill Types, you say you want to show those 4 drill types--how do you...
Forum: Modules & VBA 04-26-2019, 05:12 AM
Replies: 2
Views: 112
Posted By plog
Re: opening_closing_calculations

Your method is incorrect and your database doesn't looked set up to do this correctly.

First, data doesn't get moved around in a database. You don't copy data hither and yon, you relate data and...
Forum: Forms 04-24-2019, 07:22 AM
Replies: 21
Views: 258
Posted By plog
Re: Passing values from one form to another

I wouldn't pass the data, I would create the record and open FormB to that new record.
Here's the broad strokes of the VBA which would live on FormA:

1. Validate data - make sure FormA has data...
Forum: Queries 04-23-2019, 05:03 AM
Replies: 7
Views: 167
Posted By plog
Re: Update Value in table

Nope. You need to build your database correctly. You've just created a point of failure for your data. In one year post your database and I will lay odds that not all calculated totals in table 1...
Forum: Queries 04-19-2019, 11:17 AM
Replies: 14
Views: 215
Posted By plog
Re: Fiscal Year as Column

To confuse matters more, your initial expected results don't make sense:

Starting Data:
Joe Task1 10/1/16 10/30/16
Joe Task1 10/1/17 1/1/18
Joe Task1 10/1/18 2/1/19
Joe Task2 10/1/16 1/1/18
Forum: Queries 04-19-2019, 11:12 AM
Replies: 14
Views: 215
Posted By plog
Re: Fiscal Year as Column

First, don't change terms on us. You have 2 date fields in your SQL, neither of which are called "scheduled date". Second, the above quote uses 2 distinct date fields, yet the SQL you posted with...
Forum: Queries 04-18-2019, 09:52 AM
Replies: 56
Views: 855
Posted By plog
Re: The Val function

1. Structure your tables properly. When you start numbering field names, its time for a new table. Instead of 9 fields to store these values, you need a new table to which you add a new record for...
Showing results 1 to 25 of 500

Forum Jump

All times are GMT -8. The time now is 09:29 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

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