Search results

Using Access 2007 Created a form [FRMActivitySelect] to select an item from a dropdown combobox On same form, command button to take me to a report to use this selected item. this is my query code for report SELECT DISTINCT ApptHistTable.DateAttended, [LastName] & ", " &...

I got it figured out. Did an advanced filter and deleted the rows not needed. It is a large table when you factor in it's being queried on every record numerous times. It's in process of being revamped. Not very well designed or user friendly. Thanks for all the input.

Have a db with over 25k records....Yes, I know...:eek: anywho...need to archive older records. I did a make table query to keep it to 2 yr records. Put the table back with less records keeping same name so I don't have to change all the forms, queries, etc. Well,, I get to 1 of the forms...

I ended up having to use the datadd +1 function. It must be Access updates or something. I don't ever remember having to do this before. It was always inclusive.

It has client data in it and would be a hippa violation....

It is a date/time field and populated with Date() and formatted for short date

I'm using Acces 2007 Created a query with a parameter of Between [StartDate] and [EndDate] on a date/time field. If person selects between 03/01/2015 and 03/31/2015 any records with 03/31/2015 are not selected. Isn't the End Date inclusive in the parameter? It's been awhile since I...

I found it as a total field in the form. I am copying all the forms and subforms and changed the name to frmmthly for all the new ones. Thanks for the help.

Well never mind.... I just found it as a hidden field on another form... DUH! :(

=([frmservices_2013].[Form]![sub2013]) I have this expression in a field on a form. It's been a really long time since I worked in Access. is sub2013 a field on a form, in a table? It's doing a running total of a field from a form I can't find a subform with this name, or a field...

I got it... had to show the tabs... Thanks CJ

using tabbed.. it should be there but not...

It is, but still not showing

How do I get the x close button back onto the forms in Access 07? Thanks in advance

I solved this. This was a report based on numerous queries to get final result. I created a new field in the 3 different beginning queries datepart("yyyy",respectivefld) Those fields had to match each other in the remaining queries. Report calls the rptyear parameter which picks up the correct...

How does this get matched by the parameter in the QrySiteAlloc.AllocYr field?

Using Access 07 This is my query SELECT QrySiteAlloc.Site, QrySiteAlloc.AllocYr, QrySiteAlloc.SiteAllocation, Sum(QryReserveTotals.SumOfAddtlAllocationAmt) AS SumOfSumOfAddtlAllocationAmt FROM QrySiteAlloc LEFT JOIN QryReserveTotals ON QrySiteAlloc.Site = QryReserveTotals.Site GROUP BY...

I created an adp..upsized all the tables, etc. The very 1st form which on open of the db contains the network login id did not come over, which results in the db not opening the correct way. Any helpful suggestions? Jennifer :confused:

this is to end up on a report...the dates are already entered in a form..they need to match on the report

running 3 queries together 1 qry has a date parameter of start/end date(running before the 3 are together) Have a field in 1 of the 3 queries with a date field that I need to show being <= the date parameter... How/where do I use this criteria?