Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.52 seconds.
Search: Posts Made By: plog
Forum: Queries 09-17-2019, 03:16 PM
Replies: 7
Views: 98
Posted By plog
Re: Group Mulitple Data Ranges by ID and Plan Code

We need 2 sets of related data:

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

B. Expected results of data in A. Show what data you hope to end up with...
Forum: Tables 09-17-2019, 03:11 PM
Replies: 3
Views: 88
Posted By plog
Re: Calculated fields, hours tracking dates

From first blush your table is set up incorrectly and what you want to do isn't in the right place.

In Access there's a field type called Date/Time, it can hold both Date and time information. ...
Forum: Tables 09-16-2019, 04:55 PM
Replies: 12
Views: 124
Posted By plog
Re: Find out if data one one table exist on another.

Sample data as prescribed please.
Forum: Tables 09-16-2019, 03:31 PM
Replies: 12
Views: 124
Posted By plog
Re: Find out if data one one table exist on another.

A few things about what you've provided:

1. Both tables have the same name (tbl_noticesinfo). Is that correct? Are they in different databases?

2. Is their any way to narrow down the...
Forum: Tables 09-12-2019, 08:26 AM
Replies: 5
Views: 102
Posted By plog
Re: Convert/split delimited field into normalised table

If there are at most just 2 urls seperated by semi colon in a field, then you can do this with just queries. If more than that its going to take code.

In either case, first import the file/data...
Forum: Queries 09-12-2019, 08:02 AM
Replies: 5
Views: 86
Posted By plog
Re: Invalid Use of Null.. Cannot find it

Don't give us the blueprints of the building that has a door that won't close, show us the building itself.

What you gave us is how you build the string that becomes the SQL that will run. Show...
Forum: Queries 09-12-2019, 06:03 AM
Replies: 3
Views: 85
Posted By plog
Re: SQL not working

Use a DCount (https://www.techonthenet.com/access/functions/domain/dcount.php). It solves the problem of the record not existing--it returns 0 in those cases.

Also, are you sure you want an...
Forum: Queries 09-10-2019, 11:55 AM
Replies: 9
Views: 116
Posted By plog
Re: Get Current Employee Rate based on date

Don't do that. It's called a date/time field for a reason--it can hold a date and a time. So get rid of the WorkDay fields and just put the date in with TimeIn and TimeOut. No need to concatenate...
Forum: Queries 09-10-2019, 11:24 AM
Replies: 9
Views: 116
Posted By plog
Re: Get Current Employee Rate based on date

I don't know if you are doing unneccesary work because I don't understand what you are doing.



Confused. Why does each record have 2 dates in it? Does TimeIn go with WorkDay1 and TimeOut go...
Forum: Queries 09-10-2019, 10:49 AM
Replies: 9
Views: 116
Posted By plog
Re: Get Current Employee Rate based on date

Since you asked that specifically, yes:


SELECT tblPayDetails.EMPID, tblPayDetails.WorkDay, Max(tblERates.EffectiveDate) AS MapEffectiveDate
FROM tblERates INNER JOIN tblPayDetails ON...
Forum: Queries 09-06-2019, 08:49 AM
Replies: 5
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: Modules & VBA 09-04-2019, 08:30 AM
Replies: 7
Views: 173
Posted By plog
Re: Combine two tables together and get a total sum with criteria

I think you need to start over with your tables, they are not set up properly. You have 3 tables: [Final Product], [Buyer] and [Shipment] who share way too many fields.

Every field in [Shipment]...
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: Queries 08-27-2019, 03:43 PM
Replies: 9
Views: 148
Posted By plog
Re: List ID's with multiple values in same column

I don't think that SQL works. For every field in the SELECT it must either be in the GROUP BY or be contained within an aggregate function (SUM, COUNT, MAX, etc) in the SELECT. You have one field...
Forum: General 08-23-2019, 11:44 AM
Replies: 21
Views: 300
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 08-23-2019, 11:37 AM
Replies: 17
Views: 236
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 08-23-2019, 09:13 AM
Replies: 17
Views: 236
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 08-23-2019, 07:31 AM
Replies: 21
Views: 300
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: 300
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 08-22-2019, 05:36 AM
Replies: 2
Views: 60
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: 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: Modules & VBA 08-11-2019, 04:04 PM
Replies: 28
Views: 659
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: 115
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: 633
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...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 01:50 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