Search results

Using a subquery seems overly complex when a simpler SQL statement should meet the stated requirements.

If I was going to create a solution for this, I would probably create a generic function that would accept a date, a time period like week or month, an offset of periods (positive or negative), and the day of week. The returned date would be a specific day of the week, x number of weeks or...

To get the most recent payment for each payer your query would be a totals query grouping on FkDemoID and returning the Max of the GiftDate. This can be combined with the demographics table if you need additional data.

Is there any code/VBA in the form? Are there any unique types of controls? Is the recordsource a table or plain vanilla query?

2/23/2025 isn't a Saturday. Did you try the query? It seemed to work for me with all the dates in the Northwind Orders. Open the immediate window and enter: ?DateAdd("d",-Weekday(#2/18/2025#-2),#2/18/2025#) and ?DateAdd("d",-Weekday(#2/18/2025#-2),#2/18/2025#)+5 You should return the requested...

I'm at a loss trying to understand your application.

If the date is a Monday, do you want the previous Monday to be the entered date or a week prior? Using the Orders table in Northwinds, this query should provide the OrderDate and the previous Monday - Saturday SELECT Orders.OrderDate, DateAdd("d",-Weekday([OrderDate]-2),[OrderDate]) AS...

I would use VBA to export the query results to a CSV file and then open the Word document. The Word document will use the CSV file.

It would be easy to remove the parameter and test. I usually export a query to a text/delimited file from Access and then open the Word document.

You could have the subform be invisible until the CustomerName is entered/selected on the main form. You would probably want to make the subform visible in the On Current if the CustomerName wasn't blank.

What did you try when presented with the Login form? Did you try click on the OK button or Cancel? What happened?

Have the user enter “s” for space and then handle it in you code.

It looks like the crosstab is doing what you asked it to do. Can you provide a screen shot or other of what you expect/want?

I would use the Microsoft print to PDF.

You now mention “importing”. What do you mean by this?

Sounds like an issue with margins. Are you suggesting there is a significant difference between the print preview and the pdf? Can you explain “shrinks the pages”?

I just left for a week vacation with only phone and iPad. I’ll have to look at this in a week or so. Is there a good reason why there activity yes and activity no fields rather than a single field?

Can you provide more information about your tables and relationships? Are you wanting to open a filtered form or report? Have you created the form/report?

Try Crystal Longs tutorials.

You can create joins with like although the join can't be represented in design view. I created a small table [tblCompanyNameParts] with a short text field [CompanyPart] and added a couple records with values "co" and "ow". I then created a query: SELECT Companies.CompanyID...