Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.14 seconds.
Search: Posts Made By: plog
Forum: General Today, 11:44 AM
Replies: 15
Views: 134
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: Queries Today, 11:37 AM
Replies: 6
Views: 59
Posted By plog
Re: Count Query

It really depends on how you are using it. do 2 things:

1. Give us a simple (no database jargon) explanation of what it is your organization does. Pretend its career day at an elementary school...
Forum: Queries Today, 09:13 AM
Replies: 6
Views: 59
Posted By plog
Re: Count Query

You've got bigger problems than this query:

...
[Weekly_Challenges]!
[Monday])="X")... AND
((Weekly_StartTime_Challenges.Monday)...


"Monday" should not be in a field name. Doing so means...
Forum: General Today, 07:31 AM
Replies: 15
Views: 134
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 Today, 06:50 AM
Replies: 15
Views: 134
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: Modules & VBA Yesterday, 05:36 AM
Replies: 2
Views: 49
Posted By plog
Re: compare status and return result

You didn't provide table/field names, so I can only give you a general solution. Here it is:

You should have a Status table that translates your description to a Yes/No to determine if a part is...
Forum: General 08-16-2019, 08:43 AM
Replies: 14
Views: 243
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: 243
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: Modules & VBA 08-11-2019, 04:04 PM
Replies: 28
Views: 647
Posted By plog
Re: Help with template

Agree with June. You've not given us enough information in your description nor your database. You can't just jump into the issue you are struggling with and hope we get it--you must tell us in a...
Forum: Queries 08-10-2019, 05:03 AM
Replies: 3
Views: 110
Posted By plog
Re: Help With Sum in Query

Yes, a simple aggregate query:

https://support.office.com/en-us/article/count-data-by-using-a-query-b84cdfd8-07ba-49a7-b067-e1024ccfcca8
Forum: Queries 08-08-2019, 09:19 AM
Replies: 37
Views: 597
Posted By plog
Re: Lookup the value from a previous record

This doesn't really involve looking up a prior record. This is a summation of all records (since the prior one will be based on its prior, which is based on its prior, etc.). What you want is...
Forum: Queries 08-07-2019, 01:03 PM
Replies: 9
Views: 170
Posted By plog
Re: Combine queries

That's not correct. Those queries you posted are adding data to different tables. Why?


INSERT INTO [LRN-1705_WLs] ( [Day], CompWL, CountWL, site_serial, CountyID )
...
INSERT INTO...
Forum: Reports 08-07-2019, 10:47 AM
Replies: 6
Views: 153
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: Queries 08-02-2019, 08:57 AM
Replies: 9
Views: 134
Posted By plog
Re: how to query multiple criteria when one or more are null

Yes. You build your filter string based on the inputs used on the form. The pseudo code would look like this:


str_Filter="(1=1)"

if IsNull(Input1)=False Then str_Filter = str_Filter & "...
Forum: Queries 08-02-2019, 05:09 AM
Replies: 9
Views: 134
Posted By plog
Re: how to query multiple criteria when one or more are null

For situations like this I write a query with no criteria. I use other methods to filter the data upon a button press.

So, this means we need to know how the query's data is intended to be...
Forum: Queries 08-01-2019, 06:47 AM
Replies: 6
Views: 107
Posted By plog
Re: Query not displaying all records

Let's forget about forms for now and get your query to display what you want. You are going to have to demonstrate this with data for us. Please provide 2 sets of data:

A. Starting data in your...
Forum: Tables 07-31-2019, 03:17 PM
Replies: 8
Views: 169
Posted By plog
Re: Help with table structure for parts parts

Using that I created my own image of what your tables and relationship should look like. For clarity, I got rid of tbl_Components, a better name for the table that lists which components go to which...
Forum: Tables 07-31-2019, 02:04 PM
Replies: 8
Views: 169
Posted By plog
Re: Help with table structure for parts parts

This depends on how "size" is defined for each component. Does every component share the same sizes (Small, Medium, Large, etc.)? Or does each component have its own sizes (Screw=1/4, 1/2, 1/8; Dry...
Forum: General 07-31-2019, 08:08 AM
Replies: 7
Views: 133
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: Queries 07-31-2019, 06:44 AM
Replies: 9
Views: 116
Posted By plog
Re: Average based on criteria

Who's that clarifying statement suppose to help?

I explained why the words he used doesn't make sense, why the numbers in his post didn't make sense and why I was unable to deduce what he wanted...
Forum: Queries 07-31-2019, 06:14 AM
Replies: 9
Views: 116
Posted By plog
Re: Average based on criteria

You keep using the term "average" but the mathematical operations you use to demonstrate the calculation you want does not produce an average. Here's the formula for average:

(a1 + a2 + a3 +... +...
Forum: Modules & VBA 07-29-2019, 05:37 AM
Replies: 23
Views: 377
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
Views: 377
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...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 08:55 PM.


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