Go Back   Access World Forums > Search Forums

 
Showing results 1 to 17 of 17
Search took 0.19 seconds.
Search: Posts Made By: spet
Forum: Reports 09-06-2019, 05:45 AM
Replies: 1
Views: 159
Posted By spet
Count distinct records on a report

Hello!


I have created a report that contains employee records. An employee can show up twice on the report if they have regular and overtime.


Example:
Emp No Hours Type

100 ...
Forum: Queries 04-30-2019, 07:22 AM
Replies: 4
Views: 112
Posted By spet
Re: Dlookup In Query

Wow! I was overthinking that. Thank you Minty!


This works so much better...
SELECT CheckStubInfo.PatronNo, CheckStubInfo.[BF%], CheckStubInfo.SCC, CheckStubInfo.Bacteria,...
Forum: Queries 04-30-2019, 06:56 AM
Replies: 4
Views: 112
Posted By spet
Dlookup In Query

I'm trying to execute this query to return a value from another table(GradeAQualityAdjustment).

SELECT CheckStubInfo.PatronNo, CheckStubInfo.[BF%], CheckStubInfo.SCC, CheckStubInfo.Bacteria,...
Forum: Queries 04-24-2019, 11:05 AM
Replies: 11
Views: 195
Posted By spet
Re: ROUND Function in Query

Right! What a headache....took me 3 days to figure it out.


I thought I was going crazy.
Forum: Queries 04-24-2019, 10:30 AM
Replies: 11
Views: 195
Posted By spet
Re: ROUND Function in Query

Just an update:


I have been working with a database that was already created and I'm doing modifications to it. I have been trying over and over to use the Round function with no luck. What I...
Forum: Queries 04-18-2019, 09:01 AM
Replies: 11
Views: 195
Posted By spet
Re: ROUND Function in Query

I have tried both of these solution on all 3 fields that I am rounding and still receiving the same error message.
Forum: Queries 04-18-2019, 08:33 AM
Replies: 11
Views: 195
Posted By spet
ROUND Function in Query

Hello, I am receiving the error from my Query below: "Wrong number of arguments used with function in query expression 'Sum(Round([BFPercent]*[Weight]),2) AS BFPounds'. If I remove the ,2 from it the...
Forum: Queries 03-06-2019, 01:52 PM
Replies: 2
Views: 98
Posted By spet
Re: Query to poplulate 3rd field on the fly based on 2 others.

https://access-programmers.co.uk/forums/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAL8AAAGjCAYAAAB9icRSAAAX70lEQVR4nO2dvZHrPJBFmcrayoABrDVx0BpvE/jc8ei+ACYF2shDwfQaFIeNBvgrUULj3lOFevVGoqRWH1IQhnfY/M...
Forum: Queries 03-06-2019, 01:48 PM
Replies: 2
Views: 98
Posted By spet
Query to poplulate 3rd field on the fly based on 2 others.

Good Afternoon,


I have a query that is outputting 2 fields, but I'm wanting to populate the 3rd [Expr1] based on the [PatronNo] and [Main].


If [PatronNo] is empty I was to display [Main] in...
Forum: Queries 03-01-2019, 11:00 AM
Replies: 6
Views: 113
Posted By spet
Re: Help returning query row fields as columns

Thank you all for your help. I was able to back up these queries and use a union query closer to the tables.
I'm new at this! I appreciate all the knowledge.
Forum: Queries 03-01-2019, 09:06 AM
Replies: 6
Views: 113
Posted By spet
Re: Help returning query row fields as columns

There are queries built on queries for multiple types of calculations, the union query worked but I don't want information if it is 0 or null.


SELECT qryMainPatronWithSubs.MainPatron,...
Forum: Queries 03-01-2019, 08:34 AM
Replies: 6
Views: 113
Posted By spet
Re: Help returning query row fields as columns

I suck at trying to explain what I'm doing! Sorry.


Ok, so my query returns 4 different fields. PatronNo, PatronWeight, SubPatronNo, SubPatronWeight. PatronWeight and SubPatronWeight are...
Forum: Queries 03-01-2019, 08:16 AM
Replies: 6
Views: 113
Posted By spet
Help returning query row fields as columns

Below are the results of my query calculating a Main Patron weight and a Sub Patron Weight (two totally different calculations). What I'm trying to attempt is to show both the MainPatron field and...
Forum: Queries 11-13-2018, 09:38 AM
Replies: 3
Views: 140
Posted By spet
Re: Question on calulation in a query

Thank you pbaldy! Makes complete sense now that I found the module holding that public function.
Forum: Queries 11-13-2018, 08:55 AM
Replies: 3
Views: 140
Posted By spet
Question on calulation in a query

Good Morning All,


I'm trying to figure out how someone calculated a field in a query I am working with and I am confused. Here is the calculation:


SCCAmt:...
Forum: Forms 10-05-2018, 11:53 AM
Replies: 2
Views: 93
Posted By spet
Re: Combining multiple fields to populate a combo box with different formats

Thank you so very much! Much easier to accomplish what I want to do than what I was trying.
Forum: Forms 10-05-2018, 09:13 AM
Replies: 2
Views: 93
Posted By spet
Combining multiple fields to populate a combo box with different formats

Hello and thank you all in advance for your help.


I'm currently adding two fields together in a query to populate a combo box that then in return passes those values to a report.


My first...
Showing results 1 to 17 of 17

 
Forum Jump



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