Search results

Okay, So bar your suggestions re letters (as I am unsure entirely what you mean) I've taken your other points into suggestion. *I've not touched either Block_Letter or Canvas_Letter *Renamed duplicate fields in tables to give a clear understanding they're separate fields for separate values...

I must have missed this as all I see re letters/numerated field names in your reply is below. Which is done, they're in a new table. separate tables for addresses/letters? Can you clarify? The only other way I can imagine making the table is to have two fields for the letters, ie LetterNum...

Hi Plog, I appreciate this topic has digressed massively as evidently my entire view of the DB was wrong before. Following from your advice we scrapped our previous DB and are going to begin from the start, merging two Databases into one to better control the data. A much cleaner DB has been...

Cheers, I'll crack on with that. I am working on other things as (as you can tell) writing DB's is not my primary job. I'll respond once the database is split up, (it's an old DB) and I am aware the sections that need splitting since I've learnt more in recent years, just never changed this...

Thanks Plog, The fields in the tables which are related to the letters are Address_1 to Address_5 (5 fields) doubt they'd be useful Date_entered would be useful for calculating the date of the first letter Letter_1_Sent Yes/No same for letters 2-15 Letter_1_Date Date field calculated/filled...

Plog, Thanks for your response, Currently I have nothing as I am unsure how best to go around this. The method you'd describe I assume the dates for the letter would need to be added manually, this is the problem and what I am trying to avoid, but as the date each letter is sent is a variable...

so as an example the following is based on 3 pieces of data added on different dates into the database. The sequence for when letter 1 is sent changes dependent on when the data is added to the DB.

Hi guys, I hope I explain this correctly as it's a bit of an odd one We have data in a table, addresses which need letters sent every at set points during the year, for example Point 1 01/01/20XX Point 2 01/04/20XX Point 3 01/08/20XX This repeats for 5 years (15 letters in total) then it...

You beaut, Thanks Plog A simple & " " & in the middle of the two fields worked flawlessly

Good Afternoon all, I have a query which returns the results/fields needed for a search query containing 3 fields Query name QRY_SearchProp Fields - [Address_1] - [Address_2] - [Postcode] SELECT Table1.ID, Table1.[Address 1], Table1.[Address 2], Table1.Postcode FROM Table1 WHERE...

Well I was completly going about it wrong. This worked beautifully =DCount("[DATE_ENTERED]","[CANVAS_DATA]","[DATE_ENTERED] >=#" & Format([Forms]![Admin_Reports]![txtfrombranch],"mm/dd/yyyy") & "#" & " AND [DATE_ENTERED] <=#" & Format([Forms]![Admin_Reports]![txttobranch],"mm/dd/yyyy") & "#"...

Hi pbaldy, Thanks, I am working with a third criteria and using the link provided I am getting a syntax error, I am sure it's simple but it's bugging me. Thanks =DCount("[DATE_ENTERED]","[CANVAS_DATA]","[DATE_ENTERED] Between #" & Format([Forms]![Admin_Reports]![txtfrombranch],"mm/dd/yyyy")...

Evening guys, I have a DCOUNT on a reporting/stats section of a database. Works fine like it is, current code is =DCount("[DATE_ENTERED]","[CANVAS_DATA]","[DATE_ENTERED] Between #" & Format([Forms]![Admin_Reports]![txtfrom],"mm/dd/yyyy") & "# And #" &...

Yes.... Yes it is, you beauty... Thanks buddy.

This is my current expression for D count but it returns all records. =DCount("[Letter_1_Date]","[CANVAS_DATA]","[Letter_1_Date] Between #" & [Forms]![Admin_Reports]![txtfrom] & "# And #" & [Forms]![Admin_Reports]![txtto] & "#")

Hi guys, Hoping you can help, I have a form in my database with a from date box and to date box. I am trying to count the number of entries in the table between certain dates. Table name CANVAS_DATA Field name LETTER_1_DATE Form name Admin_Reports Date from name txtfrom Date to name txtto I...

that is my last resort, If I can learn an easier and less convoluted way to do it in one report I'd much prefer this.

I want to be able to count the letters sent for each letter (1-5) between each date. So the report has a box that show Letter 1 = XX Letter 2 = XX Letter 3 = XX Letter 4 = XX Letter 5 = XX XX = Letters sent between txtfrom and txtto That's as simple as I can explain it

Hopefully this makes it easier. So I want to filter the report between two dates [txtfrom] & [txtto] to find the letters sent during this period. In this example the period is 06/06/2016 - 12/07/2016 As we can see below I want to count all the letters in the green boxes for each letter...

Sorry I know I explained it badly. Okay. So the form to open the report has two textboxes [txtfrom] & [txtto] Normally it's not a problem as when I have filtered a report before I've used the following text boxes and the on click to load the report to show only data between two dates based on...