Search results

Thanks Kabir that sql works, however it doesn't give me what i'm after. what i need to be able to do is see records where the problem date is within 7 days of the last problem date recorded against that customer id. Not records in the last 7 days. Does that make sense?? Cheers Burty

:confused: Is there anyone who can help me Please???

Hi Col Thanks for coming back so quickly in response to your question, The customer can have more than one problem, rather than a number customers with the same problem.

Hi Hope someone can help me with this, i have been using access for a a short time but have come up against something that i'm a bit stuck on. I'm not sure if i'm going about it the right way. What i want to do is create a query based on 1 table, the table records problems logged by a customer...

Hi I'm having a problem with checking code in the VBA window, when i try to run a sub using F5 i get a screen come up titled Macros with the option to create a macro. From what i remember in training this didn't happen. Can Anyone help???

I've managed to sort that out thanks for your help!!

Hi I have been putting the dlookup in the control source of the serial number is that why i have been getting the circular reference?? If i move it for example to the lost focus function that circular ref disappears. However it does return another problem which is "the object doesn't conatin...

I'm not quite sure how to alias, i tried going into properties on the table in the query but it said something like the alias is too long, so i figured i was doing it in the wrong area. Usercode in each table would have the same values, the only difference would be that userinformation would...

I've changed it to =DLookUp("[SerialNumber]","currentequipqry","[Usercode]='" & [forms!frmLogCall!Usercode] & '''') The error i get is #Name? and it's telling me it's a circular reference. The user code is text and is in both the query and the form, however from 2 different tables usercode...

Thanks for your help on that. However I've tried using the Dlookup because i only want to show one row, this is how i've done it:- =DLookUp("[SerialNumber]","currentequipqry","[Usercode]=" & [Usercode]) However it just diplay's error in the serial number feild. Is this because the table...

i'm a begginer at access, so please excuse me if this question is very basic. i have a multiple table select query which shows me which user has which piece of a equipment at that given time. I also have a form that logs any problems the users have with the equipment, what i want that form to do...