Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.19 seconds.
Search: Posts Made By: plog
Forum: Queries 09-06-2019, 08:49 AM
Replies: 6
Views: 119
Posted By plog
Re: Union query asking to Enter Parameter Values

The short answer is, you don't have SL_ACC_USER1, SL_ACC_USER2, SL_ACC_USER3 in one or more of your queries. Perhaps you mistyped it, perhaps it doesn't exist at all.

To fix this you need to...
Forum: Queries 08-30-2019, 06:54 AM
Replies: 16
Views: 243
Posted By plog
Re: Are UDFs in queries a bad idea?

I think you're propagating a spam post on another forum. Google the first words of the quoted posted ("111 Power Access Queries/SQL Examples"). The entire text is from a site selling the 111...
Forum: General 08-23-2019, 11:44 AM
Replies: 21
Views: 301
Posted By plog
Re: Table Design Multiple same name cities in state

Your drowning me. 709 words in your first post, 256 words in your second post, 338 words in your latest post. Worse, this is the first sentence of your first post:



No where in the...
Forum: General 08-23-2019, 07:31 AM
Replies: 21
Views: 301
Posted By plog
Re: Table Design Multiple same name cities in state

I can't see your idea through the forest of jargon you've used. Perhaps you can dumb that down or demonstrate your issue via sample data.
Forum: General 08-23-2019, 06:50 AM
Replies: 21
Views: 301
Posted By plog
Re: Table Design Multiple same name cities in state

You're over-normalizing things, you don't need those tables to relate.

Presumably, in whatever table you are storing your actual data, you would have a CityID field which is a foreign key to...
Forum: General 08-16-2019, 08:43 AM
Replies: 14
Views: 256
Posted By plog
Re: Struggling with an Inventory Tacking DB

That was kind of helpful, I was really hoping for the Relationship tool. So, I made it and its a spider web (See attached).

There should only be one way to trace a path between tables. In the...
Forum: General 08-16-2019, 07:54 AM
Replies: 14
Views: 256
Posted By plog
Re: Struggling with an Inventory Tacking DB

You did a great job of posting the context of your issue and the issue itself. I think the next step is that you have to build what you think is your structure, set up the relationship tool and...
Forum: Reports 08-07-2019, 10:47 AM
Replies: 6
Views: 177
Posted By plog
Re: Two Headers on same report page - Possible?

Punice, words aren't working. Perhaps you can make a mock-up of what you hope the report looks like. Either in Word, Excel or even Paint.
Forum: General 07-31-2019, 08:08 AM
Replies: 7
Views: 144
Posted By plog
Re: Ranking of Finishers with equal time

Do this with a DCount (https://www.techonthenet.com/access/functions/domain/dcount.php). You just count the number of competitors that have a better time than them and add 1 (so the first person...
Forum: Modules & VBA 07-29-2019, 05:37 AM
Replies: 23
[SOLVED] Date interval
Views: 385
Posted By plog
Re: Date interval

Try and then post back here your code when/if it doesn't work and explain the manner in which it doesn't work (error code, unexpected results, etc.)
Forum: Modules & VBA 07-28-2019, 05:08 PM
Replies: 23
[SOLVED] Date interval
Views: 385
Posted By plog
Re: Date interval

Yes.

Now which one do you prefer and why not try it?
Forum: Queries 07-26-2019, 05:44 AM
Replies: 9
Views: 167
Posted By plog
Re: Weekly monitor based on query result

That link doesn't show how to use the macro, this one is better:
...
Forum: Queries 07-26-2019, 05:35 AM
Replies: 9
Views: 167
Posted By plog
Re: Weekly monitor based on query result

You can open Access directly in task scheduler and have this work. You just need to pass the Macro as a parameter. Here's how we did it:

1. Build VBA function to export queries to file, compose...
Forum: Queries 07-19-2019, 01:47 PM
Replies: 14
Views: 189
Posted By plog
Re: Advanced SubQuery for totals in graph

Perfect and Guus was right--you need a cross-tab. I did this in 2 queries, the first SQL is this:

SELECT Year([PCL_Date]) AS CallYear, Month([PCL_Date]) AS CallMonth, PressCallLog.PCL_Category,...
Forum: Modules & VBA 07-17-2019, 01:53 PM
Replies: 16
Views: 334
Posted By plog
Re: Summing date ranges

Now you've significantly moved the goalposts, this isn't what you listed initially. Your first post just wanted to calculate total days over multiple rows without criteria. Now you want to apply...
Forum: General 07-12-2019, 12:09 PM
Replies: 4
Views: 157
Posted By plog
Re: Multi criteria query

Couple things:

1. You have criteria on two different lines, this means you are not using them together (AND) but seperately (OR). Your query returns results that passes just 1 of your criterion....
Forum: Modules & VBA 07-12-2019, 05:41 AM
Replies: 13
Views: 379
Posted By plog
Re: Can it be done??

Even though you are determined to do this the wrong way, I'll try and explain myself better and then leave this thread (no promises on the many other threads you will be opening to maintain and get...
Forum: Modules & VBA 07-11-2019, 08:36 PM
Replies: 13
Views: 379
Posted By plog
Re: Can it be done??

Yes it's possible and you're doing it all wrong.

There's no need to dynamically have a database create tables. There's no need to dynamically name them. There's no need to dynamically build forms...
Forum: Queries 07-01-2019, 02:14 PM
Replies: 18
Views: 278
Posted By plog
Re: MS Query for Using IF ELSE condition to create a table when source table is empty

In this general form this is just wrong. If you have essentially equivocal fields in seperate tables you are storing your data incorrectly. By doing so you are using the table name to differentiate...
Forum: Queries 07-01-2019, 08:37 AM
Replies: 18
Views: 278
Posted By plog
Re: MS Query for Using IF ELSE condition to create a table when source table is empty

Pivotted data should be the final datasource, not an intermediate step. Those final queries can be cross-tabs, but the one we are discussing should not be.

A cross-tab takes values and turns...
Forum: Queries 07-01-2019, 08:22 AM
Replies: 18
Views: 278
Posted By plog
Re: MS Query for Using IF ELSE condition to create a table when source table is empty

So big picture this. What are you doing with this data once its "created"? What's the ultimate object of this task?
Forum: Queries 07-01-2019, 08:14 AM
Replies: 18
Views: 278
Posted By plog
Re: MS Query for Using IF ELSE condition to create a table when source table is empty

I provided no solution and questioned the entire method for this.

Why must data be saved to a table? Seems like an unnececssary hack to achieve what you want. I think SELECT queries are the way...
Forum: Queries 07-01-2019, 07:29 AM
Replies: 18
Views: 278
Posted By plog
Re: MS Query for Using IF ELSE condition to create a table when source table is empty

In Access the place where you generally write queries, can only execute SQL. When we need to do scriptin other than SQL we use VBA. So, you can achieve what you want in Access, its just going to be...
Forum: Queries 06-26-2019, 06:03 PM
Replies: 3
Views: 1,303
Posted By plog
Re: Force zeros to display in a count (totals) query

The query you posted, call it 'sub1'. Now create a new query using it and the table that lists all TestID values-- let's call that table 'TestMain'. JOIN them via TestID fields then change that JOIN...
Forum: Queries 06-21-2019, 12:36 PM
Replies: 2
Views: 215
Posted By plog
Re: Assign % based on EARNED

Use the designer as if you are building a regular query. Bring down all the fields from the Crew table, the PCNT field from that table. Make it an aggregate query (click the Sigma/Summation symbol...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 12:13 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
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