Recent content by pnpez

I was able to change it thru "record source" in properties when I clicked on the top left of the report. It appears that it is running okay. I only had to make a few changes to the names of the fields. Thanks for your help. Paul

Hello, I am creating many reports that are essentially the same, with a few tweaks. So is there a way to change the control source in a report, meaning change it from table-x to table-z, but keep the report in tact, because many of the field names are identical? Thanks

Thank you. That was quite helpful

Is anyone having an issue with a query not saving the sort order? The only way I know to sort is to list the field in the query, check it off as "show field", then choose it a 2nd time and sort "ascending" and uncheck it for "show field." So the field is listed twice but only shows in the...

Sorry, I got it now. I'll give it a try. Thanks for your help. Paul

Sorry, but the link pointed me to DLookup formulas. That's not what I'm trying to do. I also searched within the site but couldn't find a common issue. Thanks

Hello, I have the following DSum that works fine until I add a Paid Date criteria. The field Paid Date is formatted "Date/Time" in the table. AE CTAS By DateT: IIf([GeneralManager]="No RVP" Or [GeneralManager]="",0,DSum("[Service Commission].[NetSale]","Service Commission","[ID] <= " &...

Sorry about the confusion. ID is the primary key. The records will be sorted by the 3 fields, (AE, Type, LFType). The cells in red are just indicating that these are the ones changing from what was in the "Current NO." column, nothing more.

Hello All, I have a query attached that I wish someone could help me with. Unfortunately, I don't use VBA coding. The first thing that needs to happen is whenever a NO."1" appears after a "0", then the NO. must change to "1" . This occurs for as long as ALL of the 3 fields (AE, Type, LFType)...

Hey Alan, This doesn't seem to be working on multiple groupings. For instance, if you add a field named "Gender" to your query, so if you have REP, Month, Gender, FY01, FY02 and you want to subtotal on the REP and just the males, I can't get that to work. Any suggestions? Thanks

For what ever reason clicking on the address you posted produced much better results than copying and pasting the shortcut. Anyway, the video was quite helpful, so I just need to apply it to what I'm trying to do. Yikes!!! Thanks very much.

Says "Website not yet available"

I have a query that I need to do a subtotal in, but so far can only figure out how to do a running sum. I can't do this in a report because of other things running. The running sum would be fine if I could figure out how to only show the last total amount of the group, and NOT each record's...

Sorry, but I don't have SQL programming knowledge.

I have 2 queries that create 2 separate tables, A and B. The 2nd query is dependent on the answers from table A, made from the 1st query. I put a calculation in X-field in the 1st query, but the resulting answer in table B formats this X-field as text, no matter what I try. I'm not great...